请问
asp.net与sql server 2000连接有几中方法?
分别是什么?
能给出例子吗?
并说明每一个参数的含义
谢谢
asp.net与sql server 2000连接有几中方法?
分别是什么?
能给出例子吗?
并说明每一个参数的含义
谢谢
解决方案 »
- iis6.0站点列表的增加删除和查看问题
- 导出EXCEL时,可否控制EXCEL视图的显示比例?
- 求一正则的写法
- 用UpdatePanel后页面还刷新的问题。。。
- 微软的技术文章《使用NUnit在.Net编程中进行单元测试》编译出错!不知错在哪里?
- 请教后登陆踢出前登陆者实现方案
- 一个伤脑筋的问题??
- 关于多页打印
- 我定义的用户控件在第一次显示时正常,但是在获取该用户返回的值时,总提示未将对象引用设置到对象的实例。
- 关于B/S模式下的开发、管理方式,以及一些经验,请教,要分就说一声
- 高手请进:如何用 gdi+ 实现winform任务管理器中的cpu占有率图或者内存使用率图,超难得问题,多谢了
- GDI 图片加字的重新保存的问题
Dim cmd As SqlClient.SqlCommand
conn = New SqlClient.SqlConnection("server=192.168.1.5;UID=hackate;PWD=123456;database=mngk"这个是连接的
您可以直接在代码中创建 SqlConnection 对象。以编程方式在应用程序和 SQL Server 数据库之间创建连接 下面的代码创建一个 SqlConnection 对象、设置 SqlConnection.ConnectionString 属性并打开该连接。
' Visual Basic
Public Sub ConnectToSql()
Dim conn As New SqlClient.SqlConnection
' TODO: Modify the connection string and include any
' additional required properties for your database.
conn.ConnectionString = & _
"integrated security=SSPI;data source=SQL Server Name;" & _
"persist security info=False;initial catalog=northwind"
Try
conn.Open()
' Insert code to process data.
Catch ex As Exception
MessageBox.Show("Failed to connect to data source")
Finally
conn.Close()
End Try
End Sub// C#
public void ConnectToSql ()
{
System.Data.SqlClient.SqlConnection conn =
new System.Data.SqlClient.SqlConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString =
"integrated security=SSPI;data source=SQL Server Name;" +
"persist security info=False;initial catalog=northwind";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
不过操作具体来说有两种:一种是SqlCommand,一种是通过SqlDataAdapter.第一种:
Dim myConnection As SqlConnection=New SqlConnection("server=local;database=..;uid=..")
Dim myCommand As Sqlcommand=New Sqlcommand()
myCommand.connection=myConnection
.....第二种:
Dim myConnection As SqlConnection=New SqlConnection("server=local;database=..;uid=..")
Dim myDataAdapter As New SqlDataAdapter("secect * from student",myConnection)
Dim ds as New DataSet
myDataAdapter.Fill(ds,"student")
....
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;" OLE DB, 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;" 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;" SqlConnection (.NET) :
Standard Security:"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"
(booth connection strings produces the same result)
Trusted Connection:"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(booth connection strings produces the same result)(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;"
SqlConection的使用:
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()
中的server是什么参数
如果是本地的话
可以是server=(local);
2,sql server连接方法
3,OLE DB连接方法