private void comboBox2_Leave(object sender, EventArgs e) { DataTable dtBillAmount, dtAmountPaid; decimal TotalAmountPaid, TotalBillAmount; reportManDataSetTableAdapters.BillBillAmountTableAdapter BBA = new reportManDataSetTableAdapters.BillBillAmountTableAdapter(); reportManDataSetTableAdapters.BillAmountPaidTableAdapter BAP = new reportManDataSetTableAdapters.BillAmountPaidTableAdapter(); dtBillAmount = BBA.GetDataByTotalBillAmount(comboBox2.Text); try { TotalBillAmount = Convert.ToDecimal(dtBillAmount.Rows[0]["TotalBill"].ToString()); } catch { TotalBillAmount = 0; } dtAmountPaid = BAP.GetDataByTotalAmountPaid(comboBox2.Text); try { TotalAmountPaid = Convert.ToDecimal(dtAmountPaid.Rows[0]["TotalAmountPaid"].ToString()); } catch { TotalAmountPaid = 0; } balance = TotalBillAmount - TotalAmountPaid; label8.Text = balance.ToString(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { // int cnt = dtStudents.Rows.Count; string studNames; string src = ConfigurationManager.ConnectionStrings[1].ConnectionString; using (SqlConnection con = new SqlConnection(src)) { SqlCommand cmd = new SqlCommand("truncate table defaulters", con); con.Open(); cmd.ExecuteNonQuery(); } DataTable dtStudents; DataTable dtBillAmount, dtAmountPaid; decimal TotalAmountPaid, TotalBillAmount, balance; reportManDataSetTableAdapters.StudentInfoTableAdapter activeStudents = new reportManDataSetTableAdapters.StudentInfoTableAdapter(); reportManDataSetTableAdapters.BillBillAmountTableAdapter BBA = new reportManDataSetTableAdapters.BillBillAmountTableAdapter(); reportManDataSetTableAdapters.BillAmountPaidTableAdapter BAP = new reportManDataSetTableAdapters.BillAmountPaidTableAdapter(); reportManDataSetTableAdapters.defaultersTableAdapter insDefaulters = new reportManDataSetTableAdapters.defaultersTableAdapter(); dtStudents = activeStudents.GetDataByActiveClassStudents(comboBox1.Text); foreach (DataRow dr in dtStudents.Rows) { // subj = drt[0].ToString(); studNames = dr[4].ToString().Trim(); dtBillAmount = BBA.GetDataByTotalBillAmount(studNames); try { TotalBillAmount = Convert.ToDecimal(dtBillAmount.Rows[0]["TotalBill"].ToString()); } catch { TotalBillAmount = 0; } dtAmountPaid = BAP.GetDataByTotalAmountPaid(studNames); try { TotalAmountPaid = Convert.ToDecimal(dtAmountPaid.Rows[0]["TotalAmountPaid"].ToString()); } catch { TotalAmountPaid = 0; } balance = TotalBillAmount - TotalAmountPaid; insDefaulters.InsertQuery(studNames, comboBox1.Text, TotalBillAmount, TotalAmountPaid, balance); // MessageBox.Show(studNames + " "+TotalBillAmount+ " "+TotalAmountPaid+ " "+balance); this.defaultersTableAdapter.FillByClassDefaulters(this.reportManDataSet.defaulters, comboBox1.Text); this.reportViewer1.RefreshReport(); } }