I want to make crystal report in windows application from multiple tables in mysql database but when i use this no any data shown on my report how i can troubleshoot this? Somebody help me Please....
This is my Code
MySqlDataAdapter adapter1 = new MySqlDataAdapter("Select Addmission_No,Date,Month,Student_Name,Class,Section,Roll_NO,Address,Fathers_Name,Development_Fee,Transport_Fee,Tutition_Fee,Hostal_Fee,Others,Misc,Examination_Fee,SchooBasedActivity, ScienceLabCharge, ComputerLabCharge,Total From Demand_Bill where Addmission_No='" + AdmNo + "'AND Month='" + month + "'", Connection.Connect_Main());
MySqlDataAdapter adapter2 = new MySqlDataAdapter("Select ID,School_Name,Established_Date,Address,Contact from Account_Details", Connection.Connect_Main());
MySqlDataAdapter adapter3 = new MySqlDataAdapter("Select Coalesce(Dues_Amount-Paid_Amount)as Total_Amount from Student_Account where Addmission_No='" + AdmNo + "'", Connection.Connect_Main());
Demandbill smdata = new Demandbill();
adapter1.Fill(smdata, "Demand_Bill");
adapter2.Fill(smdata, "Account_Details");
adapter3.Fill(smdata, "Student_Account");
DemandReport demrep = new DemandReport();
demrep.SetDataSource(smdata);
crystalReportViewer1.ReportSource = demrep;