asp.net连接sql,用vb.net

来源：百度知道 编辑：UC知道 时间：2024/05/15 06:15:15
问题1:怎么查看是否与数据库成功连接?
问题2:怎样编写查询数据库中表xsh的代码?
用vb.net 不胜感激!

%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
sub Page_Load(obj as object, e as eventargs)
'dim objConn as new OleDbConnection _
' ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
' "Data Source=H:\ASPNET\data\banking.mdb")
dim objConn as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;DSN=21DaysBanking")

dim objCmd as new OleDbDataAdapter _
("select * from tblUsers", objConn)

dim ds as DataSet = new DataSet()
objCmd.Fill(ds, "tblUsers")

dim dTable as DataTable = ds.Tables("tblUsers")
Dim CurrRows() as DataRow = dTable.Select(Nothing, _
Nothing, DataViewRowState