ASP.NET2.0 ¶ÔSqlConnectionÁ¬½Ó·½Ê½µÄ²Ù×÷Àà

Ë®ÖÐdeÔÆ

sqlConn.cs£¬°ÑÕâ¸öÎļþ·ÅÔÚApp_CodeÎļþ¼ÐÏ£¬¾Í¿ÉÒÔµ÷ÓÃÕâЩ·½·¨ÁË!
ËäÈ»°ÑÁ¬½Ó×Ö·û´®·ÅÔÚÅäÖÃÎļþÏÂÃæÒ²¿ÉÒÔ£¬µ«ÊÇ£¬Õâ¸ö¶ÔÊý¾ÝµÄ²Ù×÷·½·¨¸ü¼òµ¥Ã÷ÁË£¡

--------------------------------
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>
/// Summary description for sqlConn
/// </summary>
public class sqlConn
{
public sqlConn()
{
   //
   // TODO: Add constructor logic here
   //
}
     //connstring£ºÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®£¬Ö»ÒªÐÞ¸ÄËü¾Í¿ÉÒÔÁ¬½Ó²»Í¬µÄÊý¾Ý¿â
     public static string connstring = "server=.;database=pubs;uid=sa;pwd=";
     //ÕâÀï¸ù¾ÝSQLÓï¾äÉú³ÉÒ»¸öDataSet£¬DataSetÖ§³Ö·ÖÒ³¹¦ÄÜ£¡
     public static DataSet GreatDs(string sql)
     {
         SqlDataAdapter Dar = new SqlDataAdapter(sql, connstring);
         DataSet ds = new DataSet();
         Dar.Fill(ds);
         return ds;
     }
     //ÕâÀï¸ù¾ÝSQLÓï¾äÉú³ÉÒ»¸öSqlDataReader,SqlDataReader²»Ö§³Ö·ÖÒ³¹¦ÄÜ£¡
     public static SqlDataReader GreatDR(string sql)
     {
         SqlConnection conn = new SqlConnection(connstring);
         conn.Open();
         SqlCommand cmd=new SqlCommand(sql,conn);
         SqlDataReader dr = cmd.ExecuteReader();
         return dr;
         conn.Close();
     }
     //ÕâÀïÖ´ÐÐÒ»SQLÓï¾ä
     public static void DoSql(string sql)
     {
         SqlConnection conn = new SqlConnection(connstring);
         conn.Open();
         SqlCommand cmd = new SqlCommand(sql, conn);
         cmd.ExecuteNonQuery();
         conn.Close();
     }
}