Guest User

Untitled

a guest
Mar 24th, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. public static DataTable getResults(string _reqSelect, string _tableName, int _id_usr)
  2. {
  3.  
  4. string serverIp = "localhost";
  5. string username = "root";
  6. string password = "";
  7. string databaseName = "labo";
  8.  
  9. string conString = string.Format("server={0};uid={1};pwd={2};database={3};", serverIp, username, password, databaseName);
  10. MySqlConnection con = new MySqlConnection(conString);
  11.  
  12. DataSet daSet1 = new DataSet();
  13. DataTable daTable1 = new DataTable();
  14.  
  15. try
  16. {
  17. MySqlCommand cmd;
  18. con.Open();
  19. cmd = new MySqlCommand(_reqSelect, con);
  20. //cmd.Parameters.AddWithValue("@dt_cre", dt_cre);
  21. //cmd.Parameters.AddWithValue("@id_societe", _id_societe);
  22.  
  23. MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
  24. adapter.Fill(daSet1, _tableName);
  25. daTable1 = daSet1.Tables[_tableName];
  26.  
  27. }
  28. catch (Exception ex)
  29. {
  30. //labo.modele.SYS_LOG_Modele.tracerException(ex, _reqSelect);
  31. }
  32.  
  33. try
  34. {
  35. con.Close();
  36. }
  37. catch (Exception ex)
  38. {
  39. //labo.modele.SYS_LOG_Modele.tracerException(ex);
  40. }
  41. return daTable1;
  42.  
  43. }
  44. }
  45.  
  46. DataTable dt = getResults("select id,nom,prenom from
  47. app_patient","app_patient", 1);
  48.  
  49. //ReportParameter rp = new ReportParameter("ReportParameter1", "test test");
  50. this.ReportViewer1.Reset();
  51. this.ReportViewer1.Visible = true;
  52. this.ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
  53. //this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
  54. this.ReportViewer1.LocalReport.DataSources.Clear();
  55. this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
  56. //this.ReportViewer1.DataBind();
  57. this.ReportViewer1.LocalReport.Refresh();
Add Comment
Please, Sign In to add comment