01.private void button2_Click(object sender, EventArgs e)
02. {
03. string connectionString;
04.
05. connectionString = "Server=localhost;User Id=root; Password=1234; Database=db2; Pooling=false;CharSet=tis620;";
06. connection = new MySqlConnection(connectionString);
07. MySqlCommand cmd = new MySqlCommand("Select * from data Where Id = '"+comp.Text.Trim()+"'",connection);
08. sda.SelectCommand = cmd;
09. dt = new DataTable();
10. sda.Fill(dt);
11. Table1.DataSource = dt;
12.
13. }
14.private void button3_Click(object sender, EventArgs e)
15. {
16.
17.
18. cmdbl = new MySqlCommandBuilder(sda);
19.
20. sda.Update(dt);
21. MessageBox.Show("Save data complete");
22.
23. }
