CODEWITHSUNDEEP
asp.netgridviewdatatable
Hidalgo
Hidalgo

Reputation: 941

Determine the datatable index of the row clicked in GridView

I have a GridView in ASP.NET page. The GridView is bound to a dataset/datatabe. One of the columns of the grid is a command button and the gridview has method OnRowCommand (e.g. OnRowCommand="GridView_RowCommand") specified.

When user clicks on the button in the grid, the method GridView_RowCommand fires. I would like to find the index to the DataTable for the row where button was clicked. Note, that I am not looking for index to the GridView row but rather the index to the DataTable bound to the GridView.

Thank you in advance for your help.

Upvotes: 0

Views: 730

Answers (1)

Pixelstiltskin
Pixelstiltskin

Reputation: 332

You have a few options and it depends on the amount of data you are binding to the gridview, one you could save the dataset/datatable to Session[""] as you bind or you could retrieve the data from the database again once you have the unique id of the row. You could create the following on your gridview: 

   <asp:GridView ID="gvCustomer" runat="server"
     AutoGenerateColumns="False" DataKeyNames="yourId" onrowcommand="gvCustomer_RowCommand">
<Columns>
<asp:TemplateField>
                <ItemTemplate>
                    <asp:LinkButton ID="lnkAction" runat="server" Text="Do Something" CommandName="yourEvent" />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
   </asp:GridView>

then in the code behind for the RowCommand event have:

    protected void gvCustomer_RowCommand(object sender, GridViewCommandEventArgs e)
    {    
        if (e.CommandName == "yourEvent")
        {
           var row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
           int rowId = Convert.ToInt32(gvCustomer.DataKeys[row.RowIndex]["yourId"]);
            }
    }

At this point you have the id which you could either query the database again or access the data source object that you save in to session before binding to the gridview

Or another alternative is:

<asp:LinkButton CommandArgument='<%#Eval("PrimaryKey")%>' />

Then you can get the arg with e.CommandArgument in the gvCustomer_RowCommand method

Upvotes: 1

Related Questions