1.Imports System.Data.SqlClient
...
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=mySQLServerDBName;" & _
"Integrated Security=SSPI"
oSQLConn.Open()2.OLE DB Provider for SQL Server
For Standard SecurityoConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
...
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=mySQLServerDBName;" & _
"Integrated Security=SSPI"
oSQLConn.Open()2.OLE DB Provider for SQL Server
For Standard SecurityoConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
解决方案 »
- WebQQ的消息窗口怎么实现呢?
- 关于listbox循环取值问题
- 网易的WEB邮局,收邮件是用IMAP协议的还是POP3协议??
- 各位大哥大姐们,帮帮我吧!……(聊天室)通宵等待55555555555
- 动态的设置LinkButton的ToolTip值
- vs2003中远程打开别的机器上的工程并进行修改然后直接运行该怎么做?
- 虽然解决了,但是还要问一下
- 这个现象是怎么回事?
- 数据层、逻辑层对数据库连接字符串调用如何统一使用表现层网站项目中的唯一Web.config中的定义
- 请教,各位朋友,如何学习vs.net开发环境呢?
- namespace的问题
- 请教各位谁用过datatable的select()方法?现有一难题
1:使用OLEDB :
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(ConnStr);
2:使用Adapter
System.Data.OleDb.OleDbDataAdapter adp = new System.Data.OleDb.OleDbDataAdapter(CommText,ConnStr);
注:OleDb的方法与SqlClient相同,即:以上方法在SqlClient中同样适用3:使用ADO:
ADODB._Connection conn = new ADODB.ConnectionClass();
conn.ConnectionString = ConnStr;
注:需要先引用ADO