How to display data from Sql Database in table in report viewer

Question

I already display data to a DataGridView in my form with these codes, now I want to display that in a report viewer. How can I do this ?

//Fill DataGridView
try
{
    MyDB db = new MyDB();//my connection string
    string sql = "SELECT * FROM innoviceitem WHERE id='{0}'";
    sql = string.Format(sql, id);//id is a public string that its value has been set
    SqlDataAdapter sda = new SqlDataAdapter(sql, db.MyConn);
    DataSet ds = new DataSet();
    BindingSource bs = new BindingSource();
    sda.Fill(ds);
    bs.DataSource = ds.Tables[0].DefaultView;
    datagridview1.DataSource = bs;
}
catch (Exception err) { MessageBox.Show(err.Message); }

You need to create a report. See the answers here stackoverflow.com/questions/10222980/… — DOK
– DOK, Commented Mar 7, 2014 at 17:02

Eanthmue · Accepted Answer · 2014-03-07 17:03:18Z

1

you can find useful information in following link

http://www.mindstick.com/Articles/13169999-ef3b-496c-b502-caef973c3bb2/?Using%20ReportViewer%20in%20WinForms%20C

answered Mar 7, 2014 at 17:03

Eanthmue

4772 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display data from Sql Database in table in report viewer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related