ado.net - asp.net grid view edit and delete records -
i trying use grid view display items database want edit , delete these records in grid view, using sample code on asp.net snippets
it says name 'getdata' not exist in current context
using system; using system.collections.generic; using system.configuration; using system.data; using system.data.sqlclient; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; public partial class default10 : system.web.ui.page { sqlcommand comm; string connectionstring = configurationmanager.connectionstrings["databaseconnectionstring1"].connectionstring; protected void page_load(object sender, eventargs e) { if (!ispostback) { binddata(); } } private void binddata() { comm = new sqlcommand("select employeeid,name,password" + " employee"); gridview1.datasource = getdata(comm); gridview1.databind(); } protected void editemployee(object sender, gridviewediteventargs e) { gridview1.editindex = e.neweditindex; binddata(); } protected void canceledit(object sender, gridviewcancelediteventargs e) { gridview1.editindex = -1; binddata(); } protected void updateemployee(object sender, gridviewupdateeventargs e) { string employeeid = ((label)gridview1.rows[e.rowindex] .findcontrol("lblemployeeid")).text; string name = ((textbox)gridview1.rows[e.rowindex] .findcontrol("txtname")).text; string password = ((textbox)gridview1.rows[e.rowindex] .findcontrol("txtpassword")).text; comm = new sqlcommand(); comm.commandtype = commandtype.text; comm.commandtext = "update employee set name=@name," + "password=@password employeeid=@employeeid;" + "select employeeid,name,password employee"; comm.parameters.add("@employeeid", sqldbtype.varchar).value = employeeid; comm.parameters.add("@name", sqldbtype.varchar).value = name; comm.parameters.add("@password", sqldbtype.varchar).value = password; gridview1.editindex = -1; gridview1.datasource = getdata(comm); gridview1.databind(); } protected void deleteemployee(object sender, eventargs e) { linkbutton lnkremove = (linkbutton)sender; comm = new sqlcommand(); comm.commandtype = commandtype.text; comm.commandtext = "delete employee " + "employeeid=@employeeid;" + "select employeeid,name,password employee"; comm.parameters.add("@employeeid", sqldbtype.varchar).value = lnkremove.commandargument; gridview1.datasource = getdata(comm); gridview1.databind(); } }
you using old coding replace code code..
using system; using system.collections.generic; using system.configuration; using system.data; using system.data.sqlclient; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; public partial class default10 : system.web.ui.page { sqlcommand comm; sqlconnection connectionstring = configurationmanager.connectionstrings["databaseconnectionstring1"].connectionstring; protected void page_load(object sender, eventargs e) { if (!ispostback) { binddata(); } } private void binddata() { connectionstring.open(); comm = new sqlcommand("select employeeid,name,password employee", connectionstring); datatable dt =new datatable(); sqldataadapter adp= new sqldataadapter(comm); adp.fill(dt); connectionstring.close(); gridview1.datasource =dt; gridview1.databind(); } protected void editemployee(object sender, gridviewediteventargs e) { gridview1.editindex = e.neweditindex; binddata(); } protected void canceledit(object sender, gridviewcancelediteventargs e) { gridview1.editindex = -1; binddata(); } //you should write code on rowupdating , give command name 'update' link button protected void updateemployee(object sender, gridviewupdateeventargs e) { //start here string employeeid = ((label)gridview1.rows[e.rowindex] .findcontrol("lblemployeeid")).text; string name = ((textbox)gridview1.rows[e.rowindex] .findcontrol("txtname")).text; string password = ((textbox)gridview1.rows[e.rowindex] .findcontrol("txtpassword")).text; connectionstring.open(); comm = new sqlcommand("update employee set name=@name,password=@password employeeid=@employeeid", connectionstring); comm.parameters.addwithvalue("@employeeid", employeeid); comm.parameters.addwithvalue("@name", name); comm.parameters.addwithvalue("@password", password); comm.executenonquery(); connectionstring.close(); gridview1.editindex = -1; binddata(); //end here } //you should write code on rowdeleting , give command name 'delete' link button protected void deleteemployee(object sender, eventargs e) { //stat here string employeeid = ((label)gridview1.rows[e.rowindex] .findcontrol("lblemployeeid")).text; connectionstring.open(); comm = new sqlcommand("delete employee employeeid=@employeeid", connectionstring); comm.parameters.addwithvalue("@employeeid", lnkremove); comm.executenonquery(); connectionstring.close(); binddata(); //end here } }
Comments
Post a Comment