参考代码: C# code
SqlParameter[] conditionParameter = new SqlParameter[]
{
new SqlParameter("@Year",ddlYear.SelectedValue)
}; ReportParameter[] param = new ReportParameter[]
{
new ReportParameter("ReportParameterYear", ddlYears.SelectedItem.Text.ToString()),
}; //Get Data into dataset
string thisConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection thisConnection = new SqlConnection(thisConnectionString);
DataSet thisDataSet = new DataSet();
thisDataSet = SqlHelper.ExecuteDataset(thisConnection, "uspXXX", conditionParameter);
ReportDataSource datasource = new ReportDataSource("dsxxx_uspxxx", thisDataSet.Tables[0]); //Displayed in ReportVierer
ReportViewer1.Visible = true;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource); if (thisDataSet.Tables[0].Rows.Count == 0)
{
lblMessage.Text = "xxxx!";
}
else
{
lblMessage.Text = String.Empty;
}
ReportViewer1.LocalReport.SetParameters(param);
ReportViewer1.LocalReport.Refresh();
}
SqlParameter[] conditionParameter = new SqlParameter[]
{
new SqlParameter("@Year",ddlYear.SelectedValue)
}; ReportParameter[] param = new ReportParameter[]
{
new ReportParameter("ReportParameterYear", ddlYears.SelectedItem.Text.ToString()),
}; //Get Data into dataset
string thisConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection thisConnection = new SqlConnection(thisConnectionString);
DataSet thisDataSet = new DataSet();
thisDataSet = SqlHelper.ExecuteDataset(thisConnection, "uspXXX", conditionParameter);
ReportDataSource datasource = new ReportDataSource("dsxxx_uspxxx", thisDataSet.Tables[0]); //Displayed in ReportVierer
ReportViewer1.Visible = true;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource); if (thisDataSet.Tables[0].Rows.Count == 0)
{
lblMessage.Text = "xxxx!";
}
else
{
lblMessage.Text = String.Empty;
}
ReportViewer1.LocalReport.SetParameters(param);
ReportViewer1.LocalReport.Refresh();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货