c# - How to populate 'select' from database in asp.net -

c# - How to populate 'select' from database in asp.net -

i have html command select

<select id="select1" runat="server" name="d1"> <option></option> </select>

how can populate info sql server database using c# or javascript/jquery/json?

please, not post answers on how populate asp:dropdownlist because know how it, must utilize select control.

aspx:

<select id="select1" runat="server" name="d1"> </select>

code behind:

protected void page_load(object sender, eventargs e) { if (!ispostback) { string connectstring = "server=localhost;database=pubs;integrated security=sspi"; string querystring = "select * authors"; sqlconnection myconnection = new sqlconnection(connectstring); sqldataadapter mycommand = new sqldataadapter(querystring, myconnection); dataset ds = new dataset(); mycommand.fill(ds, "authors"); select1.datasource = ds; select1.datatextfield = "au_fname"; select1.datavaluefield = "au_fname"; select1.databind(); } }

c# asp.net html sql-server