How can I bind my value to drop menu list from my SQL database.
COLOR: red will have select as red in drop down menu list.
Color:
red
orange
white
blue
green
<asp:gridview id="gridview1" runat="server"
autogeneratecolumns="False" >
<columns>
<asp:BoundField DataField="ID" HeaderText="NAME" />
<asp:templatefield headertext="Color">
<itemtemplate>
<asp:dropdownlist id="dropdownlist1" runat="server">
</asp:dropdownlist>
</itemtemplate>
</asp:templatefield>
</columns>
</asp:gridview>
protected void Page_Load(object sender, EventArgs e)
{
gridview1.DataSource = getdataset();
gridview1.DataBind();
}
private DataSet getdataset()
{
//string connectionstring = "Data Source=localhost;Initial
Catalog=northwind;User ID=sa;password=";
//string query = "";
// sql statement remove
SqlConnection myconnection = new
SqlConnection(connectionstring);
SqlDataAdapter ad = new SqlDataAdapter(query, myconnection);
DataSet ds = new DataSet();
ad.Fill(ds);
return ds;
}