private void button1_Click(object sender, EventArgs e)
{
//For Receipt
//SqlDataAdapter da = new SqlDataAdapter("Select TrNo,TType as FeeType,TDesc as Description,Amount as Amount from tbl_dailytransaction where TrNo=(Select isnull(max(TrNo),0) from tbl_dailytransaction)", d.con);
//DataSet ds = new DataSet();
//da.Fill(ds);
//FeeCrystalReport1 fc = new FeeCrystalReport1();
//fc.SetDataSource(ds.Tables[0]);
FeeCollectionReprt fr = new FeeCollectionReprt();
fr.Show();
//Do balance coding
}
private void BtnReport_Click(object sender, EventArgs e)
{
SchoolManagement.dtp3 = datetime1.Value.ToShortDateString();
SchoolManagement.dtp4 = dateTime2.Value.ToShortDateString();
string s = "SELECT Amount, BillNo, Feetype, Description, TranDate FROM tbl_FeesCollection where TranDate>='" + SchoolManagement.dtp3 + "'AND TranDate<= '" + SchoolManagement.dtp4 + "' ";
SqlDataAdapter da = new SqlDataAdapter(s, d.con);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count >= 1)
{
FeeCollectionReprt fcr = new FeeCollectionReprt();
fcr.Show();
}
else
{
MessageBox.Show("No transaction avialable between these two days", "Warning..", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}