db.cs

来自「实现asp.net技术以及它是如何使用的 实现asp.net技术以及它是如何使」· CS 代码 · 共 53 行

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.SqlClient;

/// <summary>
/// db 的摘要说明
/// </summary>
public class db
{
    protected string connstring;
    private int pagesize;
	public db()
	{
        connstring = "Data source=.;database=pubs;Integrated Security=SSPI";
        pagesize = 4;
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public DataTable dt(string query)
    {
        SqlConnection con = new SqlConnection(connstring);
        SqlDataAdapter sda = new SqlDataAdapter(query, con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "name");
        return ds.Tables["name"];

    }
    public PagedDataSource pds()
    {
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = dt("select * from authors").DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = pagesize;
        pds.CurrentPageIndex = pds.CurrentPageIndex;
        return pds;
    }
    public int sql(string query)
    {
        SqlConnection con = new SqlConnection(connstring);
        con.Open();
        SqlCommand cmd = new SqlCommand(query, con);
        return cmd.ExecuteNonQuery();
    }
}