private void frmBankPayment_Load(object sender, EventArgs e)
{
c.GetMdiParent(this).EnableAllEditMenuButtons();
c.getconnstr();
c.FillcomboBox("select * from tbl_LedgerAcc where GRP_COD in (2) order by BHM_DESH", "BHM_DESH", "GRP_COD", ref valcmbbank);
c.FillcomboBox("select * from tbl_LedgerAcc where GRP_COD NOT in (1) order by BHM_DESH", "BHM_DESH", "GRP_COD", ref valcmbaccountgroup);
enableData();
SqlConnection con = c.myconn;
}
private void FrmJurnalLadger_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select acname,accode from tbl_account order by acname", "acname", "accode", ref valcmbbank);
dtpfrom.Value = c.GetFromDate(school.CurrentSessionCode);
dtpto.Value = c.GetToDate(school.CurrentSessionCode);
}
private void FrmBookWaiting_Load(object sender, EventArgs e)
{
try
{
c.getconnstr();
c.FillcomboBox("select * from tbl_Book order by bookName", "bookName", "bookno", ref cmbBookName);
//Connection.FillComboBox(cmbBookName, "Select Distinct bookno,bookName from tbl_Book ");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmsankay_Load(object sender, EventArgs e)
{
c.btnenable(btnnew, btnedit, btndelete, btnsave, btncancel, btnprint, null);
c.getconnstr();
c.FillcomboBox("select * from tbl_district order by district", "district", "distcode", ref valcmbdistrict);
c.FillListBox("select * from tbl_tehsil order by tehsil", "tehsil", "tehcode", ref listBox1);
c.returnconn(c.myconn);
SqlCommand command = new SqlCommand("select max(tehcode) from tbl_tehsil", c.myconn);
command.CommandTimeout = 120;
Int32 mstudentno;
mstudentno = 1001;
if (command.ExecuteScalar() != System.DBNull.Value)
{
mstudentno = Convert.ToInt32(command.ExecuteScalar()) + 1;
}
}
private void FrmCashBook_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select acname,accode from tbl_account where actype=dbo.GetAccountCode('C') order by acname", "acname", "accode", ref valcmbcash);
c.FillcomboBox("select acname,accode from tbl_account where actype=dbo.GetAccountCode('B') order by acname", "acname", "accode", ref valcmbbank);
}
private void frmCashBook_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select BHM_DESH,GRP_COD,BHM_COD from tbl_LedgerAcc where BHM_COD=1 order by BHM_DESH", "BHM_DESH", "BHM_COD", ref valcmbcash);
SqlConnection con = c.myconn;
}
private void frmJournalLedger_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select BHM_DESH,BHM_COD from tbl_LedgerAcc where GRP_COD not in(1,2) order by BHM_DESH", "BHM_DESH", "BHM_COD", ref valcmbcash);
SqlConnection con = c.myconn;
}
private void FmTitle_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select * from tbl_book", "bookname", "bookno", ref valcmbbook);
}
private void FrmVaccent_Load(object sender, EventArgs e)
{
c.getconnstr();
c.FillcomboBox("select hostelcode,hostelname from tbl_hostel order by hostelname", "hostelname", "hostelcode", ref valcmbclass);
c.GetMdiParent(this).ToggleSaveButton(true);
}