Insert into mySql table with C#
| using System; | |
| using System.Collections.Generic; | |
| using System.ComponentModel; | |
| using System.Data; | |
| using System.Drawing; | |
| using System.Linq; | |
| using System.Text; | |
| using System.Windows.Forms; | |
| using MySql.Data.MySqlClient; | |
| private void cmdAdd_Click(object sender, EventArgs e) | |
| { | |
| MySqlConnection conn=new MySqlConnection(); | |
| MySqlCommand cmd = new MySqlCommand(); | |
| string myConnectionString; | |
| string cmdString; | |
| myConnectionString = "server=127.0.0.1; uid=root; pwd=xxxxxx; database=test"; | |
| cmdString = "insert into t_students(AdmNo,FirstName,LastName) values('" + txtAdmNo.Text + "','" + txtFirstName.Text + "','" + txtLastName.Text + "');"; | |
| try | |
| { | |
| conn.ConnectionString = myConnectionString; | |
| conn.Open(); | |
| cmd.Connection = conn; | |
| cmd.CommandText = cmdString; | |
| cmd.ExecuteNonQuery(); | |
| MessageBox.Show("Record successfully added."); | |
| } | |
| catch (MySqlException ex) | |
| { | |
| MessageBox.Show(ex.Message); | |
| } | |
| finally | |
| { | |
| conn.Dispose(); | |
| } | |
}
=============================================
table definitioncreate table t_students ( AdmNo int unsigned not null, FirstName varchar(30) not null, LastName varchar(30) not null ); ==================================== |

Comments
Post a Comment