1:创建报表应用程序,报表文档选择空白文件
2:添加一个DataSet组件,然后在DataSet里添加表"UserInfo",添加要映射的字段
3:设计报表,添加数据库字段,使用ADO.NET数据集,选择刚才添加的DataSet数据源,选择字段
4:添加代码
查询数据库
- public class sqlconnect
- {
- string sql;
- public string SetSql
- {
- set { sql = value; }
- }
- public DataSet GetData()
- {
- string consql = @"server=.\SQLEXPRESS;database=zpy;uid=sa;pwd=123456";
- SqlConnection con = new SqlConnection(consql);
- try
- {
- SqlDataAdapter da = new SqlDataAdapter(sql, con);
- DataSet ds = new DataSet();
- da.Fill(ds, "DataTable1");
- return ds;
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- DataSet ds = null;
- return ds;
- }
- }
- }
设置报表数据源代码
- private void Form1_Load(object sender, EventArgs e)
- {
- sqlconnect con = new sqlconnect();
- con.SetSql = "select * from userinfo";
- DataSet ds = con.GetData();
- CrystalReport1 cr1 =new CrystalReport1();
- cr1.SetDataSource (ds);
- crystalReportViewer1.ReportSource = cr1;
- }