protected void GridviewBind() { ds = new DataSet(); ppmsC = new ProjectPerGroupCDetails(); #region FindFinancialclosure DataTable dt = new DataTable(); string said = string.Empty; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; conn.Open(); cmd.CommandText = "USP_LoanFinancialClosure"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Quarter", drpFromQuarter.SelectedValue); cmd.Parameters.AddWithValue("@Year", drpFromYear.SelectedValue.ToString()); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } } } #endregion grdProjectPerformanceGroupCDetail.DataSource = dt;; grdProjectPerformanceGroupCDetail.DataBind(); Session[clsConstant.SESS_TABLE] = dt; }
protected void GridviewBind() { ds = new DataSet(); ppmsC = new ProjectPerGroupCDetails(); ds = ppmsC.GetPerformanceDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedValue, Convert.ToInt32(drpFromYear.SelectedItem.Text), Convert.ToInt32(drpFromQuarter.SelectedValue)); grdProjectPerformanceGroupCDetail.DataSource = ds; grdProjectPerformanceGroupCDetail.DataBind(); dt = ds.Tables[0]; Session[clsConstant.SESS_TABLE] = dt; }
private DataTable GetDataSource() { DataTable table = new DataTable(); ds = new DataSet(); ppmsC = new ProjectPerGroupCDetails(); ds = ppmsC.GetPerformanceDetails(Convert.ToInt32(drpLoanNumber.SelectedValue), drpSector.SelectedValue, Convert.ToInt32(drpFromYear.SelectedValue), Convert.ToInt32(drpFromQuarter.SelectedValue)); grdProjectPerformanceGroupCDetail.DataSource = ds; grdProjectPerformanceGroupCDetail.DataBind(); table = ds.Tables[0]; Session[clsConstant.SESS_TABLE] = table; return(table); }