binding the data

Question

hi,

The below is the code to bind the year and quarter in the form.  it is working now.

protected void Page_Load(object sender, EventArgs e)

{

lblError.Text = "";

username = Context.User.Identity.Name.Replace("SASKEN\\", "");

try

{

if (!IsPostBack)

{

btnSubmit.Enabled = false;

string Closed_Date = "";

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnString"].ToString());

SqlCommand cmd = new SqlCommand("HRN_SP_CheckDateClosed", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@HRN_Clsdate", Closed_Date);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

conn.Open();

SqlDataReader DR_ClsDate = cmd.ExecuteReader(CommandBehavior.CloseConnection);

if (DR_ClsDate != null)

{

if (DR_ClsDate.Read())

{

Closed_Date = DR_ClsDate[0].ToString();

pnlAOQ.Visible = true;

lblYear.Text = Session["HRN_Year"].ToString();

lblQtr.Text = Session["HRN_Qtr"].ToString();

}

else

{

pnlAOQ.Visible = false;

lblError.Text = "Award period is closed.";

}

}

}

}

catch (Exception ex)

{

lblError.Text = ex.Message;

lblError.Visible = true;

}

finally

{

conn.Close();

}

}

 

can anybody help on this?

 

Rgds,

Geetha