private void BindGrid()
{
adp = new SqlDataAdapter("select AppNo, Enrolment as Membership,IMID,Course,Part,Session,Amount,FormType,CAD from AppRecord where Status!='NotApproved' and Status!='Hold' and Status!='Filled' and (FormType='MCADRegistration' or FormType='MCADLateFee') order by CAD", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridAutoCad.DataSource = dt;
GridAutoCad.DataBind();
}
protected void btnView_Click(object sender, EventArgs e)
{
adp = new SqlDataAdapter("select AppNo, Enrolment as Membership,IMID,Course,Part,Session,Amount,FormType,CAD from AppRecord where Status!='NotApproved' and Status!='Hold' and Status!='Filled' and CAD='" + txtAppNo.Text.ToString() + "' and (FormType='MCADRegistration' or FormType='MCADLateFee') order by CAD", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridAutoCad.DataSource = dt;
GridAutoCad.DataBind();
}
private void clear()
{
txtSID.Text = ""; txtSID.Focus(); GridAutoCad.DataBind(); pnlFees.Visible = false; pnlspc.Visible = true;
}
private void BindTb()
{
DataTable dt = new DataTable(); adp.Fill(dt); GridAutoCad.DataSource = dt; GridAutoCad.DataBind();
}