binding the data in the gridview

Question

Hi,

 

i am binding the data in the gridview as below;

 

protected void btnget_Click(object sender, EventArgs e)

{

lblerror.Text = "";

pnlmynomn.Visible = true;

grdawarddet.Visible = true;

pnlAOQ.Visible = false;

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

SqlCommand cmd = new SqlCommand();

SqlDataAdapter da = new SqlDataAdapter();

DataSet ds = new DataSet();

CultureInfo ci = new CultureInfo("en-GB", true);

try

{

int optionVal = 1;

conn = new SqlConnection();

conn.ConnectionString = connstr;

cmd = new SqlCommand();

cmd.Connection = conn;

conn.Open();

cmd.Connection = sqlconn;

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "HRN_NominationRep";

cmd.Parameters.AddWithValue("@year", drphryears.SelectedItem.ToString());

cmd.Parameters.AddWithValue("@quarter", drphrqtr.SelectedItem.ToString());

cmd.Parameters.AddWithValue("@optionVal", drphroption.SelectedItem.ToString());

cmd.Parameters.AddWithValue("@nominatedby", username);

da.SelectCommand = cmd;

da.Fill(ds, "MyNominations");

if (optionVal == '2')

{

grdawarddet.DataSource = ds.Tables[0];

grdawarddet.DataBind();

grdawarddet.Visible = true;

}

else if (optionVal == '1')

{

grdawarddet.DataSource = ds.Tables[0];

grdawarddet.DataBind();

grdawarddet.Visible = true;

}

else

{

optionVal = 0;

grdawarddet.DataSource = ds.Tables[0];

grdawarddet.DataBind();

grdawarddet.Visible = true;

}

}

catch (Exception ex)

{

lblerror.Text = ex.Message;

lblerror.Visible = true;

}

finally

{

conn.Close();

}

}

 

but the error is  coming while running the project.  please help me in this.

 

Thanks in advance,

Geetha