binding the data

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

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

if (DR_ClsDate != null)

if (DR_ClsDate.Read())

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.Visible = true;

finally