二级菜单从mysql中取_二级菜单绑定数据库 | 学步园

前台：利用repeater绑定

onitemdatabound="Repeater1_ItemDataBound">

CSS样式：

/*二级菜单*/

#nav {

line-height:31px;

list-style-type:none;

background:#666;

margin-left:50px;

}

#nav a {

display: block; width: 140px; text-align:center;

height:30px;

}

#nav a:link  {

color:#666; text-decoration:none;

}

#nav a:visited  {

color:#666;text-decoration:none;

}

#nav a:hover {

color:#FFF;text-decoration:none;font-weight:bold;height:30px;

}

#nav li{

float: left;

width:100px;

background:#CCC;

height:30px;

}

#nav li a:hover{

background:#999;

}

#nav li ul{

line-height: 27px;  list-style-type: none;text-align:left;

left: -999em; width: 180px; position: absolute;

}

#nav li ul li{

float: left; width: 150px;

background: #F6F6F6;

}

#nav li ul a{

display: block; width: 120px;height: 15px;text-align:left;padding-left:24px;

}

#nav li ul a:link  {

color:#666; text-decoration:none;

}

#nav li ul a:visited  {

color:#666;text-decoration:none;

}

#nav li ul a:hover  {

color:#F3F3F3;text-decoration:none;font-weight:normal;

background-color:#C00;

width:126px;

}

#nav li:hover ul {

left: auto;

}

#nav li.sfhover ul {

left: auto;

}

#mrc {

clear: left;

}

后台：

protected void firstmenu()

{

string str = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;

DataTable dt = new DataTable();

using (SqlConnection conn = new SqlConnection(str))

{

conn.Open();

using (SqlCommand command = conn.CreateCommand())

{

command.CommandText = "select * from T_FileBig";

SqlDataAdapter adapter = new SqlDataAdapter(command);

adapter.Fill(dt);

}

}

this.Repeater1.DataSource = dt;

this.Repeater1.DataBind();

}

//二级菜单

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

DataTable dt1 = new DataTable();

HiddenField h = e.Item.FindControl("hiddenfield1") as HiddenField;

string str = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;

using (SqlConnection conn = new SqlConnection(str))

{

conn.Open();

using (SqlCommand command = conn.CreateCommand())

{

command.CommandText = "select * from T_FileSmall where Type1ID=" + h.Value;

SqlDataAdapter adapter = new SqlDataAdapter(command);

adapter.Fill(dt1);

}

}

Repeater r = e.Item.FindControl("Repeater2") as Repeater;

if (r != null)

{

r.DataSource = dt1;

r.DataBind();

}

}