Display GridView data to RDLC Report with Auto Serial Number (Row Number) in ASP.Net

Hi kankon,

Check this sample. now take its reference.

HTML

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" CssClass="Grid">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:CheckBox ID="chkSelect" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Sr No">
            <ItemTemplate>
                <%# Container.DataItemIndex + 1 %>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="ContactName" HeaderText="Contact Name" />
        <asp:BoundField DataField="City" HeaderText="City" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
    </Columns>
</asp:GridView><br />
<asp:Button ID="btnShow" Text="Show in Report" runat="server" OnClick="ShowRDLC" />
<hr />
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="600">
</rsweb:ReportViewer>

Namespaces

C#

using System.Configuration;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
using Microsoft.Reporting.WebForms;

 VB.Net

Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls
Imports Microsoft.Reporting.WebForms

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        Customers dsCustomers = GetData("SELECT TOP 5 * FROM Customers ORDER BY NEWID()");
        gvCustomers.DataSource = dsCustomers;
        gvCustomers.DataBind();
    }
}

private Customers GetData(string query)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlCommand cmd = new SqlCommand(query);
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;

            sda.SelectCommand = cmd;
            using (Customers dsCustomers = new Customers())
            {
                sda.Fill(dsCustomers, "DataTable1");
                return dsCustomers;
            }
        }
    }
}

protected void ShowRDLC(object sender, EventArgs e)
{
    Customers dsCustomers = new Customers();
    foreach (GridViewRow row in gvCustomers.Rows)
    {
        if ((row.FindControl("chkSelect") as CheckBox).Checked)
        {
            string customerId = row.Cells[1].Text;
            string contactName = row.Cells[2].Text;
            string city = row.Cells[3].Text;
            string country = row.Cells[4].Text;
            dsCustomers.Tables[0].Rows.Add(customerId, contactName, city, country);
        }
    }
    ReportViewer1.ProcessingMode = ProcessingMode.Local;
    ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
    ReportDataSource datasource = new ReportDataSource("Customers", dsCustomers.Tables[0]);
    ReportViewer1.LocalReport.DataSources.Clear();
    ReportViewer1.LocalReport.DataSources.Add(datasource);
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dsCustomers As Customers = GetData("SELECT TOP 5 * FROM Customers ORDER BY NEWID()")
        gvCustomers.DataSource = dsCustomers
        gvCustomers.DataBind()
    End If
End Sub

Private Function GetData(ByVal query As String) As Customers
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim cmd As SqlCommand = New SqlCommand(query)
    Using con As SqlConnection = New SqlConnection(conString)
        Using sda As SqlDataAdapter = New SqlDataAdapter()
            cmd.Connection = con
            sda.SelectCommand = cmd
            Using dsCustomers As Customers = New Customers()
                sda.Fill(dsCustomers, "DataTable1")
                Return dsCustomers
            End Using
        End Using
    End Using
End Function

Protected Sub ShowRDLC(ByVal sender As Object, ByVal e As EventArgs)
    Dim dsCustomers As Customers = New Customers()
    For Each row As GridViewRow In gvCustomers.Rows
        If (TryCast(row.FindControl("chkSelect"), CheckBox)).Checked Then
            Dim customerId As String = row.Cells(1).Text
            Dim contactName As String = row.Cells(2).Text
            Dim city As String = row.Cells(3).Text
            Dim country As String = row.Cells(4).Text
            dsCustomers.Tables(0).Rows.Add(customerId, contactName, city, country)
        End If
    Next
    ReportViewer1.ProcessingMode = ProcessingMode.Local
    ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc")
    Dim datasource As ReportDataSource = New ReportDataSource("Customers", dsCustomers.Tables(0))
    ReportViewer1.LocalReport.DataSources.Clear()
    ReportViewer1.LocalReport.DataSources.Add(datasource)
End Sub

Screenshot