无法将数据从sql数据库加载到crystal report c＃ [英] Cannot load the data from sql database to crystal report c#

问题描述

大家好，我正在使用SQL Server数据库在C＃中使用Crystal Reports，我无法继续我的项目因为我收到错误



>加载保存报告异常



我要设置Crystal报表的数据源。



任何帮助将不胜感激。



这是我的代码：

 SqlConnection con =  new  SqlConnection（）; 
  string  conString =  @  data source = JR-PC\SQLEXPRESS;初始目录=选举;综合安全=真;; 
  string  sql =  选择can_names，can_pos ，partylist，num_votes from tbl_Candidates; 
 
 con =  new  SqlConnection（conString）; 
 con.Open（）; 
 
 SqlDataAdapter da =  new  SqlDataAdapter（sql，con）; 
 ReportPracice._DATASETS.DataSet1 ds =  new  ReportPracice._DATASETS.DataSet1（）; 
 da.Fill（ds，  tbl_Candidates）; 
 
 MessageBox.Show（ds.Tables [ 1 ]。Rows.Count.ToString（））; 
 con.Close（）; 
 
 ReportPracice._REPORTS.CrystalReport1 rpt =  new  ReportPracice._REPORTS.CrystalReport1（）; 
 rpt.SetDataSource（ds.Tables [ 1 ]）;  //  在此行中，我收到了该错误。 
 crystalReportViewer1.ReportSource = rpt ; 
 crystalReportViewer1.Refresh（）; 
 

解决方案

看看这个，

 SqlConnection con =  new  SqlConnection（）; 
  string  conString =  @  data source = JR-PC\SQLEXPRESS;初始目录=选举;综合安全=真;; 
  string  sql =  选择can_names，can_pos ，partylist，num_votes from tbl_Candidates; 
 
 con =  new  SqlConnection（conString）; 
 con.Open（）; 
 
 SqlDataAdapter da =  new  SqlDataAdapter（sql，con）; 
 ReportPracice._DATASETS.DataSet1 ds =  new  ReportPracice._DATASETS.DataSet1（）; 
 da.Fill（ds，  tbl_Candidates）; 
 
 MessageBox.Show（ds.Tables [  tbl_Candidates]。行.Count.ToString（））; 
 con.Close（）; 
 
 ReportPracice._REPORTS.CrystalReport1 rpt =  new  ReportPracice._REPORTS.CrystalReport1（）; 
 rpt.SetDataSource（ds.Tables [  tbl_Candidates]）;  //  在这些方括号内使用表名或尝试使用索引[0]  
 crystalReportViewer1。 ReportSource = rpt; 
 crystalReportViewer1.Refresh（）; 

Best问候。

Hi guys, I am working with Crystal Reports in C# using a SQL Server database, I cannot proceed with my project because I am getting an error

> Load Save Report Exception

on the line which I am going to set the data source of my Crystal report.

Any help will be appreciated.

Here is my code:

SqlConnection con = new SqlConnection();
 string conString = @"data source =JR-PC\SQLEXPRESS;initial catalog = election;integrated security =true;";
 string sql = "Select can_names,can_pos,partylist,num_votes from tbl_Candidates";

 con = new SqlConnection(conString);
 con.Open();

 SqlDataAdapter da = new SqlDataAdapter(sql, con);
 ReportPracice._DATASETS.DataSet1 ds = new ReportPracice._DATASETS.DataSet1();
 da.Fill(ds, "tbl_Candidates");

 MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
 con.Close();

 ReportPracice._REPORTS.CrystalReport1 rpt = new ReportPracice._REPORTS.CrystalReport1();
 rpt.SetDataSource(ds.Tables[1]); //in this line, where I am getting that error.
 crystalReportViewer1.ReportSource = rpt;
 crystalReportViewer1.Refresh();

解决方案

Have a look at this,

SqlConnection con = new SqlConnection();
    string conString = @"data source =JR-PC\SQLEXPRESS;initial catalog = election;integrated security =true;";
    string sql = "Select can_names,can_pos,partylist,num_votes from tbl_Candidates";
    
    con = new SqlConnection(conString);
    con.Open();
    
    SqlDataAdapter da = new SqlDataAdapter(sql, con);
    ReportPracice._DATASETS.DataSet1 ds = new ReportPracice._DATASETS.DataSet1();
    da.Fill(ds, "tbl_Candidates");
    
    MessageBox.Show(ds.Tables["tbl_Candidates"].Rows.Count.ToString());
    con.Close();
    
    ReportPracice._REPORTS.CrystalReport1 rpt = new ReportPracice._REPORTS.CrystalReport1();
    rpt.SetDataSource(ds.Tables["tbl_Candidates"]); //Use table Name within those Square braces or try with index [0]
    crystalReportViewer1.ReportSource = rpt;
    crystalReportViewer1.Refresh();

Best Regards.

这篇关于无法将数据从sql数据库加载到crystal report c＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！