c#做网站：创建与sqlserver数据库进行sql连接的类DB

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()
 {
 
 }
    public static SqlConnection createCon()
    {
        string conString = System.Configuration.ConfigurationManager.AppSettings["conStr"];
        SqlConnection conn = new SqlConnection(conString);
        if (conn.State.Equals(ConnectionState.Closed))
        {
            conn.Open();
        }
        return conn;
    }
}

 

 

用法示例：

SqlConnection conn = DB.createCon();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from Prjinfo order by ID ";
        cmd.Connection = conn;