Display GridView selected row in Crystal Report in ASP.Net

Hi sthsyed,

I have created sample code which fullfill your requirement.

HTML

<form id="form1" runat="server">
<div>
    <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />
    <asp:GridView ID="gvCancelReservation" runat="server" AutoGenerateColumns="false">
        <Columns>
            <asp:TemplateField HeaderText="Action">
                <ItemTemplate>
                    <asp:CheckBox ID="chkRow" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="CustomerId">
                <ItemTemplate>
                    <asp:Label ID="lblCustomerId" Text='<%#Eval("CustomerId") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="ContactName">
                <ItemTemplate>
                    <asp:Label ID="lblContactName" Text='<%#Eval("ContactName") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="City">
                <ItemTemplate>
                    <asp:Label ID="lblCity" Text='<%#Eval("City") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country">
                <ItemTemplate>
                    <asp:Label ID="lblCountry" Text='<%#Eval("Country") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <br />
    <br />
    <asp:Button ID="btnCrystal" Text="Crystal Report" OnClick="Crystal" runat="server" />
</div>
</form>

VB.NET

Private constre As String = ConfigurationManager.ConnectionStrings("constring").ToString()
Shared customerId As String = String.Empty
Protected Sub Page_Load(sender As Object, e As EventArgs)
	If Not Me.IsPostBack Then
		Me.GetData()
	End If
End Sub
Private Sub GetData()
	Dim con As New SqlConnection(constre)
	Dim cmd As New SqlCommand("SELECT TOP 10 *  FROM Customers", con)
	Dim sda As New SqlDataAdapter(cmd)
	Dim dt As New DataTable()
	sda.Fill(dt)
	gvCancelReservation.DataSource = dt
	gvCancelReservation.DataBind()
End Sub


Protected Sub Crystal(sender As Object, e As EventArgs)
	Dim crystalReport As New ReportDocument()
	crystalReport.Load(Server.MapPath("~/CustomersReport.rpt"))
	For Each row As GridViewRow In gvCancelReservation.Rows
		Dim ChkCancel As CheckBox = TryCast(row.FindControl("chkRow"), CheckBox)
		If ChkCancel.Checked Then
			Dim Temp As String = TryCast(row.FindControl("lblCustomerId"), Label).Text
			If Not String.IsNullOrEmpty(customerId) Then
				customerId += (Convert.ToString("," + "'") & Temp) + "'"
			Else
				customerId = (Convert.ToString("'") & Temp) + "'"
			End If
		End If
	Next

	Dim dsCustomers As Customers = GetCustomers(customerId)
	crystalReport.SetDataSource(dsCustomers)
	Me.CrystalReportViewer1.ReportSource = crystalReport
	Me.CrystalReportViewer1.RefreshReport()
End Sub

Private Function GetCustomers(customerId As String) As Customers
	Using con As New SqlConnection(constre)
		Using cmd As New SqlCommand((Convert.ToString("SELECT TOP 10 * FROM Customers WHERE CustomerId IN (") & customerId) + ")")
			Using sda As New SqlDataAdapter()
				cmd.Connection = con
				sda.SelectCommand = cmd
				Using dsCustomers As New Customers()
					sda.Fill(dsCustomers, "DataTable1")
					Return dsCustomers
				End Using
			End Using
		End Using
	End Using
End Function

C#.NET

private string constre = ConfigurationManager.ConnectionStrings["constring"].ToString();
static string customerId = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.GetData();
    }
}
private void GetData()
{
    SqlConnection con = new SqlConnection(constre);
    SqlCommand cmd = new SqlCommand("SELECT TOP 10 *  FROM Customers", con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    sda.Fill(dt);
    gvCancelReservation.DataSource = dt;
    gvCancelReservation.DataBind();
}


protected void Crystal(object sender, EventArgs e)
{
    ReportDocument crystalReport = new ReportDocument();
    crystalReport.Load(Server.MapPath("~/CustomersReport.rpt"));
    foreach (GridViewRow row in gvCancelReservation.Rows)
    {
        CheckBox ChkCancel = row.FindControl("chkRow") as CheckBox;
        if (ChkCancel.Checked)
        {
            string Temp = (row.FindControl("lblCustomerId") as Label).Text;
            if (!string.IsNullOrEmpty(customerId))
            {
                customerId += "," + "'" + Temp + "'";
            }
            else
            {
                customerId = "'" + Temp + "'";
            }
        }
    }

    Customers dsCustomers = GetCustomers(customerId);
    crystalReport.SetDataSource(dsCustomers);
    this.CrystalReportViewer1.ReportSource = crystalReport;
    this.CrystalReportViewer1.RefreshReport();
}

private Customers GetCustomers(string customerId)
{
    using (SqlConnection con = new SqlConnection(constre))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT TOP 10 * FROM Customers WHERE CustomerId IN (" + customerId + ")"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (Customers dsCustomers = new Customers())
                {
                    sda.Fill(dsCustomers, "DataTable1");
                    return dsCustomers;
                }
            }
        }
    }
}

Screenshot