private void btnRead_Click(object sender, EventArgs e) { try { MdlBill bobj = new MdlBill(); //dgvExcel.DataSource = obj.GetBillDataFromFile(tbFileName.Text); // reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1",obj.GetBillDataFromFile(tbFileName.Text)) ); // reportViewer1.LocalReport.DataSources = obj.GetBillDataFromFile(tbFileName.Text); // MdlBillBindingSource.DataSource = obj.GetBillDataFromFile(tbFileName.Text); DataTable dt1 = new DataTable(); dt1 = obj.GetBillDataFromFile(tbFileName.Text); MdlBillBindingSource.DataSource = bobj.ConvertDtToList(dt1); //dgvExcel.DataSource = MdlBillBindingSource; //reportViewer2.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dt1)); reportViewer2.RefreshReport(); } catch (Exception ex) { MessageBox.Show("An Error Occoured: Check data otherwise contact admin:\n" + ex.Message); } }
public List <MdlBill> ConvertDtToList(DataTable dt) { //MngExcel cexl = new MngExcel(); //dt = cexl.GetBillDataFromFile(filepath); List <MdlBill> lst = new List <MdlBill>(); MdlBill obj; foreach (DataRow dr in dt.Rows) { obj = new MdlBill(); obj.consumerid = dr["ConsumerID"].ToString(); obj.oldid = dr["OldID"].ToString(); obj.consumername = dr["ConsumerName"].ToString(); obj.consumertype = dr["ConsumerType"].ToString(); obj.cnicno = dr["CNICNo"].ToString(); obj.contactno = dr["ContactNo"].ToString(); obj.zone = dr["Zone"].ToString(); obj.uc = dr["UC"].ToString(); obj.plothouse = dr["PlotHouseNo"].ToString(); obj.houseentrtance = dr["Houseentrance"].ToString(); obj.plotsize = dr["PlotSize"].ToString(); obj.streetno = dr["Street#"].ToString(); obj.sectormohalla = dr["SectorMohallah"].ToString(); obj.phase = dr["Phase"].ToString(); obj.area = dr["Area"].ToString(); obj.from = dr["BillingPeriodFrom"].ToString(); obj.to = dr["BillingPeriodTo"].ToString(); obj.issuedate = dr["Issueddate"].ToString(); obj.duedate = dr["DueDate"].ToString(); obj.watercg = dr["WaterCharges"] == System.DBNull.Value ? 0: Convert.ToDouble(dr["WaterCharges"]); obj.conservancycg = dr["ConservancyCharges"] == System.DBNull.Value? 0: Convert.ToDouble(dr["ConservancyCharges"]); obj.seweragecg = dr["SewerageCharges"] == System.DBNull.Value? 0: Convert.ToDouble(dr["SewerageCharges"]); obj.newconncg = dr["NewConnectionCharges"] == System.DBNull.Value?0: Convert.ToDouble(dr["NewConnectionCharges"]); obj.totalcrntdue = dr["TotalCurrentdues"] == System.DBNull.Value? 0: Convert.ToDouble(dr["TotalCurrentdues"]); obj.arears = dr["Arears"] == System.DBNull.Value ? 0: Convert.ToDouble(dr["Arears"]); obj.amountpaybyduedate = dr["AmountPayablebyDuedate"] == System.DBNull.Value? 0: Convert.ToDouble(dr["AmountPayablebyDuedate"]); obj.surcharge = dr["Surcharge@10%afterduedate"] == System.DBNull.Value ? 0: Convert.ToDouble(dr["Surcharge@10%afterduedate"]); obj.amountpayafterduedate = dr["AmountPayableafterDuedate"] == System.DBNull.Value ? 0 : Convert.ToDouble(dr["AmountPayableafterDuedate"]); if (obj.consumername.Length > 80) { obj.consumername = obj.consumername.Substring(0, 80); } if (obj.sectormohalla.Length > 12) { obj.sectormohalla = obj.sectormohalla.Substring(0, 12); } if (obj.area.Length > 16) { obj.area = obj.area.Substring(0, 16); } if (obj.plotsize.Length > 12) { obj.plotsize = obj.plotsize.Substring(0, 12); } //obj.account = dr["Account"].ToString(); lst.Add(obj); } return(lst); }