我的码只能删除datagridview里选中的那一行,但是没法删除数据库里的求大神!!!我是少了点什么嘛MySqlConnectioncon=newMySqlConnection("server=localhost;Database=databse;Port=...
我的码 只能删除datagridview里选中的那一行, 但是没法删除数据库里的
求大神 !!! 我是少了点什么嘛
MySqlConnection con = new MySqlConnection("server=localhost;Database=databse;Port = 3306; User ID = root; Password = password123");
MySqlCommand cmd = new MySqlCommand();
private void DeleteBtn_Click(object sender, EventArgs e)
{
con.Open();
MySqlCommand cmd = new MySqlCommand("Delete From tutorials where TutorialName = @name", con);
cmd.Parameters.AddWithValue("@name", this.txtTuName.Text);
cmd.ExecuteNonQuery();
int tn = datalist.CurrentCell.RowIndex;
datalist.Rows.RemoveAt(tn);
con.Close();
}
private void datalist_MouseClick(object sender, MouseEventArgs e)
{
txtTuName.Text = datalist.CurrentRow.Cells[0].Value.ToString();
}
展开