＋设为首页 ＋添加到收藏夹
private void Button1_Click(object sender, System.EventArgs e)
{
//创建连接字符串
String
strConn = "Data Source=(local);";
strConn += "Initial Catalog=northwind;";
strConn += "User Id=sa;";
strConn += "Password=keshan;";
//SQL语句
String
strSQL = " SELECT ";
strSQL += " * ";
strSQL += " FROM ";
strSQL += " PRODUCTS ";
try
{
//创建数据库连接
SqlConnection cnReport = new SqlConnection(strConn);
//创建数据适配器
SqlDataAdapter daReport = new SqlDataAdapter(strSQL,cnReport);
//创建数据集
DataSet dsRpt = new DataSet();
//填充数据集
daReport.Fill(dsRpt);
//实例化水晶报表
CrystalReport1 rpt = new CrystalReport1();
//设定报表数据源
rpt.SetDataSource(dsRpt);
//
CrystalReportViewer1.ReportSource = rpt;
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
}
cnReport.open()
进来帮顶
