Example #1
0
        private DataTable GetDataSource()
        {
            DataTable table = new DataTable();

            ds    = new DataSet();
            ppmsA = new ProjectPerGroupA();
            ds    = ppmsA.GetPerformanceDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedItem.Text,
                                                drpState.SelectedItem.Text, Convert.ToInt32(drpAgency.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;
        }
        private DataTable GetDataSource()
        {
            DataTable table = new DataTable();

            //disbReport = new DisbursementReport();
            // table = disbReport.BindGridview();
            ds    = new DataSet();
            ppmsA = new ProjectPerGroupA();
            ds    = ppmsA.GetPerformanceDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedItem.Text,
                                                drpState.SelectedItem.Text, Convert.ToInt32(drpAgency.SelectedValue));

            //grdProjectPerformanceGroupADetail.DataSource = ds;
            //grdProjectPerformanceGroupADetail.DataBind();
            table = ds.Tables[0];
            Session[clsConstant.SESS_TABLE] = table;
            return(table);
        }
        protected void GridViewBind()
        {
            ds    = new DataSet();
            dt    = new DataTable();
            ppmsA = new ProjectPerGroupA();
            ds    = ppmsA.GetPerformanceDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedItem.Text,
                                                drpState.SelectedItem.Text, Convert.ToInt32(drpAgency.SelectedValue),
                                                drpFromYear.SelectedIndex != 0 ? int.Parse(drpFromYear.SelectedItem.Text) : -1
                                                , drpFromMonth.SelectedIndex != 0 ? returnMonth(int.Parse(drpFromMonth.SelectedValue)) : ""
                                                , drpLstYear.SelectedIndex != 0 ? int.Parse(drpLstYear.SelectedItem.Text) : -1,
                                                drplstMonth.SelectedIndex != 0 ? returnMonth(int.Parse(drplstMonth.SelectedValue)) : ""

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


            this.functionModifyGrid();
        }