Prepopulate gridview empty datasource
<p>I use an gridview empty datasource for bulk insert, how would I prepopulate for instance Column A with the value of a drop down box? So far I have below, but its not working</p>

<pre><code>protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        TextBox tb = (TextBox)e.Row.FindControl("YourTextBoxID");
        if(tb != null)
        {
            tb.Text = DropDownList1.SelectedItem.Text;
        }
    }
}
</code></pre>
