title: ReportViewer doesn't show data
body: <p>The idea is to enter new fields then show them in report
  <a href="http://www.mediafire.com/view/6sla63hpecx2cc9/workflow.PNG" rel="nofollow">http://www.mediafire.com/view/6sla63hpecx2cc9/workflow.PNG</a>
  <a href="http://mediafire.com/view/1juiekfr5gbk48d/theproplem.GIF" rel="nofollow">mediafire.com/view/1juiekfr5gbk48d/theproplem.GIF</a></p>
  
  <p>i filter the table in the DataSet and it suppose to show data, it works perfect with the DataGridView, now i hope to find a way to fill the report with the same data set that fill the datagrid</p>
  
  <pre><code>public partial class bill : Form
  {
      SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\I.S\C#\C#(Projects)\Nothin\billingSystem\billingSystem\Store.mdf;Integrated Security=True;User Instance=True");
  
      public bill(string Cusn,string su,string am,string to,string Di, string Cnum)
      {
          InitializeComponent();
          label1.Text = Cusn;
          label2.Text = su;
          label3.Text = am;
          label4.Text = to;
          label5.Text = Di;
          label6.Text = DateTime.Now.ToString("d/M/yyyy");
          label7.Text = Cnum;
      }
  
      private void bill_Load(object sender, EventArgs e)
      {
          LoadReport();
      }
  
      private void LoadReport()
      {
  
          int R = Convert.ToInt32(label7.Text);
  
          SqlDataAdapter ADAP = new SqlDataAdapter("Select * from Newbill where Con = '" + R + "'", cn);
          DataSet DS = new DataSet();
          ADAP.Fill(DS, "Store");
          dataGridView1.DataSource = DS.Tables["Store"];
  
  
  
          // TODO: This line of code loads data into the 'DataSet10.NewBill' table. You can move, or remove it, as needed.
          this.NewBillTableAdapter.Fill(this.DataSet10.NewBill, R);
          this.reportViewer1.RefreshReport();
  
          ReportParameter[] allPar = new ReportParameter[5]; // create parameters array
          ReportParameter parSu = new ReportParameter("Summation", label2.Text);
          ReportParameter parDiscount = new ReportParameter("Discount", label5.Text);
          ReportParameter parDisA = new ReportParameter("DiscountAmount", label3.Text);
          ReportParameter parTotal = new ReportParameter("Total", label4.Text);
          ReportParameter parCus = new ReportParameter("CustomerName", label1.Text);
  
          allPar[0] = parSu; //assign parameters to parameter array
          allPar[1] = parDiscount;
          allPar[2] = parTotal;
          allPar[3] = parDisA;
          allPar[4] = parCus;
  
          this.reportViewer1.LocalReport.SetParameters(allPar);
          this.reportViewer1.RefreshReport();
          // TODO: This line of code loads data into the 'DataSet1.NewBill' table. You can move, or remove it, as needed.
          //this.NewBillTableAdapter.Fill(this.DataSet1.NewBill, R, O);
          //this.reportViewer1.RefreshReport();
      }
  }
  </code></pre>
  
  <p>IVE SEEN THIS : <a href="http://www.verious.com/qa/how-can-i-load-datatable-as-report-data-source/" rel="nofollow">http://www.verious.com/qa/how-can-i-load-datatable-as-report-data-source/</a></p>
  
  <p>actually i need steps to view data from DB with Query to filter the data in the report, All i found on google is just the like this: <a href="http://www.codeproject.com/Articles/31862/Dynamic-Binding-Of-RDLC-To-ReportViewer" rel="nofollow">http://www.codeproject.com/Articles/31862/Dynamic-Binding-Of-RDLC-To-ReportViewer</a> but its not working when a new fields has inserted.</p>
  
  <p>how about this, i try to refresh the dataset to include the changes that happens in the table (in my case insert new rows "new data")
  But it gives me :</p>
  
  <pre><code>A data source instance has not been supplied for the data source 'DataSet 10_NewBill'.
  
  
  private void LoadReport()
          {
              int R = Convert.ToInt32(label7.Text);
  
              this.reportViewer1.LocalReport.DataSources.Clear();
              DataTable dt = new DataTable();
              dt = this.NewBillTableAdapter.GetData(R);
  
              ReportDataSource rprtDTSource = new ReportDataSource(dt.TableName, dt);
  
              this.reportViewer1.LocalReport.DataSources.Add(rprtDTSource);
              this.reportViewer1.RefreshReport(); 
  
              // TODO: This line of code loads data into the 'DataSet10.NewBill' table. You can move, or remove it, as needed.
              this.NewBillTableAdapter.Fill(this.DataSet10.NewBill,R );
  
              this.reportViewer1.RefreshReport();
  
              ReportParameter[] allPar = new ReportParameter[5]; // create parameters array
              ReportParameter parSu = new ReportParameter("Summation", label2.Text);
              ReportParameter parDiscount = new ReportParameter("Discount", label5.Text);
              ReportParameter parDisA = new ReportParameter("DiscountAmount", label3.Text);
              ReportParameter parTotal = new ReportParameter("Total", label4.Text);
              ReportParameter parCus = new ReportParameter("CustomerName", label1.Text);
  
              allPar[0] = parSu; //assign parameters to parameter array
              allPar[1] = parDiscount;
              allPar[2] = parTotal;
              allPar[3] = parDisA;
              allPar[4] = parCus;
  
  
              this.reportViewer1.LocalReport.SetParameters(allPar);
              this.reportViewer1.RefreshReport();
          }
  </code></pre>
  
  <p>AND THIS</p>
  
  <pre><code>    int R = Convert.ToInt32(label7.Text);
      SqlDataAdapter ADAP = new SqlDataAdapter("Select * from Newbill where Con = '" + R + "'", cn);
      DataSet DS = new DataSet();
      ADAP.Fill(DS, "Store");
      DataTable dt = new DataTable();
      dt.TableName = "Store";
      cn.Open();
      ADAP.Fill(dt);
      reportViewer1.ProcessingMode = ProcessingMode.Local;
      ReportDataSource source = new ReportDataSource("Store", dt);
      reportViewer1.LocalReport.DataSources.Clear();
      reportViewer1.LocalReport.DataSources.Add(source);
      reportViewer1.DataBind();
      reportViewer1.LocalReport.Refresh();
      cn.Close();
  </code></pre>
  
  <p>it gives me :Error 'Microsoft.Reporting.WinForms.ReportViewer' does not contain a definition for 'DataBind' and no extension method 'DataBind' accepting a first argument of type 'Microsoft.Reporting.WinForms.ReportViewer' could be found</p>
  
  <p>so what reference i need in using?</p>