dbclass.cs

来自「购物车主要是为广大网上顾客购物的资源平台。购物车主要目标是建设在网上对用户进行信」· CS 代码 · 共 48 行

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

/// <summary>
/// sqlconn 的摘要说明
/// </summary>
public class DBClass
{
    public static SqlConnection GetConnection()
    {
        string strconn = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
        SqlConnection conn = new SqlConnection(strconn);


        return conn;
    }
    public DataTable GetDataTable(string sql)
    {
        SqlConnection sqlconn = GetConnection();
        sqlconn.Open();
        SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
        SqlDataAdapter da = new SqlDataAdapter(sqlcmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        sqlconn.Close();
        return ds.Tables[0];
    }


    public DBClass()
    {

        //
        // TODO: 在此处添加构造函数逻辑
        //
    }

}