111,099
社区成员




MySqlConnection myCon = new MySqlConnection();
myCon.ConnectionString = "server=localhost;port=3306;user=root;password=123456;database=drugstore;";
string cmdText = "select * from drug";
MySqlDataAdapter sda = new MySqlDataAdapter(cmdText, myCon);
MySqlCommandBuilder sb = new MySqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds, "drug");
foreach (DataRow myrow in ds.Tables["drug"].Rows)
{
if (myrow["Dno"].ToString() == textBox1.Text.Trim())
{
myrow["Dname"] = textBox2.Text.Trim();
myrow["Dclass"] = textBox3.Text.Trim();
myrow["Dguige"] = textBox4.Text.Trim();
myrow["Dbrand"] = textBox5.Text.Trim();
myrow["Dprice1"] = Convert.ToSingle(textBox6.Text.Trim());
myrow["Dprice2"] = Convert.ToSingle(textBox7.Text.Trim());
}
}
sda.Update(ds, "drug");
dataGridView1.DataSource = ds.Tables[0];