CODEWITHSUNDEEP
c#asp.nethtmlhtml-datalist
Carlo Adap
Carlo Adap

Reputation: 257

HTML 5 Datalist Option

How can I use data from database to place it in a datalist for HTML5

for example

<input list="browsers">

<datalist id="browsers">
  <option value="Internet Explorer">
  <option value="Firefox">
  <option value="Chrome">
  <option value="Opera">
  <option value="Safari">
</datalist>

How can I retrieve options from database? Instead of placing it manually. I'm using asp.net C#

Upvotes: 4

Views: 3922

Answers (1)

Carlo Adap
Carlo Adap

Reputation: 257

I already solve my problem by using this codes.

protected void Page_Load(object sender, EventArgs e)
{
    bindProducts();
}

private void bindProducts()
{
    using (systemDbEntities context = new systemDbEntities())
    {
        var q = from c in context.Products select new { c.ProductId, c.Name };
        foreach (var item in q)
        {
            lstProducts.InnerHtml += "<option value='" + item.Name + "'>";
        }
    }
}



<asp:TextBox ID="txtBoxSearch" runat="server" placeholder="Search"  
             list="lstProducts"></asp:TextBox>
<datalist id="lstProducts" runat="server"></datalist>

Thank you guys! :)

Upvotes: 4

Related Questions