ASP.NET连接mssql的问题？！！

Question

myConnection.ConnectionString = "data source=localhost;initial catalog=test;user id=sa;persost security=True;password="

Answer 1

<%@ import namespace="System.Data"%>
<%@ import namespace="System.Data.SqlClient"%>
<script language="c#" runat="server">
String strConn="server=localhost;uid=sa;pwd=sa;database=Northwind";
</script>

Answer 2

//连接SQL Server数据库
SqlConnection conn=new SqlConnection(@"server=glf;uid=sa;pwd=;database=northwind");
SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM products",conn);
da.Fill(ds,"products");

Answer 3

<appSettings>
<add key="data" value="data source=localhost;initial catalog=test;password=sa;persist security info=True;user id=sa;packet size=4096">
</add>
</appSettings>

Answer 4

SqlConnection MyConnection = New SqlConnection("server=localhost;uid=sa;pwd=;Database=test");
这样试试

Answer 5

到这个网站看看http://www.connectionstrings.com/index.asp

Answer 6

各位误会我的意思了，我现在可以连接上mssql，代码是这样的
MyConnection = New SqlConnection("server=localhost;uid=sa;pwd=;Database=test")
我的问题是，为什么这样连不可以MyConnection = New SqlConnection("server=(local)\NetSDK;database=northwind;Integrated Security=SSPI")Integrated Security=SSPI是什么意思

Answer 7

.NET中各种数据库连接大全SQL Server 
ODBC 
Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;" 
Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;" 
Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;" 
OLEDB, OleDbConnection (.NET) 
Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 
Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" 
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;" 
Connect via an IP address:
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" 
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET) 
Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 
Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" 
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" 
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
Declare the SqlConnection:C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open(); VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open() 
Data Shape 
MS Data Shape
"Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;"