sharecommon.cs

值班管理系统源码 net2005+sqlserver2005 ,三层模式

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.Diagnostics;

/// <summary>
/// ShareCommon 的摘要说明
/// </summary>
public class ShareCommon
{
	public ShareCommon()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    string sqlConnectionString = string.Empty;

    public static string SqlConnectionString
    {
        get { return System.Configuration.ConfigurationManager.AppSettings["SqlConnString"].ToString(); }
       
    }

    public static DataSet dsBySql(string sql)
    {
        DataSet ds = null;
        using (SqlConnection conn = new SqlConnection(SqlConnectionString))
        {
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter(sql,conn);
            ds = new DataSet();
            da.Fill(ds);
            return ds;
        }

    }
    public static void executeNonQuery(string sql)
    {
        using (SqlConnection conn = new SqlConnection(SqlConnectionString))
        {
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                Debug.WriteLine(ex.ToString());
            }
            finally
            {
                conn.Close();
            }

        }
    }

   
}