110,539
社区成员
发帖
与我相关
我的任务
分享
private void bb_Load(object sender, EventArgs e)
{
LoadReport("");
this.jjypTableAdapter1.Fill(this.xsxxdbDataSet1.jjyp);
this.reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
private void LoadReport(string queryCondition)
{
reportViewer1.LocalReport.ReportPath = "Report2.rdlc";
DataTable dt = GetData(queryCondition);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.LocalReport.Refresh();
}
private DataTable GetData(string queryCondition)
{
DataTable dt = new DataTable("DataTable1");
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Dept", typeof(string)));
DataRow row = dt.NewRow();
row["Name"] = "张三";
row["Dept"] = "人事部门";
dt.Rows.Add(row);
row = dt.NewRow();
row["Name"] = "李四";
row["Dept"] = "人事部门";
dt.Rows.Add(row);
row = dt.NewRow();
row["Name"] = "王五";
row["Dept"] = "技术部门";
dt.Rows.Add(row);
if (string.IsNullOrEmpty(queryCondition))
return dt;
else
{
return dt.Select("Dept='" + queryCondition + "'").CopyToDataTable();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
LoadReport("人事部门");
}
private void button1_Click_1(object sender, EventArgs e)
{
LoadReport("人事部门");
}
错误提示 :如下图
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadReport("");
}
}
private void LoadReport(string queryCondition)
{
ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
DataTable dt = GetData(queryCondition);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
}
private DataTable GetData(string queryCondition)
{
DataTable dt = new DataTable("DataTable1");
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Dept", typeof(string)));
DataRow row = dt.NewRow();
row["Name"] = "张三";
row["Dept"] = "人事部门";
dt.Rows.Add(row);
row = dt.NewRow();
row["Name"] = "李四";
row["Dept"] = "人事部门";
dt.Rows.Add(row);
row = dt.NewRow();
row["Name"] = "王五";
row["Dept"] = "技术部门";
dt.Rows.Add(row);
if (string.IsNullOrEmpty(queryCondition))
return dt;
else
{
return dt.Select("Dept='"+ queryCondition +"'").CopyToDataTable();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
LoadReport("人事部门");
}
System.Data.SqlClient.SqlCommand command1 = new System.Data.SqlClient.SqlCommand("select * from customers", conn1);
后面的不就是sql吗?你可以按你查询的条件按同样规则组织后来传递啊