导航栏绑定数据

最新推荐文章于 2023-03-25 18:00:25 发布

IT小金

最新推荐文章于 2023-03-25 18:00:25 发布

阅读量819

点赞数

分类专栏： ASP.NET前端文章标签： string function server asp float object

本文链接：https://blog.csdn.net/wysjwh/article/details/7375165

版权

ASP.NET前端专栏收录该内容

5 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace DBUtility {
	public class DbHelper {
		static string connectionString = ConfigurationManager.AppSettings["connString1"];

		public static object ExecuteScalar(string sql) {
			SqlConnection conn = new SqlConnection(connectionString);
			conn.Open();
			SqlCommand comm = conn.CreateCommand();
			comm.CommandText = sql;

			object obj = comm.ExecuteScalar();
			conn.Close();

			return obj;
		}

		public static int ExecuteNonQuery(string sql) {
			SqlConnection conn = new SqlConnection(connectionString);
			conn.Open();
			SqlCommand comm = conn.CreateCommand();
			comm.CommandText = sql;

			int rtn = comm.ExecuteNonQuery();

			conn.Close();

			return rtn;
		}

		public static DataTable FillData(string selectCommandText) {

			SqlDataAdapter da = new SqlDataAdapter(selectCommandText, connectionString);
			da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
			DataTable dt = new DataTable();
			da.Fill(dt);
			return dt;
		}
	}
}

//上面是DBhlpler类

 public class asp_fDAL
    {
        //string str = "server=192.168.2.220, database=Subject, id=N01, password=123";
        public static DataTable asp_f_memu()
        {
            DataTable dt = new DataTable();
            dt=DBHepler.datafill("select *from Subject");
            return dt;
        }
        public static DataTable aricle()
        {
            DataTable dt = new DataTable();
            dt = DBHepler.datafill("select top 15 *from Article");
            return dt;
        }
    }

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //显示菜单
                this.creatmenu();
                //文章标题
                this.Aricle();       
            }
           
        }
       
        //显示菜单
        public void creatmenu()
        { 
            DataTable dt = asp_fDAL.asp_f_memu();
            dt.DefaultView.Sort="ID";
            StringBuilder html = new StringBuilder();

            //html.Append("<div id='menu' ranat='server'>\n");
            foreach (DataRow dr in dt.Rows)
            {
                if (dr["ParentID"].ToString()=="0"){
                    html.Append("<p>"+dr["Title"].ToString()+"</p>\n");
                    string id = dr["ID"].ToString();
                    DataRow[] drs = dt.Select("ParentID="+ id);
                    html.Append("\t<ul>\n");
                    foreach (DataRow dar in drs)
                    {
                        html.AppendFormat("\n\t\t<li><a href='{0}'>{1}</a></li>",dar["Url"].ToString(),dar["Title"].ToString());
                    } 
                    html.Append("\n\t</ul>\n");

                }
              
            }
            //html.Append("</div>\n");
            //Response.Write(html.ToString());
            menu.InnerHtml = html.ToString();
        }
        //文章标题
        public void Aricle()
        {
            DataTable dt = asp_fDAL.aricle();
            this.Repeater1.DataSource = dt;
            this.Repeater1.DataBind(); 
        }

<head runat="server">
    <title>下拉列表</title>
    <style type="text/css">    
     #lay{ float:right;}
     #menu { float:left; width:140px;text-align:center;font-size:12px;position:relative;}
     #menu p{ font-family:Verdana; font-weight:bolder; background-color:#6EA0E0; padding:7px 0 5px; margin:1px; cursor:pointer;}  
     #menu ul{ list-style-type:none;margin:0; padding:0;}
     #menu li{ margin-top:5px;}
     #menu a{ display:block; padding:5px 0 3px; text-decoration:none;color:#7EA0E0;}
     .ent{ color:#fff;}
     .fnt{ background-color :#ddd;}
     #list{ float:left;list-style-type:none; width:700px; margin-top:0; font-size:12px;position:relative;}
     #list li{ background:url(/image/dot_01.gif) repeat-x bottom; padding:5px 0 3px; font-weight:bold;}
     #list span{ float:right; color:#797979;}
     #list a{text-decoration:none;color:#7EA0E0; margin-left:10px;}
     #list a:hover{ text-decoration:underline; color:#777;}
    </style>
    
    <script src="js/jquery-1.7.1.min.js" type="text/javascript"></script>
    <script type="text/javascript">
    
     $(function(){
         $('#menu ul').hide();
         $('#menu p').mouseover(function(){
             //$('#menu p').not($(this).next()).removeClass('ent');这句话可以简写....
             $('#menu p').removeClass('ent');
             $(this).toggleClass('ent');
         })
         $('#menu li').mouseover(function(){
             $('#menu li').removeClass('fnt');
             $(this).toggleClass('fnt');
         })
         $('#menu p').click(function(){
            $('#menu ul').not($(this).next()).slideUp(300);
            $(this).next('ul').slideToggle(300);
            
         })
     });
    </script>
</head>
<body>
<form id="form1" runat="server">
         <div id="menu" runat="server"></div>
         <ul id="list">
             <asp:Repeater ID="Repeater1" runat="server">
             <ItemTemplate>
                <li><img src="image/asp_1.png" width="16px"; height="16px";alt="" /><a href="javascript:;"><%#Eval("Title")%></a> <span><%#Eval("PostTime","{0:yyyy-MM-dd}")%></span></li>
             </ItemTemplate>
             </asp:Repeater>
         </ul>
   
</form>
</body>