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