asp.netÁ¬½Ósql

µ÷ÓÃÊý¾ÝÁ¬½ÓÁ½ÖÖ·½·¨
1.web.config £¨ÅäÖÃÎļþ£© ÖÐ
<appSettings>
<add key="ConnectionString" value="server=localhost\sqlexpress;uid=sa;pwd=123456;database=News"/>
</appSettings>
µ÷ÓõÄʱºò
string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection Conn = new SqlConnection(strConn);
2.»òÕß²»ÓÃweb.configÖ±½ÓÔÚÎļþÖÐд
SqlConnection conn = new SqlConnection("server=.\\SQLEXPRESS;uid=sa;pwd=123456;database=login");
Èç¹ûд³É×Ö·û´®Ò»¶¨Òª×¢Òâ,ÐèҪдһ¸öתÒå×Ö·û ½á¹û¾ÍÊÇ .\\SqlExpress
ÈçºÎÊÇExpress°æµÄÊý¾Ý¿â£¬Ò»¶¨ÒªÔÚ·þÎñÆ÷ÃûµÄºóÃæ¼ÓÉÏ \\SSQLEXPRESS
Ò»¸öÍêÕûµÄÀý×Ó
   string userName = Request.Form["userName"];
         string userPwd = Request.Form["userPwd"];
         SqlConnection con = new SqlConnection("server=localhost\\SqlExpress;uid=sa;pwd=123456;database=login");
         con.Open();
         SqlCommand cmd=new SqlCommand("select count(*) from login where userName='"+userName+"' and userPwd='"+userPwd+"'",con);
         int count=Convert.ToInt32(cmd.ExecuteScalar());
         if(count>0)
         {
         Response.Redirect("main.aspx");
¸öÈ˾­Ñ飺
ÅäÖÃÎļþÈçÏ£º
<appSettings >
            <add key="ConnectionString"value="server=MICROSOF-4CBA94\SQL2005;uid=sa;pwd=*******;database=GuestBook"/>
    </appSettings>
csÎļþ£º SqlConnection conn = new SqlConnection(ConfigurationSettings .AppSettings["ConnectionString"].ToString());