調用資料連接配接兩種方法

1.web.config （配置檔案） 中

<appsettings>

<add key="connectionstring" value="serverlocalhost\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");

如何是express版的資料庫，一定要在伺服器名的後面加上[url=file://%20%20ssqlexpress/]\\ssqlexpress[/url]

一個完整的例子

  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");

         }