工作需要筆記

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;

/// 
/// db 的摘要描述
/// 
public class db
{
    public string DB連線字串 = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	public db()
	{
		//
		// TODO: 在這裡新增建構函式邏輯
		//
	}
    public SqlConnection 資料庫連線(string connString)
    {
        try
        {
            SqlConnection connDB = new SqlConnection(connString);
            connDB.Open();
            return connDB;
        }
        catch (SqlException ex)
        {
            throw (ex);
        }
    }
    int errCode = 0;
    //***************** 查詢_會員 ***************** 
    public DataSet 查詢_會員(int 第n頁,int 筆數)
    {
        SqlConnection conn = this.資料庫連線(DB連線字串);
        if (conn == null) { errCode = 1; }

        SqlDataAdapter da = new SqlDataAdapter("EXECUTE 會員_查詢", conn);
        DataSet ds = new DataSet();        
        try
        {
            da.Fill(ds, 第n頁, 筆數, "會員清單");
        }
        catch (Exception ex)
        {
            errCode = 1;
        }
        if (conn != null) { conn.Close(); conn.Dispose(); conn = null; }    //連線關閉
        return ds;
    }    
}