Bind ASP.Net Crystal Report using DataTable in C# and VB.Net

mahjoubi
 
on Aug 25, 2022 03:23 AM
432 Views

Hi members

I have a DataTable from a database and after adding it to a CrystalReport nothing happen if i make the same to a GridView it populate the data successfully.

How i can populate the data to CrystalReport viewer?

This is my code

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
      Dim cn As New SqlConnection("server=192.168.2.200;database=stupremat;user=adm;password=Stupremat0@")
      Dim stupremat2 As New SqlConnection("server=192.168.2.200;database=stupremat;user=adm;password=Stupremat0@")
      Dim stupremat As New SqlConnection("server=192.168.2.200;database=stupremat;user=adm;password=Stupremat0@")
      Dim substitution3 As New SqlConnection("server=192.168.2.200;database=SUBSTITUTION_SERVER;user=adm;password=Stupremat0@")
      Dim tabEmp As New DataTable
      tabEmp.Columns.Add("Emplacement")
      tabEmp.Columns.Add("Articles")
      tabEmp.Columns.Add("Substitution")
      tabEmp.Columns.Add("Designation")
      tabEmp.Columns.Add("Stock")
 
      If cn.State = ConnectionState.Open Then
          cn.Close()
      End If
 
      cn.Open()
 
      Dim cmd2 As New SqlCommand("SELECT [DP_No],[DP_Code],[DP_Intitule],[DP_Zone] FROM [STUPREMAT].[dbo].[F_DEPOTEMPL] where DP_Intitule = 'A0013' order by DP_Intitule", cn)
      Dim sqldata As New SqlDataAdapter(cmd2)
      sqldata.Fill(tabEmp)
 
      Dim rpt As New CRDemo
      rpt.SetDataSource(tabEmp)
      CrystalReportViewer1.ReportSource = rpt
      CrystalReportViewer1.DataBind() 
      cn.Close() 
  End Sub

 

<asp:Button ID="Button1" runat="server" Text="Button" />
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="false" ToolPanelView="ParameterPanel" ReportSourceID="CrystalReportSource1" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
    <Report FileName="CRDemo.rpt">
    </Report>
</CR:CrystalReportSource>
<asp:GridView ID="GridView1" runat="server"></asp:GridView>

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Aug 25, 2022 03:24 AM
on Aug 26, 2022 01:52 AM

In order to bind the crystal report you need to make use of Strongly Type DataSet to which you need to insert the records from the database.

Then use the DataSet to bind the Crystal report.

Refer

Crystal Report ASP.Net Example using DataSet or DataTable in C# VB.Net and Visual Studio 2010