forum

Home / DeveloperSection / Forums / passing dataset to report viewer

passing dataset to report viewer

Ahmed Algosaibi350417-Apr-2013
Hello guys,
I've windows app that uses report viewer, but the problem that I don't get result back?

This is my code.

private void Form3_Load(object sender, EventArgs e)
        {
            con.ConnectionString = connection.x;

            runRptViewer();
        }

        private DataTable getData()
    {
       
            con.Open();
            DataSet1 dss = new DataSet1();
            string sql = "select product_id, product_name,product_quantity from product";
            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            da.Fill(dss);
            DataTable dt = dss.Tables["product"];

        return dt;
    }

    private void runRptViewer()
    {      
            reportViewer1.LocalReport.DataSources.Clear(); //clear report
            reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc"; // bind reportviewer with .rdlc
            Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", getData()); // set the datasource
            reportViewer1.LocalReport.DataSources.Add(dataset);
            reportViewer1.LocalReport.Refresh();
            reportViewer1.RefreshReport();
    }

Updated on 02-May-2013

Can you answer this question?


Answer

1 Answers

Liked By