dbconnection.cs

b to b 模式 电子商务系统

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

namespace B2Bsite
{
	/// <summary>
	/// 数据库连接类
	/// </summary>
	public class DBConnection
	{
		SqlConnection conn;
		SqlCommand cmd;
		SqlDataReader dr;
		SqlDataAdapter da;
		public string strSqlConn;
		public DBConnection()
		{
			conn=new SqlConnection(ConfigurationSettings.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;
		}

	}
}