Fill DropDown List on GridView in ASP.Net

<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />

<RowStyle BackColor="White" ForeColor="#333333" />

<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />

<SortedAscendingCellStyle BackColor="#F7F7F7" />

<SortedAscendingHeaderStyle BackColor="#487575" />

<SortedDescendingCellStyle BackColor="#E5E5E5" />

<SortedDescendingHeaderStyle BackColor="#275353" />

</asp:GridView>

</form>

</body>

</html>

public void bindgrid()

{

SqlCommand cmd = new SqlCommand("select * from food ", con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

GridView1.DataSource = dt;

GridView1.DataBind();

}

else

{

DataRow dr = dt.NewRow();

dt.Rows.Add(dr);

GridView1.DataSource = dt;

GridView1.DataBind();

}

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

SqlCommand cmd = new SqlCommand("select * from food ", con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

DropDownList DropDownList1 =

(DropDownList)e.Row.FindControl("DropDownList1");

DropDownList1.DataSource = dt;

DropDownList1.DataTextField = "Fname";

DropDownList1.DataValueField = "Fid";

DropDownList1.DataBind();

}

}

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

DropDownList drp = (DropDownList)sender;

GridViewRow gv = (GridViewRow)drp.NamingContainer;

int index = gv.RowIndex;

DropDownList DropDownList1 = (DropDownList)GridView1.Rows[index].FindControl("DropDownList1");

Label label1 = (Label)GridView1.Rows[index].FindControl("label1");

label1.Text = DropDownList1.SelectedItem.Text;

}

Final Output