Inserting a name into a MySql database via an ASP.net web Application

impakecepsish

New Member
I am having a problem in inserting characters such as a name into a mySql database via an Asp.net application. If I inserted numbers, the app adds the numbers into the database and I can see them, but the case with names, the name column in the database shows no values (keeps on showing null values) along with the numbers added.\[code\]command2 = New MySqlCommand("INSERT INTO customer(Customer_id, Customer_name) VALUES (@Customer_id, @Customer_name)", Connection) // Connection Stringcommand2.Parameters.AddWithValue("@Customer_id", SqlDbType.Int).Value = http://stackoverflow.com/questions/5051362/TextBox1.Text() //assign valuescommand2.Parameters.AddWithValue("@Customer_name", SqlDbType.VarChar).Value = http://stackoverflow.com/questions/5051362/TextBox2.Text() //assign values\[/code\]I appreciate it if you can help me with thisRegards,DoN
 
Back
Top