Blank tablix

Question

I tried using Report Viewer, but the data from Tablix is blank

Load from the form:

reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Tablix1", NCategoria.Mostrar()));

Business Layer

Report Viewer

Column name:

Data Layer

 public DataTable Mostrar()
        {
            DataTable DtResultado = new DataTable("categoria");
            SqlConnection SqlCon = new SqlConnection();
            try
            {
                SqlCon.ConnectionString = Conexao.Cn;
                SqlCommand SqlCmd = new SqlCommand();
                SqlCmd.Connection = SqlCon;
                SqlCmd.CommandText = "spmostrar_categoria";
                SqlCmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter sqlDat = new SqlDataAdapter(SqlCmd);
                sqlDat.Fill(DtResultado);
            }
            catch
            {
                DtResultado = null;
            }
            return DtResultado;
        }

Answer 1

Greetings. I’ll post it like I do it and see if it helps. First make sure your DataTable He’s bringing the database. Then change the tapeworm and test to see if it’ll work. The only difference I see is that you use the DataTable teste and I use a Collection.

private void frmRecategoria_Load(object sender, EventArgs e)
{
   DataTable teste = Ncategoria.Mostrar();

   //carrega a tabela do reportviewer
   reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("NomeDoDataSet_doTablix", teste));

this.ReportViewer1.RefreshReport();
}

Make sure that in your table the columns are with the same names as the DataTable, example: Idcategoria, Category.