我用了半天时间,尝试了好多方法,终于成功了,现在把我的方法和大家分享一下:
(1) if (dataGridView1.SelectedRows.Count > 0)
{
string foodname = dataGridView1.SelectedCells[0].Value.ToString();
MySqlConnection conn = BaseClass.DBConn.SaylnConn();
conn.Open();
MySqlCommand cmd = new MySqlCommand(“delete from tb_guestFood where dish_name=’” + foodname + “’ and tableWZ=’” + roomName + “’”, conn);
cmd.ExecuteNonQuery();
conn.Close();
GetData();
}
在上面,selectedCells[0],一定要和datagridview中对应的列相对应,否则回报“索引超出范围。必须为非负值并小于集合大小。”的错误。
我还试过:
(2)
if (this.dgvXiaofei.SelectedRows.Count >= 0)
{
DataRowView drv = dgvXiaofei.SelectedRows[0].DataBoundItem as DataRowView;
drv.Row.Delete();
//数据库中进行相应的删除操作
string dish = this.dgvXiaofei.SelectedCells[1].Value.ToString();//菜名为第二列
MySqlConnection