You can use Repeater control
<div id="ulmenu">
<ul class="sf-menu">
<li class="current"><a href="#a">FURNITURE</a>
<ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>
<li><a href='#<%#Eval("name") %>'><%#Eval("name") %></a> </li>
</ItemTemplate>
</asp:Repeater>
</ul>
</li>
</ul>
</div>
protected void Page_Load(object sender, EventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "Housemenu";
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
rptMenu.DataSource = ds;
rptMenu.DataBind();
}
}
}
}