高考问答清远地图导航:asp.net连接sql,用vb.net
来源：百度文库 编辑：高考问答 时间：2024/04/28 22:27:12
问题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.CurrentRows)
Dim I, J as integer
Dim strOutput as string
For I = 0 to CurrRows.Length - 1
For J = 0 to dTable.Columns.Count - 1
strOutput = strOutput & dTable.Columns(J). _
ColumnName & " = " & CurrRows(I)(J).ToString & _
"<br>"
next
next
Response.write(strOutput)
end sub
</script>
<html><body>
</body></html>