Click here to Skip to main content
15,883,883 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
C#
private void crystalReportViewer_Load(object sender, EventArgs e)
      {


Report.CustomerDailyCrystalReport cr = new Report.CustomerDailyCrystalReport();
cr.SetDataSource(getDs());
crystalReportViewer.ReportSource = cr;
}

C#
public DataSet getDs()
     {
         conn = new OleDbConnection(Program.Fire_DB);
         conn.Open();
         string query = "SELECT fd_license_no AS [ترخيص البلدية], name_of_comp AS [اسم المؤسسة], register_no AS [رقم تصريح], mobile_no AS [رقم الجوال], location AS [المكان], license_validity AS [الانتهاء], entry_id AS [هوية العميل] FROM tbl_fire_entry_details where license_validity = '" + dtp_expiry_date.Text + "'";
         da = new OleDbDataAdapter(query, conn);
         ds = new DataSet();
         da.Fill(ds, "tbl_fire_entry_details1");
         return ds;
     }
Posted
Comments
[no name] 6-May-13 11:12am    
This is a code dump, not a question or description of any kind of a problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900