ajaxmethod1.aspx.cs

ajax 实现仿照 igoogle的界面

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class googlei_ajaxmethod1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string name1 = Request.QueryString["keyword"];
        string name = "";
        name = name1.Substring(0, 1);

        switch (Convert.ToInt32(name.Trim()))//1-获得类别数
        {
            case 1:
                Response.Write(getd(name1.Substring(1, 1)));
                break;

            case 2:
                 Response.Write(gettext(name1.Substring(1, 1)));
                break;


        }


    }


    private string gettext(string id)
    {
        OleDbConnection conn = getdb();
        conn.Open();
        OleDbCommand oc = new OleDbCommand();
        string res = "";
        string sql = "select tt from ttt where tnum=" + id;

        oc.CommandText = sql;
        oc.Connection = conn;
        OleDbDataReader ob = oc.ExecuteReader();
        if (ob.Read())
        {
            res = ob.GetString(0);
            res = res.Substring(0, 55)+"…………";
        }
        return res;
    }

    private string getd(string id)
    {
        try
        {
            OleDbConnection conn = getdb();
            conn.Open();
            OleDbCommand oc = new OleDbCommand();
            string res = "";
            string sql = "select aid,atitle from art where anum=" + id;
            string temp = "";
            oc.CommandText = sql;
            oc.Connection = conn;
            OleDbDataReader ob = oc.ExecuteReader();
            while (ob.Read())
            {
                temp = ob.GetInt32(0).ToString() + "&" + ob.GetString(1);
                res = res + temp;
                res = res + ";";
            }
            conn.Close();
            return res;
        }
        catch (Exception ee)
        {
            return ee.ToString(); ;
        }
    }

    private OleDbConnection getdb()
    {
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
                @"Data source=" + Server.MapPath("db.mdb");
        return conn;
    }
}