广州英文培训机构:求 asp.net 数据库连接代码

<%@ import namespace = "system.data" %>
<%@ import namespace = "system.data.oledb" %>
<script language="vb" runat=server>
sub page_load(sender as object , e as eventargs)
dim conn as string = "provider.jet.oledb.4.0;data source = " & server.mappath("数据库名")
dim sql as string = "sql 语句"
dim da as new oledbdataadapter(sql,conn)
dim ds as dataset()
da.fill(ds,"chwu")
dim mytable as datatable = ds.tables("chwu")
end sub
</script>
在内存中打开一个数据表.名字是mytable.现在可以进行任何操作了.
新手先学学ado.net吧.

你的问题很深奥

你学习asp.net
却要Access连接vb

下面是vb.net的
'用OleDB连
Dim OleDbConnection1 As New System.Data.OleDb.OleDbConnection
OleDbConnection1.ConnectionString = "Data Source=""E:\Project\HaTsuON_Win\data.mdb;Provider=""Microsoft.Jet.OLEDB.4.0"";"

下面是C#的
string connStr =@"Data Source=\"E:\Project\HaTsuON_Win\data.mdb;Provider=\"Microsoft.Jet.OLEDB.4.0\";";
System.Data.OleDb.OleDbConnection OleDbConnection1 = new System.Data.OleDb.OleDbConnection(connStr);