首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

winfrom datagridview 删除选中的一行,现功能能用,想在删除的时候弹出确认按钮。解决办法

2012-03-28 
winfrom datagridview 删除选中的一行,现功能能用,想在删除的时候弹出确认按钮。代码:private void btDel_C

winfrom datagridview 删除选中的一行,现功能能用,想在删除的时候弹出确认按钮。
代码:
  private void btDel_Click(object sender, EventArgs e)
  {
  try
  {
  string connString = "Server=10.10.0.5;Database=xianggelia;User Id=sa;Password=12345678;";
  string sql = "delete from EquManager where 1=1";
  if (dataGridView1.CurrentRow.Selected)
  {
  sql = sql + "and Id=" + Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
  }
  int n = 0;
  SqlConnection conn = new SqlConnection(connString);
  SqlCommand cmd = new SqlCommand(sql, conn);
  conn.Open();
  n = cmd.ExecuteNonQuery();
  conn.Close();

  if (n < 0)
  {
  label1.Text = "删除成功";
  }

  else
  {
  label1.Text = "删除失败";
  }

  }
  catch (Exception ex)
  {
  MessageBox.Show("开啥子玩笑,删啥呢!", "提示");
  return;
  throw ex;
  }
  Refresh();
  shuliang.Text = "当前数量为:" + dataGridView1.Rows.Count.ToString();
  }

[解决办法]

C# code
DialogResult dlResult = MessageBox.Show(this, "要删除这些记录吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);                if (dlResult == DialogResult.Yes)                {                    try  {  string connString = "Server=10.10.0.5;Database=xianggelia;User Id=sa;Password=12345678;";  string sql = "delete from EquManager where 1=1";  if (dataGridView1.CurrentRow.Selected)  {  sql = sql + "and Id=" + Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());  }  int n = 0;  SqlConnection conn = new SqlConnection(connString);  SqlCommand cmd = new SqlCommand(sql, conn);  conn.Open();  n = cmd.ExecuteNonQuery();  conn.Close();  if (n < 0)  {  label1.Text = "删除成功";  }  else  {  label1.Text = "删除失败";  }  }  catch (Exception ex)  {  MessageBox.Show("开啥子玩笑,删啥呢!", "提示");  return;  throw ex;  }  Refresh();  shuliang.Text = "当前数量为:" + dataGridView1.Rows.Count.ToString();                } 

热点排行