Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static DataTable getResults(string _reqSelect, string _tableName, int _id_usr)
- {
- string serverIp = "localhost";
- string username = "root";
- string password = "";
- string databaseName = "labo";
- string conString = string.Format("server={0};uid={1};pwd={2};database={3};", serverIp, username, password, databaseName);
- MySqlConnection con = new MySqlConnection(conString);
- DataSet daSet1 = new DataSet();
- DataTable daTable1 = new DataTable();
- try
- {
- MySqlCommand cmd;
- con.Open();
- cmd = new MySqlCommand(_reqSelect, con);
- //cmd.Parameters.AddWithValue("@dt_cre", dt_cre);
- //cmd.Parameters.AddWithValue("@id_societe", _id_societe);
- MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
- adapter.Fill(daSet1, _tableName);
- daTable1 = daSet1.Tables[_tableName];
- }
- catch (Exception ex)
- {
- //labo.modele.SYS_LOG_Modele.tracerException(ex, _reqSelect);
- }
- try
- {
- con.Close();
- }
- catch (Exception ex)
- {
- //labo.modele.SYS_LOG_Modele.tracerException(ex);
- }
- return daTable1;
- }
- }
- DataTable dt = getResults("select id,nom,prenom from
- app_patient","app_patient", 1);
- //ReportParameter rp = new ReportParameter("ReportParameter1", "test test");
- this.ReportViewer1.Reset();
- this.ReportViewer1.Visible = true;
- this.ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
- //this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
- this.ReportViewer1.LocalReport.DataSources.Clear();
- this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
- //this.ReportViewer1.DataBind();
- this.ReportViewer1.LocalReport.Refresh();
Add Comment
Please, Sign In to add comment