读书人

水晶表格(推模式)(学习笔记)

发布时间: 2013-04-12 18:33:12 作者: rapoo

水晶报表(推模式)(学习笔记)

vs2008中:



protected void Page_Load(object sender, EventArgs e)

{


//推模式
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(CommonCode.GetData());



CrystalReportViewer1.ReportSource = rpt;

}




public static class CommonCode
{
public static DataTable GetData()
{
string constr = "Data Source=.;Initial Catalog=db_Test;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(constr))
{
SqlDataAdapter da = new SqlDataAdapter("select * from dbo.T_Orders",conn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}


}
}

读书人网 >行业软件

热点推荐