Asp.NetÖÐsql server 2000/2005 Á¬½Ó×Ö·û´®

http://zhanglei1286.blog.163.com/blog/static/1895797120091112113019600/
ÔÚºǫ́´úÂëÀ
SQL 2000:
static string StrConn = "server=.;uid=sa;pwd=sa;database=MyCUDS";
SQL2005:
con = new SqlConnection(@"Server=.\SQLExpress;Database=db_CMS;Persist Security Info=True;User ID=sa;Password=Masslong");
ÔÚweb.configÀ
sql 2000:
<connectionStrings>
    <add name="RateSystemConnectionString" connectionString="Data Source=.;Initial atalog=RateSystem;
   User ID=sa Pwd=sa" providerName="System.Data.SqlClient" />
</connectionStrings>
sql 2005:
<connectionStrings>
   <add name="BookShopConnectionString" connectionString="Data Source=.\SQLEXPRESS;
Initial Catalog=BookShop;Integrated  Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
/////////////////////////////////////////////
<connectionStrings>
    <add name="ConnectionString" providerName="System.Data.SqlClient" connectionString="Data Source=(local);Initial Catalog=dbname;User ID=sa;Password=1"/>
</connectionStrings>
DBHelper.cs»ñµÃ×Ö·û´®
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
(*×¢£ºData Source¿ÉÒÔÓÃServer´úÌ棬Initial Catalog±íʾÊý¾Ý¿âÃû£¬¿ÉÒÔÓÃDatabase´úÌ棬(local)±íʾ±¾µØÁ¬½Ó£¬Èç¹ûÊÇÔ¶³ÌÁ¬½Ó£¬¿ÉÒÔÓÃÔ¶³ÌÖ÷»úÃû»òIPÀ´±íʾ)
<appSettings>
    <add key="ConnectionString"  value="Data Source=(local);Initial Catalog=dbname;User ID=sa;Password=1"/>
</appSettings>
<appSettings>  
    <add key="ConnectionString"   value="server=192.168.1.1;database=shop;uid=sa;pwd=*"/>  
</appSettings> 
DBHelper.cs»ñµÃ×Ö·û´®
string connectionString =ConfigurationManager.AppSettings["ConnectionString"];