c#2005动态联接crystallreport

[y2jwww]

c#2003可以把REPORT当成一个对象,所以用程序动态的绑定数据比较简单,但c#2005怎么样可以实现呢?

[Jackile]

"推"数据

[y2jwww]

能给详细代码吗?

[showrock]

和03一样的,建XSD,然后通过SQL语句推

[showrock]

string connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectString"];
//string connStr = "server=.;uid=sa;pwd=sa;database=storeA";
SqlConnection conn = new SqlConnection(connStr);
// string cmd = "select b.departmentname,count(b.departmentname) as [count] from RKGL_RKBD_IN a,department b where a.departmentid=b.departmentid group by b.departmentname";//"select receive_address,sum(product_fare) as product_fare from BookList group by receive_address";
//string cmd = "select * from RKGL_RKBD_IN";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tablename", SqlDbType.VarChar);
cmd.Parameters["@tablename"].Value = tableName;
cmd.Parameters.Add("@field", SqlDbType.VarChar);
//如果此变量有值,则为需要统计的字段,为空就是条数汇总
if (sumField != null && !sumField.Equals(""))
{
cmd.Parameters["@field"].Value = sumField;
}
else
{
cmd.Parameters["@field"].Value = "";
}
cmd.Parameters.Add("@departmentID", SqlDbType.VarChar);
cmd.Parameters["@departmentID"].Value = DepartmentID;
cmd.CommandText = "sp_reportview";
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "RKGL_RKBD_OUT");
cr.Load(Server.MapPath(@"Rpt/" + reportFileName));
cr.SetDataSource(ds);
CrystalReportViewer1.ReportSource = cr;
conn.Dispose();
ds.Dispose();
da.Dispose();

[Csharp110]

UP

[windykuang]

showrock(玉蝴蝶) 说的好!

强力的顶一把 @_@