DataGrid中使用编辑按钮列(2005-8-25 (星期四))
瞎弄了一天,一直在围着DataGrid这个控件转.现把做的记录一下:
DataGrid中使用编辑按钮列
1.添加编辑按钮列至DataGrid.
2.针对DataGrid的EditCommand,UpDateCommand,CancelCommand事件写函数.
如下:
private void dgPp_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgPp.EditItemIndex=e.Item.ItemIndex;
dgPp_DataBind();
}
private void dgPp_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgPp.EditItemIndex=-1;
dgPp_DataBind();
}
private void dgPp_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
scom.CommandText="update pingpai set pingpainame=@pMc,tuijian=@pTj,pingpaiorder=@pPx where id=@pId";
scom.Parameters.Add("@pMc",((TextBox)(e.Item.Cells[1].FindControl("tbeMc"))).Text.Trim());
scom.Parameters.Add("@pTj",((CheckBox)(e.Item.Cells[2].FindControl("cbeTj"))).Checked?1:0);
scom.Parameters.Add("@pPx",((TextBox)(e.Item.Cells[3].FindControl("tbePx"))).Text.Trim());
scom.Parameters.Add("@pId",e.Item.Cells[0].Text);
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
dgPp.EditItemIndex=-1;
Page.RegisterStartupScript("","<script>alert('修改成功!')</script>");
dgPp_DataBind();
}
{
dgPp.EditItemIndex=e.Item.ItemIndex;
dgPp_DataBind();
}
private void dgPp_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgPp.EditItemIndex=-1;
dgPp_DataBind();
}
private void dgPp_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
scom.CommandText="update pingpai set pingpainame=@pMc,tuijian=@pTj,pingpaiorder=@pPx where id=@pId";
scom.Parameters.Add("@pMc",((TextBox)(e.Item.Cells[1].FindControl("tbeMc"))).Text.Trim());
scom.Parameters.Add("@pTj",((CheckBox)(e.Item.Cells[2].FindControl("cbeTj"))).Checked?1:0);
scom.Parameters.Add("@pPx",((TextBox)(e.Item.Cells[3].FindControl("tbePx"))).Text.Trim());
scom.Parameters.Add("@pId",e.Item.Cells[0].Text);
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
dgPp.EditItemIndex=-1;
Page.RegisterStartupScript("","<script>alert('修改成功!')</script>");
dgPp_DataBind();
}
其实没什么好说的,下次再用到时可查便可,呵呵!
posted on 2005-10-10 10:11 Waiwai2017 阅读(740) 评论(0) 编辑 收藏 举报