DataGrid经典编辑更新删除代码

最新推荐文章于 2023-06-06 18:19:48 发布

疾风铸境

最新推荐文章于 2023-06-06 18:19:48 发布

阅读量1.3k

点赞数

分类专栏： ASP.NET 文章标签： datagrid textbox object email string

本文链接：https://blog.csdn.net/xqf222/article/details/1859525

版权

ASP.NET 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   DataGrid1.EditItemIndex=(int)e.Item.ItemIndex;
   BindGrid();
  }

  private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
   DataGrid1.CurrentPageIndex=e.NewPageIndex;
   BindGrid();
  }

  private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   SqlCommand cm=new SqlCommand("deleteEmp",mySqlConn);
   cm.CommandType=CommandType.StoredProcedure;
   cm.Parameters.Add(new SqlParameter("@Empid",SqlDbType.Int,4));
   cm.Parameters["@Empid"].Value=DataGrid1.DataKeys[(int)e.Item.ItemIndex];

   cm.Connection.Open();
   try
   {
    cm.ExecuteNonQuery();
    Label1.Text="删除成功";

   }
   catch(SqlException)
   {
    Label1.Text="删除失败";
    Label1.Style["color"]="red";
   }
   cm.Connection.Close();
   BindGrid();
  }

  private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   DataGrid1.EditItemIndex=-1;
   BindGrid();
  }

  private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   SqlCommand cm=new SqlCommand("UpdateEmp",mySqlConn);
   cm.CommandType=CommandType.StoredProcedure;

   cm.Parameters.Add(new SqlParameter("@Email",SqlDbType.VarChar,50));
   cm.Parameters.Add(new SqlParameter("@tell",SqlDbType.VarChar,50));
   cm.Parameters.Add(new SqlParameter("@jb",SqlDbType.Int,4));
   cm.Parameters.Add(new SqlParameter("@Emp_id",SqlDbType.Int,4));
   string colvalue=((TextBox)e.Item.Cells[4].Controls[0]).Text;
   cm.Parameters["@Email"].Value=colvalue;

   colvalue=((TextBox)e.Item.Cells[5].Controls[0]).Text;
   cm.Parameters["@jb"].Value=colvalue;
   colvalue=((TextBox)e.Item.Cells[6].Controls[0]).Text;
   cm.Parameters["@tell"].Value=colvalue;

   cm.Parameters["@Emp_id"].Value=DataGrid1.DataKeys[(int)e.Item.ItemIndex];
   cm.Connection.Open();
   try
   {
    cm.ExecuteNonQuery();
    Label1.Text="编辑成功";
    DataGrid1.EditItemIndex=-1;
   }
   catch(SqlException)
   {
    Label1.Text="编辑失败";
    Label1.Style["color"]="red";
   }
   cm.Connection.Close();
   BindGrid();
  }