<body> <nav class="navbar navbar-expand-lg navbar-dark bg-dark"> <a class="navbar-brand" href="#">Navbar</a> <div class="collapse navbar-collapse" id="navbarNavDropdown"> <ul class="navbar-nav"> <li class="nav-item"> <a class="nav-link" href="#">Home </a> </li> <li class="nav-item"> <a class="nav-link" href="#">Features</a> </li> <li class="nav-item"> <a class="nav-link" href="#">Pricing</a> </li> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" href="#" id="navbarDropdownMenuLink" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Brands </a> <div class="dropdown-menu" id="ddlbrands" aria-labelledby="navbarDropdownMenuLink" runat="server"> <%--<a class="dropdown-item" href="#">Action</a> <a class="dropdown-item" href="#">Another action</a> <a class="dropdown-item" href="#">Something else here</a>--%> </div> </li> </ul> </div> </nav> <asp:ContentPlaceHolder ID="MainContentPlaceholder" runat="server"> </asp:ContentPlaceHolder> </body>
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { using (SqlConnection connect = new SqlConnection(cs)) { using (SqlCommand scmd = new SqlCommand("SELECT DISTINCT BrandName FROM Products", connect)) { using (SqlDataAdapter da = new SqlDataAdapter(scmd)) { using (DataSet ds = new DataSet()) { connect.Open(); da.Fill(ds); ddlbrands.DataSource = ds; // throws error since Datasource is not a property. ddlbrands.DataBind(); connect.Close(); } } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
ListView
<div class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink"> <asp:ListView id="ddlbrands" runat="server"> <ItemTemplate> <a class="dropdown-item" href="#"><%#: Eval("BrandName") %></a> </ItemTemplate> </asp:ListView> </div>
Console.WriteLine
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)