数据未在datagridview的水晶报告中加载 [英] Data is not loading in crystal report from datagridview

问题描述

我有1个datagridview并且也创建了一个水晶报告。

我已经在datagridview中显示的一些条件上写了一个查询。所以我希望在水晶报表中显示数据以进行打印



我想用datagridview绑定数据集，然后在水晶报表中显示。但来自datagridview的数据没有显示在水晶报告中。



代码如下

私有Sub Button1_Click（sender As System.Object，e As System.EventArgs）处理Button1.Click 
 Dim cn As New SqlConnection（Data Source = .\INSTANCE; initial catalog = record; user = sa; password = gariahat ）
 Dim ds As New DataSet 
 Dim dt As DataTable 
 Dim cmd As New SqlCommand（select * from fullsort return_dt is null，cn）
 Dim da As New SqlDataAdapter（cmd）
 dt = New DataTable 
 da.Fill（dt）
 FullsortDataGridView.DataSource = dt 
 
 cn.Close（）
 End Sub 
 
 Private Sub Button2_Click（sender As System.Object，e As System.EventArgs）Handles Button2.Click 
 
 Form32.Show（）
 
 End Sub 
 

 Imports System.Configuration 
 Imports Cryst alDecisions.CrystalReports.Engine 
 Imports CrystalDecisions.ReportAppServer 
 Public Class Form32 
 
 Private Sub Form32_Load（sender As System.Object，e As System.EventArgs）Handles MyBase.Load 
 Dim crReportDocument As new cr 
 Dim ds As New DataSet 
 CrystalReportViewer1.ReportSource = crReportDocument 
 cr1.SetDataSource（ds.Tables（0））
 
 
 Form2.DataDataGridView.DataSource = ds.Tables（0）
 
 End Sub 

最后一个代码用于水晶报告编码

任何人都可以帮助我获得解决方案

解决方案

你的新Ds没有里面的数据!! （在Crystal Report Code Part中）



添加此代码

  Dim  cn  As  新 SqlConnection（< span class =code-string>  Data Source = .\INSTANCE; initial catalog = record; user = sa; password = gariahat） 
  Dim  ds 作为 新 DataSet 
  Dim  dt  As  DataTable 
  Dim  cmd  As  新 SqlCommand（   select * from fullsort其中return_dt为null，cn）
  Dim  da 作为  N. ew  SqlDataAdapter（cmd）
 dt = 新 DataTable 
 da.Fill（dt）
 FullsortDataGridView.DataSource = dt 
 
 cn.Close（）

实际将数据加载到新创建的DS：）



这就是为什么出现错误并且没有数据出现

是的，实际获取报告的数据

  Imports  System.Configuration 
  Imports  CrystalDecisions.CrystalReports.Engine 
  Imports  CrystalDecisions.ReportAppServer 
  Public  类 Form32 
 
 私有  Sub  Form32_Load（sender  As  System。 Object ，e  As  System.EventArgs）句柄  MyBase  .Load 
 ' 加载数据 
  Dim  cn 作为 新 SqlConnection（  Data Source = .\INSTANCE; initial catalog = record; user = sa; password = gariahat）
  Dim  cmd 作为 新 SqlCommand（  select * from fullsort其中return_dt为null，cn）
  Dim  da 作为 新 SqlDataAdapter（cmd）
 dt = 新 DataTable 
 da.Fi ll（dt）
 cn.Close（）
 
 
  Dim  crReportDocument 作为 新 cr 
 CrystalReportViewer1.ReportSource = crReportDocument 
 cr1.SetDataSource（dt）
 
 
 Form2.DataDataGridView.DataSource = dt 
 
 结束  Sub  

I have 1 datagridview and have created a crystal report too.
I have written a query on some conditions which is displaying in datagridview. so that data i want to display in crystal report for printing

i want to bind the dataset with datagridview and then display in crystal report. but the data from datagridview is not displaying in crystal report.

the code is as follows

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
       Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
       Dim ds As New DataSet
       Dim dt As DataTable
       Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
       Dim da As New SqlDataAdapter(cmd)
       dt = New DataTable
       da.Fill(dt)
       FullsortDataGridView.DataSource = dt

       cn.Close()
   End Sub

   Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click

       Form32.Show()

   End Sub

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Public Class Form32

    Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        Dim crReportDocument As New cr
        Dim ds As New DataSet
        CrystalReportViewer1.ReportSource = crReportDocument
        cr1.SetDataSource(ds.Tables(0))


        Form2.DataDataGridView.DataSource = ds.Tables(0)
       
    End Sub

the last code is for crystal report coding
can anyone help me in getting solution

解决方案

your New Ds Has No Data Inside it !! ( in the Crystal Report Code Part )

add this code

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
      Dim ds As New DataSet
      Dim dt As DataTable
      Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
      Dim da As New SqlDataAdapter(cmd)
      dt = New DataTable
      da.Fill(dt)
      FullsortDataGridView.DataSource = dt

      cn.Close()

to Actually Load the Data to The Newly Created DS :)

That's Why there is an Error and No Data Appears

Yes , to actually get Data for the Report

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Public Class Form32
 
    Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        'Load Data
        Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial     catalog=record;user=sa;password=gariahat")
      Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
      Dim da As New SqlDataAdapter(cmd)
      dt = New DataTable
      da.Fill(dt)
      cn.Close()


        Dim crReportDocument As New cr
        CrystalReportViewer1.ReportSource = crReportDocument
        cr1.SetDataSource(dt)
 

        Form2.DataDataGridView.DataSource = dt
       
    End Sub

这篇关于数据未在datagridview的水晶报告中加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！