myConnection = new SqlConnection("server=localhost;database=test;user id=sa;password=54321");
myConnection.Open();
string strSql = "SELECT * FROM Info";
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = strSql;
SqlDataAdapter myAd = new SqlDataAdapter(strSql, myConnection);
myAd.SelectCommand = myCommand;
DataSet myDs = new DataSet();
myAd.Fill(myDs, "Info");
CrystalReport1 tmprpt = new CrystalReport1();
tmprpt.SetDataSource(myDs.Tables[0]);
this.crystalReportViewer1.ReportSource = tmprpt;
上述代码运行的结果是报表里边没有数据,不知为什么。(SELECT * FROM Info是有数据的)
myConnection.Open();
string strSql = "SELECT * FROM Info";
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = strSql;
SqlDataAdapter myAd = new SqlDataAdapter(strSql, myConnection);
myAd.SelectCommand = myCommand;
DataSet myDs = new DataSet();
myAd.Fill(myDs, "Info");
CrystalReport1 tmprpt = new CrystalReport1();
tmprpt.SetDataSource(myDs.Tables[0]);
this.crystalReportViewer1.ReportSource = tmprpt;
上述代码运行的结果是报表里边没有数据,不知为什么。(SELECT * FROM Info是有数据的)
this.crystalReportViewer1.Refresh();