GridView Row Button_Click database table updatevalue

Sanjay Kumar

13y1.4k.NET

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>

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Are you able to get the userid.
Sanjay Kumar13y ago
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 Lenka13y ago
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 Kumar13y ago
how can use DataKeyNames="UserID" ..any code
Sanjeeb Lenka13y ago
hi,

in Button click just update the value in db. by using the datakey Userid.
Sanjay Kumar13y ago
GridView add two Active/Deactive button button_click table update value

Ex: Active button =1

Deactive button=0
Sanjeeb Lenka13y ago
Hi,

plz provide clear details what actually your requirement.