db.cs

microsoft公司在进行ASP.NET 2.0培训课时课堂操作演示代码。

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>
/// DB 的摘要说明
/// </summary>
public class DB
{
	public DB()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public SqlConnection GetConnection()
    {
        string constr = System.Configuration.ConfigurationManager.ConnectionStrings["NewsDBConnectionString"].ConnectionString;
        SqlConnection Con = new SqlConnection(constr);
        return Con;
    }
    public DataSet GetSqlDataSet(string sql,string tablename )
    {
        SqlConnection Con = this.GetConnection();
        SqlDataAdapter Sda = new SqlDataAdapter(sql, Con);
        DataSet Ds = new DataSet();
        Sda.Fill(Ds, tablename);
        return Ds;
    
    }
    public void ExcuteMultSqlData(string sql,SqlParameter[] param)
    {
        SqlConnection Con = this.GetConnection();
        SqlCommand Cmd = new SqlCommand(sql, Con);
        Cmd.Parameters.AddRange(param);
        Con.Open();
        Cmd.ExecuteNonQuery();
        Con.Close();
    }
    public void ExcuteOneSqlData(string sql,SqlParameter param)
    {
        SqlConnection Con = this.GetConnection();
        SqlCommand Cmd = new SqlCommand(sql, Con);
        Cmd.Parameters.Add(param);
        Con.Open();
        Cmd.ExecuteNonQuery();
        Con.Close();
    }
    public int  GetCountData(string sql,SqlParameter  param)
    {
        SqlConnection Con = this.GetConnection();
        SqlCommand Cmd = new SqlCommand(sql, Con);
        Cmd.Parameters.Add(param);
        Con.Open();
        int count =(int)Cmd.ExecuteScalar();
        Con.Close();
        return count;
    }
}