C# DatagridVIew 删除SQL日期

Question

我如何在 C# 的 datagridview 中从 MYSQL 中删除一个 SELECTED(CHECKED) 数据？

我的代码:

 string CONFIG = "server=localhost;userid=root;password=admin;database=program";
 MySqlConnection cone = new MySqlConnection(CONFIG);

 MySqlCommand query2 = new MySqlCommand();
 query2.Connection = cone;
 query2.CommandText = "DELETE FROM TABLE WHERE ID = @ID";
 // I believe the key from this problem stay in line below//
 query2.Parameters.AddWithValue("@ID", gridMovie.SelectedRows);

  cone.Open();
  query2.ExecuteNonQuery();
  cone.Close();

Answer 1

gridview 的 SelectedRow 属性给出整行。所以你需要提供列值(在你的情况下它是 ID)-

query2.Parameters.AddWithValue("@ID", gridMovie.SelectedRow
                 .Cells[indexofIDcolumn].Value)