default.aspx.cs

来自「自己开发的一个wap手机网站源代码 公开代码供大家学习下载」· CS 代码 · 共 50 行

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.Web.UI.WebControls;
using System.Data.OleDb;
using System.Web.UI.HtmlControls;
using System.Configuration;

public partial class Default2 : System.Web.UI.MobileControls.MobilePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataSet dataSet = new DataSet();
        DataSet set2 = new DataSet();
        string connString = GetConnString();
        string selectCommandText = "select top 5 [id] as 顺序, [name] as 名称 from [books] where [DeleteFlag] = False Order by [id] Desc";
        OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommandText, connString);
        OleDbDataAdapter adapter2 = new OleDbDataAdapter("select top 5  [id],[picname] from [Pictures] where [DeleteFlag] = False order by id desc ;", connString);
        adapter.Fill(dataSet, "Book");
        adapter2.Fill(set2, "Picture");
        for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
        {
            MobileListItem item = new MobileListItem(dataSet.Tables[0].Rows[i]["名称"].ToString(), "readbook.aspx?id=" + dataSet.Tables[0].Rows[i]["顺序"].ToString());
            this.List1.Items.Add(item);
        }
        for (int j = 0; j < set2.Tables[0].Rows.Count; j++)
        {
            MobileListItem item2 = new MobileListItem(set2.Tables[0].Rows[j]["picname"].ToString(), "See.aspx?id=" + set2.Tables[0].Rows[j]["id"].ToString());
            this.List2.Items.Add(item2);
        }

    }

    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 + ";");
    }

}