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(); }