protected void ddlSearchCategory1_SelectedIndexChanged(object sender, EventArgs e)
    {
        // to bind second ddl value based on the first ddl value...
        DataTable  ds = new DataTable();
        GeneralBAL lp = new GeneralBAL();

        ds = lp.FetchLPGridDetails(ddlSearchCategory1.SelectedItem.Text);
        grdLP.DataSource = ds;
        grdLP.DataBind();
    }
 protected void gridPageChanging(object sender, GridViewPageEventArgs e)
 {
     if (ddlSearchCategory.SelectedItem.Text == "Select" & ddlSearchCategory1.SelectedItem.Text == "Select")
     {
         DataSet      ds1 = new DataSet();
         LPDetailsBAL lp1 = new LPDetailsBAL();
         ds1 = lp1.FetchLP();
         grdLP.DataSource = ds1.Tables[0];
         grdLP.PageIndex  = e.NewPageIndex;
         grdLP.DataBind();
     }
     else
     {
         DataTable  ds = new DataTable();
         GeneralBAL lp = new GeneralBAL();
         ds = lp.FetchLPGridDetails(ddlSearchCategory1.SelectedItem.Text);
         grdLP.DataSource = ds;
         grdLP.PageIndex  = e.NewPageIndex;
         grdLP.DataBind();
     }
 }
 protected void gridPageChanging(object sender, GridViewPageEventArgs e)
 {
     if (ddlSearchCategory.SelectedItem.Text == "Select" & ddlSearchCategory1.SelectedItem.Text == "Select")
     {
         DataSet ds1 = new DataSet();
         LPDetailsBAL lp1 = new LPDetailsBAL();
         ds1 = lp1.FetchLP();
         grdLP.DataSource = ds1.Tables[0];
         grdLP.PageIndex = e.NewPageIndex;
         grdLP.DataBind();
     }
     else
     {
         DataTable ds = new DataTable();
         GeneralBAL lp = new GeneralBAL();
         ds = lp.FetchLPGridDetails(ddlSearchCategory1.SelectedItem.Text);
         grdLP.DataSource = ds;
         grdLP.PageIndex = e.NewPageIndex;
         grdLP.DataBind();
     }
 }
 protected void ddlSearchCategory1_SelectedIndexChanged(object sender, EventArgs e)
 {
     // to bind second ddl value based on the first ddl value...
     DataTable ds = new DataTable();
     GeneralBAL lp = new GeneralBAL();
     ds = lp.FetchLPGridDetails(ddlSearchCategory1.SelectedItem.Text);
     grdLP.DataSource = ds;
     grdLP.DataBind();
 }