做增删改查网页.docx

查询页面更新删除页面增加页面以下是代码 asp:linkbutton id=cmdfirstpage runat=server commandname=page commandargument=first enabled=首页 asp:linkbutton id=cmdpreview runat=server commandname=page commandargument=prev enabled=前页 第asp:label id=lblcurpage forecolor=blue runat=server text=页/共 asp:label id=lblpagecount forecolor=blue runat=server text=页 asp:linkbutton id=cmdnext runat=server commandname=page commandargument=next enabled=后页 asp:linkbutton id=cmdlastpage runat=server commandargument=last commandname=page enabled=尾页  asp:textbox id=txtgopage runat=server text= width=32px页 -using system;using system.collections.generic;using system.data;using system.data.sqlclient;using system.linq;using system.web;using system.web.configuration;using system.web.ui;using system.web.ui.webcontrols;public partial class _default : system.web.ui.page string constr = webconfigurationmanager.connectionstringsnorthwindconnectionstring.connectionstring; sqlconnection conn; sqlcommand cmd; protected void page_load(object sender, eventargs e) if (!ispostback) conn = new sqlconnection(constr); conn.open(); cmd = new sqlcommand(select distinct age from information, conn); sqldatareader dr = cmd.executereader(); /dropdownlist1数据绑定 dropdownlist1.datasource = dr; dropdownlist1.datatextfield = age; dropdownlist1.databind(); dr.dispose(); conn.dispose(); listitem li = new listitem(全选择, 0); li.selected = true; dropdownlist1.items.add(li); string selectedvalue = dropdownlist1.selectedvalue; if (selectedvalue = 0) bind(); / / 绑定 / private void bind() string selectedvalue = dropdownlist1.selectedvalue; string sqlstr = string.empty; if (selectedvalue = 0) sqlstr = select * from information; else sqlstr = select * from information where age= + selectedvalue + ; conn = new sqlconnection(constr); sqldataadapter dr = new sqldataadapter(sqlstr, conn); dataset ds = new dataset(); conn.open(); dr.fill(ds, information); gridview1.datasource = ds; gridview1.datakeynames = new string id ; gridview1.databind(); conn.close(); / / 查询 / / / protected void btnexecute_click(object sender, eventargs e) bind(); / / 转到zengjia页/ / / protected void button1_click(object sender, eventargs e) response.redirect(zengjia.aspx); / / 取消编辑 / / / protected void gridview1_rowcancelingedit(object sender, gridviewcancelediteventargs e) gridview1.editindex = -1; bind(); / / 编辑 / / / protected void gridview1_rowediting(object sender, gridviewediteventargs e) gridview1.editindex = e.neweditindex; bind(); / / 更新 / / / protected void gridview1_rowupdating(object sender, gridviewupdateeventargs e) textbox text1 = (textbox)(gridview1.rowse.rowindex.cells1.controls0); textbox text2 = (textbox)(gridview1.rowse.rowindex.cells2.controls0); textbox text3 = (textbox)(gridview1.rowse.rowindex.cells3.controls0); textbox text4 = (textbox)(gridview1.rowse.rowindex.cells4.controls0); if (string.isnullorempty(text1.text) response.write(alert(请输入姓名);); return; if (string.isnullorempty(text2.text) response.write(alert(请输入年龄); return; else try int tmp = int.parse(text2.text); catch (exception) response.write(alert(请输入年龄); return; if (string.isnullorempty(text3.text) response.write(alert(请输入地址); return; if (string.isnullorempty(text4.text) response.write(alert(请输入电话号码); return; else if (text4.text.length 11 | text4.text0 = 0) response.write(alert(请输入电话号码); return; else try int64 tmp = int64.parse(text4.text); catch (exception) response.write(alert(请输入电话号码); return; try int ageer = convert.toint32(textbox)(gridview1.rowse.rowindex.cells2.controls0).text.tostring().trim(); conn = new sqlconnection(constr); string sqlstr = update information set name= + (textbox)(gridview1.rowse.rowindex.cells1.controls0).text.tostring().trim() + ,age= + (textbox)(gridview1.rowse.rowindex.cells2.controls0).text.tostring().trim() + ,address= + (textbox)(gridview1.rowse.rowindex.cells3.controls0).text.tostring().trim() + ,phone= + (textbox)(gridview1.rowse.rowindex.cells4.controls0).text.tostring().trim() + where id= + (gridview1.rowse.rowindex.cells0).text.tostring().trim() + ; cmd = new sqlcommand(sqlstr, conn); conn.open(); cmd.executenonquery(); conn.close(); gridview1.editindex = -1; bind(); catch return; /通过跳转页面传递数据id 更新数据 /conn = new sqlconnection(constr); / string id = select id from id where id= + (gridview1.rowse.rowindex.cells0).text.tostring().trim() + ; /response.redirect(zengjia.aspx?id= + (gridview1.rowse.rowindex.cells0).text.tostring().trim() + ); / / 删除 / / / protected void gridview1_rowdeleting(object sender, gridviewdeleteeventargs e) conn=new sqlconnection(constr); string sqlstr=delete from information where id=+ (gridview1.rowse.rowindex.cells0).text.tostring().trim()+; cmd = new sqlcommand(sqlstr, conn); conn.open(); cmd.executenonquery(); conn.close(); gridview1.editindex = -1; bind(); / / 分页 / / / protected void gridview1_pageindexchanging(object sender, gridviewpageeventargs e) gridview1.pageindex = e.newpageindex; bind(); / / 跳转 / / / protected void turn_click(object sender, eventargs e) gridview1.pageindex = int.parse(textbox)gridview1.bottompagerrow.findcontrol(txtgopage).text) - 1; bind(); using system;using system.collections.generic;using system.linq;using system.web;using system.web.ui;using system.web.ui.webcontrols;using system.data;using system.data.sqlclient;using system.web.configuration;using system.text.regularexpressions;public partial class zengjia : system.web.ui.page string constr = webconfigurationmanager.connectionstringsnorthwindconnectionstring.connectionstring; protected void page_load(object sender, eventargs e) /接收传递过来的数据id查询数据绑定到textbox上 再进行更新 /if (!ispostback) / / if (request.querystringid != null) / / button1.text = 更新; / sqlconnection conn = new sqlconnection(constr); / sqlcommand cmd = new sqlcommand(select*from information where id= + request.querystringid+, conn); / conn.open(); / sqldatareader dr = cmd.executereader(commandbehavior.closeconnection); / while (dr.read() / / this.textbox1.text = drname.tostring(); / this.textbox2.text = drage.tostring(); / this.textbox3.text = draddress.tostring(); / this.textbox4.text = drphone.tostring(); / / / / / 增加 / / / protected void button1_click(object sender, eventargs e) /判断用户输入 if (string.isnullorempty(textbox1.text) response.write(alert(请输入姓名); return; if (string.isnullorempty(textbox2.text) response.write(alert(请输入年龄); return; else try int tmp = int.parse(textbox2.text); catch (exception) response.write(alert(请输入年龄); return; if (string.isnullorempty(textbox3.text) response.write