asp.net dropdownlist in gridview
<p>im working on an asp.net website with a gridview.</p>

<p>The gridview has data from an sql database.</p>

<p>Like:</p>

<pre><code>Cuntry----Name
USA--------John
England----Frank
</code></pre>

<p>...</p>

<p>The data is loaded in to the gridview like this:</p>

<pre><code>SqlCommand cmd;
        cmd = new SqlCommand();
        cmd.Connection = sqlConn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "sp_loadData";
        sqlConn.Open();

        dr = cmd.ExecuteReader();

        DataTable dt = new DataTable();
        dt.Load(dr);
        GridView1.DataSource = dt;
        GridView1.DataBind();
</code></pre>

<p>So, in the name column, i want a dropdownlist. And I want the dropdownlist with the corresponding value from the database selected.</p>

<p>How can I do this?</p>

<p>Thanks</p>
