insert numeric records into ms access from c# asp.net

Question

OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = conn;
command.CommandText = "INSERT INTO myTbl ([username],[password],[firstname],[lastname],[mi],[age],[place],[contact])VALUES (?,?,?,?,?,?,?,?)";
command.Parameters.Add("@user", OleDbType.VarChar).Value = txtUsername.Text;
command.Parameters.Add("@psw", OleDbType.VarChar).Value = txtPassword.Text;
command.Parameters.Add("@nm", OleDbType.VarChar).Value = txtName.Text;
command.Parameters.Add("@Lname", OleDbType.VarChar).Value = txtLastName.Text;
command.Parameters.Add("@mIni", OleDbType.VarChar).Value = txtMI.Text;
command.Parameters.Add("@ag", OleDbType.Integer).Value = Convert.ToInt32(txtAge.Text);
command.Parameters.Add("@plc", OleDbType.VarChar).Value = txtPlace.Text;
command.Parameters.Add("@cntct", OleDbType.Integer).Value = Convert.ToInt32(txtContact.Text); ;
command.ExecuteNonQuery();
lblInfo.Visible = true;
lblInfo.Text = "Success";
conn.Close();

This gives me the error Input string was not in a correct format. Please help me out.

this code gives me error, input string was not in correct format. So please help me out. Thanks in advance — user1337815
– user1337815, Commented Apr 17, 2012 at 5:03
Running it through the debugger, which line gives the error? — Jason Down
– Jason Down, Commented Apr 17, 2012 at 5:06
Also, take a look at Int32.TryParse (msdn.microsoft.com/en-us/library/system.int32.tryparse.aspx) as an alternative to Convert.ToInt32. — Jason Down
– Jason Down, Commented Apr 17, 2012 at 5:10
Can you share those values which are you passed to perform your task and you found error of "Input string was not in a correct format" — Ghost Answer
– Ghost Answer, Commented Apr 17, 2012 at 5:43

David · Accepted Answer · 2012-04-17 05:07:59Z

1

Based on the code, and the error, most likely one of the TextBox control's text (txtContact or txtAge) isn't a valid Integer (whole number) value. Ensure that you're validating the input. You should use a RequiredFieldValidator, and either a RangeValidator or RegularExpressionValidator to ensure that the Textbox is not empty and contains valid text.

You might also consider using System.Int32.TryParse() instead of Convert.ToInt32.

answered Apr 17, 2012 at 5:07

David

73.7k19 gold badges134 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saurabh · Accepted Answer · 2012-04-17 05:08:20Z

1

You are converting non integer value to integer value, please check txtAge.Text and txtContact.Text and their values, they should contain value which convert into integer value.

answered Apr 17, 2012 at 5:08

Saurabh

5,7272 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

insert numeric records into ms access from c# asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related