How to Bind a column of GridView to a DropDownList?
<p>I have a GridView and i want to bind the first Column(teachername) with a DropDownList which i have outside the GridView. How can i make it work?</p>

<pre><code> protected void Button2_Click(object sender, EventArgs e)
{
     string q = "select * from teacher where teachername='" + drpteachername.SelectedItem.ToString() + "'  and ('2013-03-01' between date and todate) and '2013-03-31' between date and todate";
    dt = dbo.Getdt(q);
    GridView1.DataSource = dt;
    GridView1.DataBind();
    string teachername=drpteachername.SelectedItem.ToString();


    for (int i = 0; i &lt; dt.Rows.Count ;i++ )
    {
        Label lblteachername = (Label)GridView1.Rows[i].Cells[0].FindControl("lblgridteachername");

                  this.GridView1.Rows[i].Cells[0].Value = teachername;
    }


}
</code></pre>
