通过隐藏代码填充报表查看器
本文关键字:报表 填充 隐藏 代码 | 更新日期: 2023-09-27 18:09:03
我使用reportviewer与strongly dataset
,但现在
我需要通过隐藏代码填充我的reportviewer。但是我得到了这个错误:A data source instance has not been supplied for the data source 'ds_blabla'.
下面是我输入数据集的代码:
public DataSet PreencheDS(Relatorios rel)
{
DataSet retorno = new DataSet();
try
{
string sql = @"SELECT proj.descricao AS projeto, func.descricao AS funcionalidade, clb.clube AS cliente, ch.descricao
FROM MyTable ch
INNER JOIN table1 proj ON MyTable.projeto = table1.id
INNER JOIN table2 func ON MyTable.funcionalidade = table2.id
INNER JOIN table3 clb ON MyTable.clube = table3 .id
WHERE (MyTable.responsavel = @responsavel) AND (MyTable.clube = @clube) AND (MyTable.dt_cadastro >= @dt_inicial) AND (MyTable.dt_cadastro <= @dt_final)";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new MySqlParameter("@responsavel", MySqlDbType.VarChar)).Value = rel.Responsavel_ID;
cmd.Parameters.Add(new MySqlParameter("@clube", MySqlDbType.VarChar)).Value = rel.Clube_ID;
cmd.Parameters.Add(new MySqlParameter("@dt_inicial", MySqlDbType.DateTime)).Value = rel.Dt_Inicial;
cmd.Parameters.Add(new MySqlParameter("@dt_final", MySqlDbType.DateTime)).Value = rel.Dt_Final;
retorno = _dal.Consultar(cmd);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return retorno;
}
这是包含ReportViewer
的页面
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rel.Responsavel_ID = Convert.ToInt32(Session["usrValue"].ToString());
rel.Clube_ID = Convert.ToInt32(Session["clube_id"].ToString());
rel.Dt_Inicial = Session["dt_inicial"].ToString() + " 00:00:00";
rel.Dt_Final = Session["dt_final"].ToString() + " 23:59:59";
DataSet ds = _rel.PreencheDS(rel);
ReportDataSource source = new ReportDataSource("MyTable", ds.Tables[0]);
this.ReportViewer1.ProcessingMode = ProcessingMode.Local;
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(source);
this.ReportViewer1.LocalReport.Refresh();
}
}
我想通过codebehind
而不是使用strongly dataset
来做,因为我需要将parameters
传递给我的reportviewer。但是这些parameters
它们可能会有所不同……所以我想用codebehind
来做。
我是这样做的。现在没有消息了,但是什么也没有出现
在下一行中,它应该是ds_blabla
,而不是MyTable
:
ReportDataSource source = new ReportDataSource("MyTable", ds.Tables[0]);