安全性。尽管ASP.NET Internet 服务器应用程序编程接口(ISAPI)DLL阻止了客户直接访问带.config扩展名的文件,并且NTFS文件系统权限也用于进一步限制访问,但你可能仍希望避免以明文方式将这些内容存储在前端的Web Services器上。要增加安全性,需将链接字符串以加密格式存储在配置文件中。
Dim strSQL, strConn As String
Dim myConn As SqlConnection
Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
'在此处放置初始化页的用户代码
strConn = "User Id=SQL用户名;Password=密码;Initial Catalog=数据库名;Data Source=数据库所在的服务器名或IP地址"
strSQL = "查询语句"
myConn = New SqlConnection(strConn)
....
....
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "作者")
MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub
首先引入命名空间
using System.Data;
using System.Data.SqlClient;
连接
SqlConnection conn = New SqlConnection(connstr);
conn.Open(); //打开连接。连接字符自己写吧
SqlDataAdapter comm = new SqlCommand("select * from table where ...",conn);
DataSet ds = new DataSet();
comm.Fill(ds,"mytable");
conn.close();
这样返回的查询纪录在内存数据库ds的表mytable中
dim conn,rs
set conn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")'
conn.open "provider=sqloledb;data source=你的服务器地址;uid=用户名;pwd=密码;initial catalog=数据库名"
rs.open "select * from 表名",conn,1,1
<%
dim conn
dim connstr
on error resume next
set conn=server.createobject("ADODB.CONNECTION")
connstr="driver={SQL Server};server=(local);UID=sa;PWD=;database=YourDataBaseName"
conn.Open connstr
%>