问题描述
asp.net中gridview控件中,怎么用c#语言的代码方式实现编辑、删除数据功能
解决方案
解决方案二:
给你一份编辑和删除的底层代码吧,你自己看着对应自己的进行修改编辑:usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Text;usingMaticsoft.Common;usingLTP.Accounts.Bus;namespaceSouthInfo.Web.ModelCR_SCHEDULE_BACKUP{publicpartialclassModify:Page{protectedvoidPage_Load(objectsender,EventArgse){if(!Page.IsPostBack){if(Request.Params["id"]!=null&&Request.Params["id"].Trim()!=""){stringPID=Request.Params["id"];ShowInfo(PID);}}}privatevoidShowInfo(stringPID){SouthInfo.BLL.BLLCR_SCHEDULE_BACKUPbll=newSouthInfo.BLL.BLLCR_SCHEDULE_BACKUP();SouthInfo.Model.ModelCR_SCHEDULE_BACKUPmodel=bll.GetModel(PID);this.lblPID.Text=model.PID;this.txtBK_DATE.Text=model.BK_DATE.ToString();this.txtUSER_ID.Text=model.USER_ID;this.txtBK.Text=model.BK;}publicvoidbtnSave_Click(objectsender,EventArgse){stringstrErr="";if(!PageValidate.IsDateTime(txtBK_DATE.Text)){strErr+="备份日期格式错误!\n";}if(this.txtUSER_ID.Text.Trim().Length==0){strErr+="人员ID不能为空!\n";}if(this.txtBK.Text.Trim().Length==0){strErr+="备用字段不能为空!\n";}if(strErr!=""){MessageBox.Show(this,strErr);return;}stringPID=this.lblPID.Text;DateTimeBK_DATE=DateTime.Parse(this.txtBK_DATE.Text);stringUSER_ID=this.txtUSER_ID.Text;stringBK=this.txtBK.Text;SouthInfo.Model.ModelCR_SCHEDULE_BACKUPmodel=newSouthInfo.Model.ModelCR_SCHEDULE_BACKUP();model.PID=PID;model.BK_DATE=BK_DATE;model.USER_ID=USER_ID;model.BK=BK;SouthInfo.BLL.BLLCR_SCHEDULE_BACKUPbll=newSouthInfo.BLL.BLLCR_SCHEDULE_BACKUP();bll.Update(model);Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx");}publicvoidbtnCancle_Click(objectsender,EventArgse){Response.Redirect("list.aspx");}}}
删除:usingSystem;usingSystem.Collections.Generic;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Text;usingSystem.Data;usingMaticsoft.Common;usingSystem.Drawing;usingLTP.Accounts.Bus;namespaceSouthInfo.Web.ModelCR_SCHEDULE_BACKUP{publicpartialclassList:Page{SouthInfo.BLL.BLLCR_SCHEDULE_BACKUPbll=newSouthInfo.BLL.BLLCR_SCHEDULE_BACKUP();protectedvoidPage_Load(objectsender,EventArgse){if(!Page.IsPostBack){gridView.BorderColor=ColorTranslator.FromHtml(Application[Session["Style"].ToString()+"xtable_bordercolorlight"].ToString());gridView.HeaderStyle.BackColor=ColorTranslator.FromHtml(Application[Session["Style"].ToString()+"xtable_titlebgcolor"].ToString());btnDelete.Attributes.Add("onclick","returnconfirm("你确认要删除吗?")");BindData();}}protectedvoidbtnSearch_Click(objectsender,EventArgse){BindData();}protectedvoidbtnDelete_Click(objectsender,EventArgse){stringidlist=GetSelIDlist();if(idlist.Trim().Length==0)return;bll.DeleteList(idlist);BindData();}#regiongridViewpublicvoidBindData(){#region#endregionDataSetds=newDataSet();StringBuilderstrWhere=newStringBuilder();if(txtKeyword.Text.Trim()!=""){}ds=bll.GetList(strWhere.ToString());gridView.DataSource=ds;gridView.DataBind();}protectedvoidgridView_PageIndexChanging(objectsender,GridViewPageEventArgse){gridView.PageIndex=e.NewPageIndex;BindData();}protectedvoidgridView_OnRowCreated(objectsender,GridViewRowEventArgse){if(e.Row.RowType==DataControlRowType.Header){}}protectedvoidgridView_RowDataBound(objectsender,GridViewRowEventArgse){e.Row.Attributes.Add("style","background:#FFF");if(e.Row.RowType==DataControlRowType.DataRow){LinkButtonlinkbtnDel=(LinkButton)e.Row.FindControl("LinkButton1");linkbtnDel.Attributes.Add("onclick","returnconfirm("你确认要删除吗")");}}protectedvoidgridView_RowDeleting(objectsender,GridViewDeleteEventArgse){}privatestringGetSelIDlist(){stringidlist="";boolBxsChkd=false;for(inti=0;i<gridView.Rows.Count;i++){CheckBoxChkBxItem=(CheckBox)gridView.Rows[i].FindControl("DeleteThis");if(ChkBxItem!=null&&ChkBxItem.Checked){BxsChkd=true;if(gridView.DataKeys[i].Value!=null){idlist+=gridView.DataKeys[i].Value.ToString()+",";}}}if(BxsChkd){idlist=idlist.Substring(0,idlist.LastIndexOf(","));}returnidlist;}#endregion}}
里面包含了查询,显示,编辑,删除
解决方案三:
哥们确定用的是c#?我怎么看不懂啊!