datagrid server

jojozhuang

于 2006-11-14 11:52:00 发布

阅读量344

点赞数

文章标签： datagrid server delete object asp webform

本文链接：https://blog.csdn.net/jojozhuang/article/details/1383323

版权

< asp:TemplateColumn >

< ItemTemplate >

< asp:LinkButton id = " btnDelete " runat = " server " CommandName = " Delete " Text = " 削除 " ></ asp:LinkButton >

</ ItemTemplate >

</ asp:TemplateColumn >

private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
  }

  private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   if(e.CommandName == "Delete")
   {
    //this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
   }
  }
  private void DeleteRow(string i)
  {
//   string mySelectQuery = "DELETE FROM userinfo where userid=" + i;
//   string myConnectString = "Initial Catalog=testDb;server=ZHUANGRONG;Integrated Security=false;user id=testuser; Pwd=testuser";
//   SqlDataAdapter myDataAdapter = new SqlDataAdapter();
//   SqlConnection myConnection = new SqlConnection(myConnectString);
//   myConnection.Open();
//   SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
//   myCommand.ExecuteNonQuery();
//   myConnection.Close();
//   BindData();
  }

  private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string strUserId = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
   Response.Redirect("WebForm3.aspx?UserId="+strUserId);

  }

  private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   LinkButton btn = (LinkButton)e.Item.FindControl("btnDelete");
   if(btn != null)
   {
    btn.Attributes.Add("onclick", "return confirm('re u sure to delete it?');");
   }
  }