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
Post a Comment