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; ...