Get RowIndex on GridView RowCommand event using C# and VB.Net in ASP.Net

phonghue

SOLVED CLOSED ACTIVE ANSWERED
User: phonghue
Posted: on Jan 07, 2020 11:41 PM
Forum: Data Controls
Answer: 1
Views: 10182

Hi,

I add a new button next to each of the row with the code to pull the report for each of the record in the Gridview, but then now I ran into an error.

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Line 12: Dim index As Integer = Convert.ToInt32(e.CommandArgument)

Line 13: Dim row As GridViewRow = GridView1.Rows(index)

Can you help please?

Here is HTML code:

<asp:GridView runat="server" ID="GridView1" AutoGenerateColumns="false" ForeColor="#0099FF">
    <AlternatingRowStyle BackColor="#CCCCFF" />
    <Columns>
        <asp:BoundField DataField="OrgCode" HeaderText="Organization" ReadOnly="True" SortExpression="OrgCode">
            <HeaderStyle ForeColor="Black" Font-Bold="True" />
            <ItemStyle HorizontalAlign="Left" ForeColor="Black" />
        </asp:BoundField>
        <asp:BoundField DataField="OPTitle" HeaderText="Program" ReadOnly="True" SortExpression="OPTitle">
            <HeaderStyle ForeColor="Black" Font-Bold="True" />
            <ItemStyle HorizontalAlign="Left" ForeColor="Black" />
        </asp:BoundField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="GlobalTemplate" CommandName="EditRow" CommandArgument='<%# DataBinder.Eval(Container, "RowIndex") %>'
                    runat="server" Text="View Agency" Width="100px" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

    Protected Sub GridView1_RowCommand1(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
        If e.CommandName = "EditRow" Then
           Dim index As Integer = Convert.ToInt32(e.CommandArgument)
           Dim row As GridViewRow = GridView1.Rows(index)
           Dim OrgCode As String = Convert.ToString(GridView1.DataKeys(index)("OrgCode").ToString())
           Dim ProgCode As String = Convert.ToString(GridView1.DataKeys(index)("OPTitle").ToString())
           Session("OrgCode") = OrgCode.ToString
           Session("ProgCode") = ProgCode.ToString
           Response.Redirect("Report/GlobalAgencyPrograms.aspx")
       End If
   End Sub

Download FREE API for Word, Excel and PDF in ASP.Net

arunkurm...

0 2

Reply
ANSWER
User: arunkurmi
Replied: on Jan 08, 2020 04:57 AM
Report

Hi phonghue,

Check this sample. now take its reference and correct your code.

HTML

<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" OnRowCommand="OnRowCommand">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="btnEdit" Text="View Agency" runat="server" CommandName="EditRow"
                    CommandArgument='<%# Container.DataItemIndex %>' />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id"), new DataColumn("Name") });
        dt.Rows.Add("1", "Amit");
        dt.Rows.Add("2", "Smith");
        dt.Rows.Add("3", "John");
        dt.Rows.Add("4", "Rachel");
        this.gvCustomers.DataSource = dt;
        this.gvCustomers.DataBind();
    }
}
protected void OnRowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "EditRow")
    {
        int index = Convert.ToInt32(e.CommandArgument);
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn() {New DataColumn("Id"), New DataColumn("Name")})
        dt.Rows.Add("1", "Amit")
        dt.Rows.Add("2", "Smith")
        dt.Rows.Add("3", "John")
        dt.Rows.Add("4", "Rachel")
        Me.gvCustomers.DataSource = dt
        Me.gvCustomers.DataBind()
    End If
End Sub

Protected Sub OnRowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
    If e.CommandName = "EditRow" Then
        Dim index As Integer = Convert.ToInt32(e.CommandArgument)
    End If
End Sub

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Get RowIndex on GridView RowCommand event using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us