asp.net - Delete a row from gridvew using stored procedure -


i newbie asp.net . wish delete gridview row after clicking linkbutton on grid . attempting fetch primary key of gridview row clicked using datakeys , den pass delete stored stored procedure . exception of index out of range . please me how can ? here code

gridview grid=(gridview)sender; linkbutton lnkbtndelete = (linkbutton)e.commandsource; gridviewrow grdvwrw = (gridviewrow)lnkbtndelete.namingcontainer; int pkey = convert.toint32(grid.datakeys[grdvwrw.rowindex].value.tostring()); sqlcommand cmd3 = new sqlcommand("usp_delete_notice", con2); cmd3.commandtype = commandtype.storedprocedure; cmd3.parameters.addwithvalue("@noticeid", pkey); int rowsdeleted = cmd3.executenonquery();`enter code here` 


Comments

Popular posts from this blog

basic authentication with http post params android -

vb.net - Virtual Keyboard commands -

c++ - End of file on pipe magic during open -