db.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

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>
/// 黄建华（2007.9）
/// 数据库操作通用类
/// </summary>
public class DB
{
	public DB()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 创建连接对象
    /// </summary>
    /// <returns></returns>
    public static SqlConnection createCon()
    {
        return new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);

    }
    /// <summary>
    /// 执行无返回的数据库操作
    /// </summary>
    /// <param name="sql"></param>
    public static void sqlDo(string sql)
    {
        SqlConnection con =DB.createCon();
        con.Open();
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.ExecuteNonQuery();
        con.Close();
    }
    /// <summary>
    /// 执行返回表格的数据库操作
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static DataTable GetDataSource(string sql)
    {
        SqlConnection con = DB.createCon();
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        DataSet ds = new DataSet();
        da.Fill(ds, "source");
        return ds.Tables["source"];
    }
    /// <summary>
    /// 执行返回datareader的数据库操作
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static SqlDataReader GetDataReader(string sql)
    {
        SqlConnection con = DB.createCon();
        con.Open();
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataReader dr = cmd.ExecuteReader();
        return dr;
    }

}