private DataTable GetDataSource()
        {
            DataTable table = new DataTable();

            ds    = new DataSet();
            ppmsA = new ProjectPerGroupA();

            ds = ppmsA.GetPerformanceOverRideDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedValue, drpState.SelectedValue, drpAgency.SelectedValue,
                                                     Convert.ToInt32(drpFromYear.SelectedValue), Convert.ToInt32(drpFromMonth.SelectedValue));
            table = ds.Tables[0];
            Session[clsConstant.SESS_TABLE] = table;
            return(table);
        }
        protected void GridviewBind()
        {
            ds    = new DataSet();
            ppmsA = new ProjectPerGroupA();


            ds = ppmsA.GetPerformanceOverRideDetails(Convert.ToInt32(drpLoanNumber.SelectedValue),
                                                     drpSector.SelectedItem.Text, drpState.SelectedItem.Text, Convert.ToInt32(drpAgency.SelectedValue)
                                                     , drpFromYear.SelectedIndex != 0 ? int.Parse(drpFromYear.SelectedItem.Text.ToString()) : -1
                                                     , drpFromMonth.SelectedIndex != 0 ? returnMonth(int.Parse(drpFromMonth.SelectedValue)) : ""

                                                     );
            grdOverrideGroupA.DataSource = ds;
            grdOverrideGroupA.DataBind();
            dt = ds.Tables[0];
            Session[clsConstant.SESS_TABLE] = dt;
        }