Crystal Reports supports reports that access ADO.NET datasets

最新推荐文章于 2013-10-29 16:30:53 发布

hdaerduo

最新推荐文章于 2013-10-29 16:30:53 发布

阅读量676

点赞数

分类专栏： .Net 文章标签： access dataset constructor report cmd sql

本文链接：https://blog.csdn.net/hdaerduo/article/details/1329708

版权

.Net 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

Whatever the source is, before you can report off of an ADO.NET dataset you must perform the following tasks:

Generate ADO.NET Dataset Objects.
Connect to an ADO.NET Dataset Object to create a new report based on the data description provided by the dataset object.

public Form1()
  {
   //
   // Required for Windows Form Designer support
   //
   InitializeComponent();

   //
   // TODO: Add any constructor code after InitializeComponent call
   //
   MySQLConnection con = new MySQLConnection( new MySQLConnectionString("A19999-02",
    "db_cxtool",
    "root",
    "4312",3309).AsString);
   con.Open();
   string sql = "SELECT UIFieldID, fieldFullname FROM tb_ui_field t";
   MySQLCommand cmd = new MySQLCommand(sql,con);
   MySQLDataAdapter dataAdapter = new MySQLDataAdapter(cmd);

   DataSet dataSet = new DataSet();
   dataAdapter.Fill(dataSet,"tb_ui_field");
//   dataSet.WriteXml("test.xml");
//   dataSet.WriteXmlSchema("sch.xsd");
   oRpt.SetDataSource(dataSet);
   crystalReportViewer1.ReportSource = oRpt;
  }