Editable Gridview
I am using Gridview control in a web form. I have added two new columns of type command field of "edit" and "delete" in it.
I don't know how to bind sql quries to edit or delete specific rows in gridview (using sqldatasource). I am unable to identify the specific row for delete or edit while writing sql query in sqldatasource control. The problem is setting parameters in sqldatasource, see code below:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HomeString %>"
SelectCommand="SELECT hrmdegree.degreeid, hrmdegree.degreename, hrmempqualification.remarks, hrmempqualification.percentage, hrmempqualification.degreeid AS Expr1, hrmempqualification.institutename, hrmempqualification.qualificationyear, hrmempqualification.qualificationid FROM hrmdegree INNER JOIN hrmempqualification ON hrmdegree.degreeid = hrmempqualification.degreeid WHERE (hrmempqualification.empid = @empid)" OnSelecting="SqlDataSource1_Selecting" DeleteCommand="DELETE FROM hrmempqualification WHERE (empid = @empid) AND [u](qualificationid = @qualificationid)</u>" >
<DeleteParameters>
<asp:SessionParameter Name="empid" SessionField="EmplID" />
</DeleteParameters>
Please help me in this issue
|