problem in selecting a value from drop down
<p>I am having a problem in selecting a value from dropdown list. Regardless of whatever I choose only the <strong>first value is selected always</strong>. Please help...</p>

<p>Here is the code...</p>

<pre><code>protected void Button4_Click(object sender, EventArgs e)
{
    SqlConnection con;

    String strcon = ConfigurationManager.AppSettings["Constr"].ToString();
    try
    {
        if (!IsPostBack)
        {
        con = new SqlConnection(strcon);
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("select user_name from user_details where role='USER'", con);     
        DataSet ds = new DataSet();

            da.Fill(ds);
            DropDownList1.DataTextField = "user_name";
            DropDownList1.DataSource = ds.Tables[0].DefaultView;
            DropDownList1.DataBind();
        }

    }
    catch (Exception ex)
    {
        Response.Write(ex.Message.ToString());

    }




protected void Button6_Click(object sender, EventArgs e)
{

    string Name = Session["name"].ToString();
    SqlConnection con;

    String strcon = ConfigurationManager.AppSettings["Constr"].ToString();
    try
    {
        con = new SqlConnection(strcon);
        con.Open();


        SqlDataAdapter da = new SqlDataAdapter("select user_name,Arival,late,Day_count from attedance where user_name='" + DropDownList1.SelectedItem.Text + "' ", con);
        DataSet ds = new DataSet();

        da.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
    }
    catch (Exception ex)
    {
        Response.Write(ex.Message.ToString());

    }
</code></pre>
