请帮我解决这个水晶报告问题 [英] please help me solve this crystal report problem

问题描述

朋友们，



我的代码无法正常工作。我非常搜索这个问题，我不知道问题出在哪里。



这是我的代码

hi friends,

my code does not working properly.i searched for this problem very and i do not know where is the problem.

this is my code

CrystalReport2 objRpt = new CrystalReport2();
            SqlConnection cnn;
            string connectionString = null;
            string sql = textBox1.Text;
            connectionString="server=localhostDatabase=AhmadfamDatabaseTrusted_Connection=true";
            cnn = new SqlConnection(connectionString);
            cnn.Open();
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet1 ds = new DataSet1();
            dscmd.Fill(ds, "OmdeSell_Table");
            MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
            objRpt.SetDataSource(ds.Tables[1]);
            
            crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();

在消息框中我可以看到行计数例如320但是crystalreportviewer1没有显示任何行信息。我在app.config文件启动标记中添加了一个属性：

in the messagebox i can see rows count for example 320 but crystalreportviewer1 does not show any information. i added a property to the app.config file startup tag that is:

useLegacyV2RuntimeActivationPolicy="true"

当我删除此属性时出现错误的错误

when i remove this property an error occor that is

C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll

i不知道该怎么做才能解决这个问题。我很困惑。请帮帮我。

i do not know what to do to solve this problem.i am confused. please help me.

推荐答案

CrystalReport2 objRpt = new CrystalReport2（）;

SqlConnection cnn;

string connectionString = null;

string sql =从OmdeSell_Table中选择*，其中Id =+ textBox1.text +;

connectionString =server = localhostDatabase = AhmadfamDatabaseTrusted_Connection = true;

cnn = new SqlConnection（connectionString）;

cnn.Open（）;

SqlDataAdapter dscmd = new SqlDataAdapter（sql，cnn）;

DataSet1 ds = new DataSet1（）;

dscmd.Fill（ds，OmdeSell_Table）;

MessageBox.Show（ds.Tables [ 1] .Rows.Count.ToString（））;

objRpt.SetDataSource（ds.Tables [1]）;



crystalReportViewer1。 ReportSource = objRpt;

crystalReportViewer1.Refresh（）;

CrystalReport2 objRpt = new CrystalReport2();
SqlConnection cnn;
string connectionString = null;
string sql = "Select * from OmdeSell_Table where Id="+textBox1.text+"";
connectionString="server=localhostDatabase=AhmadfamDatabaseTrusted_Connection=true";
cnn = new SqlConnection(connectionString);
cnn.Open();
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
DataSet1 ds = new DataSet1();
dscmd.Fill(ds, "OmdeSell_Table");
MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
objRpt.SetDataSource(ds.Tables[1]);

crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();

这篇关于请帮我解决这个水晶报告问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！