GridView Row Button_Click database table updatevalue

Question

Hi

how to active & deactive two Button and Button_Click update value database in GridView

<asp:GridView ID="grdUserList" runat="server" AutoGenerateColumns="False" DataKeyNames="UserID" OnRowCommand="grdUserList_RowCommand" >
<Columns>
<asp:BoundField DataField="UserID" HeaderText="UserID" InsertVisible="False" ReadOnly="True" SortExpression="UserID" />
<asp:TemplateField HeaderText="CurrentStatus">
<ItemTemplate>
<table>
<tr>
<td align="center" style="width: 78px">
<asp:Button ID="Button2" runat="server" Text="Active" /></td>
<td align="center" style="width: 76px">
<asp:Button ID="Button3" runat="server" Text="Deactive" /></td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>

</Columns>
</asp:GridView>

Sanjeeb Lenka · Answer

Are you able to get the userid.

Sanjay Kumar · Answer

protected void grdUserList_RowCommand( object sender GridViewCommandEventArgs e) { GridViewRow row = ( GridViewRow )(( Button )e.CommandSource).NamingContainer; int code = Convert .ToInt32(grdUserList.DataKeys[row.RowIndex].Values[0].ToString()); }

Sanjeeb Lenka · Answer

GridViewRow row = (GridViewRow)((Button)e.CommandSource).NamingContainer; int code = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Values[0].ToString()); try like this. if you are not getting plz share your code aspx and cs i will do the modification.

Sanjay Kumar · Answer

how can use DataKeyNames=UserID ..any code

Sanjeeb Lenka · Answer

hi in Button click just update the value in db. by using the datakey Userid.

Sanjay Kumar · Answer

GridView add two Active/ Deactive button button_click table update value Ex: Active button =1 Deactive button=0

Sanjeeb Lenka · Answer

Hi plz provide clear details what actually your requirement.