title: How to use multiple datasets in rdlc c# report
body: <p>Firstly I need to create reports that use a select from database through <code>TextBox</code> input. How can I get textbox value and generate a report based in this <code>TextBox</code>? And if I need to use multiple <code>DataSets</code> for fill some tables with informations in my report, how to do it? Note: I use a WPF to get <code>TextBoxes</code> values and Winforms to create <code>reportViewer</code>.</p>
  
  <pre><code>private void Report_Load(object sender, EventArgs e)
  {
  
        DataSet dsr = new DataSet();
        _con = new SqlConnection(_strCon);
        _adp = new SqlDataAdapter("Select * from tbl_cad",_con);
        _adp.Fill(dsr,dsr.Tables[0].TableName);
  
        ReportDataSource rds = new ReportDataSource("tbl_cad",dsr.Tables[0]);
        this.reportViewer.LocalReport.DataSources.Clear();
        this.reportViewer.LocalReport.DataSources.Add(rds);
        this.reportViewer.LocalReport.Refresh();
  
        this.reportViewer.RefreshReport();
  }
  </code></pre>