我如何从DataGrid和数据库中删除行 [英] How i can Delet Row from datagrid And database

问题描述

我使用此代码从数据库中删除选定的数据网格，但不是删除

i use this code to delete selected datagrid from data base but it is not delete

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
   DataGridViewRow dr = dataGridView1.Rows[i];
   if (dr.Selected == true)
   {
      dataGridView1.Rows.RemoveAt(i);
      try
      {
         SqlCommand cmd = new SqlCommand("Delete from calender where ID= ' " + i + "'", con);     
         cmd.ExecuteNonQuery();
         con.Close();
      }
      catch (Exception ex)
      {
         MessageBox.Show(ex.ToString());
      }
   }
}

[edit]添加了代码块并修复了索引[/edit]

[edit]code block added and indexation fixed[/edit]

推荐答案

嗨
在查询中删除单引号和双引号之间的空格后，您是否可以尝试.
I.E

Hi
Can you try after removing space between single quotes and double quotes from query.
I.E

SqlCommand cmd = new SqlCommand("Delete from calender where ID= '" + i + "'", con);

这篇关于我如何从DataGrid和数据库中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！