booklist.aspx.cs

自己开发的一个wap手机网站源代码 公开代码供大家学习下载

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Mobile;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.MobileControls;
using System.Data.OleDb ;
using System.Web.UI.HtmlControls;
using System.Configuration;

public partial class booklist : System.Web.UI.MobileControls.MobilePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        AdRotator child = new AdRotator();
        child.AdvertisementFile="~/ad.xml";
        this.Form1.Controls.Add(child);
        DataSet dataset = new DataSet();
        dataset = this.GetDataset();
        Label[] labelArray = new Label[dataset.Tables[0].Rows.Count];
        for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
        {
            labelArray[i] = new Label();
            this.Form1.Controls.Add(labelArray[i]);
            labelArray[i].ID = "Lable" + i.ToString();
            labelArray[i].Text="##" + dataset.Tables[0].Rows[i]["类型"].ToString() + "##";
            labelArray[i].Visible = true;
            labelArray[i].BreakAfter=true;
            DataSet name = new DataSet();
            name = this.GetName(dataset.Tables[0].Rows[i]["类型"].ToString());
            Link[] linkArray = new Link[name.Tables[0].Rows.Count];
            for (int j = 0; j < name.Tables[0].Rows.Count; j++)
            {
                linkArray[j] = new Link();
                this.Form1.Controls.Add(linkArray[j]);
                linkArray[j].Text=name.Tables[0].Rows[j]["名称"].ToString();
                linkArray[j].NavigateUrl="readbook.aspx?id=" + name.Tables[0].Rows[j]["顺序"].ToString();
                linkArray[j].BreakAfter=false;
                Label label = new Label();
                label.Text="||";
                label.BreakAfter=false;
                this.Form1.Controls.Add(label);
            }
            Link link = new Link();
            link.Text="More..";
            link.NavigateUrl="bookintype.aspx?type=" + dataset.Tables[0].Rows[i]["类型"].ToString();
            this.Form1.Controls.Add(link);
        }
        Link link2 = new Link();
        link2.Text="返回主页";
        link2.NavigateUrl="index.aspx";
        this.Form1.Controls.Add(link2);
    }

    protected DataSet GetDataset()
    {
        DataSet dataSet = new DataSet();
        string connString = GetConnString();
        string selectCommandText = "select DISTINCT Type as 类型 from books where DeleteFlag = False";
        new OleDbDataAdapter(selectCommandText, connString).Fill(dataSet, "Tb1");
        return dataSet;
    }

    protected static string GetConnString()
    {
        string str2 = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string path = ConfigurationManager.ConnectionStrings["DBPaths"].ConnectionString;
        string str4 = HttpContext.Current.Server.MapPath(path);
        return (str2 + str4 + ";");
    }

    private DataSet GetName(string type)
    {
        DataSet dataSet = new DataSet();
        string connString = GetConnString();
        new OleDbDataAdapter("select top 5 id as 顺序, name as 名称, DeleteFlag from books where Type= '" + type + "' and DeleteFlag = False Order by id Desc", connString).Fill(dataSet, "Tb2");
        return dataSet;
    }

 




}