dbconnection.cs

B2B网上商城

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// DBConnection 的摘要说明
/// </summary>
public class DBConnection
{
    SqlConnection conn;
    SqlCommand cmd;
    SqlDataReader dr;
    SqlDataAdapter da;
    public string strSqlConn;
    public DBConnection()
    {
        conn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
        conn.Open();
    }
    public DBConnection(string cstr)
    {
        conn = new SqlConnection(cstr);
        conn.Open();
    }
    public SqlDataReader ExecuteReader(string sql)
    {
        cmd = new SqlCommand(sql, conn);
        dr = cmd.ExecuteReader();
        return dr;
    }
    public void ExecuteNonQuery(string sql)
    {
        cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
    }
    public void Updata(string sql)
    {
        cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
    }
    public ICollection CreateSource(string sql)
    {
        da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "mytable");
        return ds.Tables["mytable"].DefaultView;
    }

}