在asp.net中，如何连接sql server数据库

[llc1981]

急盼！！！

[mmkk]

SqlConnection myConnection = new SqlConnection("user id=sa;pwd=;initial catalog=KMS;server=localhost;timeout=30");
SqlCommand myCommand = new SqlCommand(Sql语句,myConnection);
...............
看看quickstart吧

[hgknight]

找个数据库的教程
不同数据库只要换个连接串就行

[mbm]

这是一个连接数据库的方法，强烈推荐

web.config中
<configuration>
<appSettings>
<add key="conn" value="initial catalog=TianJin;data source=192.168.1.148;user id=test;password=test" />
</appSettings>

<system.web>
...
...

写一个类，定义静态的方法
//返回一个sqlconnection对象
public static SqlConnection ReturnConnection()
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["conn"]);
return myconn;
}

[Richard2001]

VB.net例子：

1.在客户方（Html）代码中加入：

<%@ Import Namespace=System.Data %>
<%@ Import NameSpace="System.Data.OLEDB" %>
<%@ Import NameSpace="System.Data.SQLClient" %>

2.在服务器方(Server)引用：

Dim cn As New OleDb.OleDbConnection()
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=;Initial Catalog=MyDataBase;Data Source=188.18.18.168"
cn.Open()
Dim strSql As String, i As Integer, j As Integer
strSql = "Select * From tTable "
Dim rs As OleDb.OleDbDataReader
Dim cmd As New OleDb.OleDbCommand(strSql, cn)
rs = cmd.ExecuteReader
While rs.Read() = True
If IsDBNull(rs("FieldName")) Then
txtName.Text = ""
Else
txtName.Text = rs("FieldName")
End If
...
End While

rs.Close()
cn.Close()
rs = Nothing
cn = Nothing