110,532
社区成员
发帖
与我相关
我的任务
分享
//导入命名空间
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
//写在Page_Load之前的一个方法
protected void page_Init(object sender, EventArgs e)
{
DataSet ds = Cum.GetData();
ArrayList al = new ArrayList();
for (int i = 0; i < ds.Tables["cum"].Rows.Count; i++)
{
Cum cum = new Cum();
cum.CustomerID = ds.Tables["cum"].Rows[i]["CustomerID"].ToString();
cum.CompanyName = ds.Tables["cum"].Rows[i]["CompanyName"].ToString();
cum.Address = ds.Tables["cum"].Rows[i]["Address"].ToString();
al.Add(cum);
}
string path = Server.MapPath("CrystalReport.rpt");
ReportDocument rd = new ReportDocument();
rd.Load(path);
rd.SetDataSource(al);
this.CrystalReportViewer1.ReportSource = rd;
}
/// <summary>
/// Cum 类
/// </summary>
public class Cum
{
public Cum()
{
}
private string _CustomerID;
public string CustomerID
{
get { return _CustomerID; }
set { _CustomerID = value; }
}
private string _CompanyName;
public string CompanyName
{
get { return _CompanyName; }
set { _CompanyName = value; }
}
private string _Address;
public string Address
{
get { return _Address; }
set { _Address = value; }
}
public static DataSet GetData()
{
SqlConnection conn = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
SqlDataAdapter sda = new SqlDataAdapter("select CustomerID,CompanyName,Address from Customers",conn);
DataSet ds = new DataSet();
sda.Fill(ds,"cum");
return ds;
}
}