db.cs

上海中商互联 六线主机空间

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// 购买ASP.NET2.0空间　ASP,MSSQL2005空间请联系ＱＱ：５４９７１６０９４
/// 注册２５元注册cn域名　http://www.ebiz8.com 
/// </summary>
public class db
{
    protected string connstring;
    private int pagesize;
	public db()
	{
        connstring=ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
        pagesize = 4;
	}
    public DataTable dt(string query)
    {
        OleDbConnection con = new OleDbConnection(connstring);
        OleDbDataAdapter sda = new OleDbDataAdapter(query, con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "name");
        return ds.Tables["name"];
    }
    /// <summary>
    /// 六线空间让你网速无限，注册地址：http://www.ebiz8.com QQ:59716094
    /// </summary>
    /// <returns></returns>
    public PagedDataSource pds()
    {
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = dt("select * from flash").DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = pagesize;
        pds.CurrentPageIndex = pds.CurrentPageIndex;
        return pds;
    }
    public PagedDataSource pds(int pg)
    {
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = dt("select * from flash").DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = pagesize;
        pds.CurrentPageIndex = pg;
        return pds;
    }
    public int sql(string query)
    {
        OleDbConnection con = new OleDbConnection(connstring);
        con.Open();
        OleDbCommand cmd = new OleDbCommand(query, con);
        return cmd.ExecuteNonQuery();
    }

      
    
    
}