<%@import namespace="system.data"%> <%@ Import namespace="system.data.oledb" %> <%@import namespace="system.data.SQLclient"%><html> <head> <script language="vb" runat="server"> sub page_load(src as object,e as eventargs) dim ds as dataset Dim conn As OleDbConnection, da As OleDbDataAdapter,sql As String conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(ConfigurationSettings.AppSettings("数据库"))) sql = "Select * From aclass" da = New OleDbDataAdapter(sql, conn) ds=new dataset da.Fill(ds,"aclass") mydatagrid.datasource = ds.tables("aclass").defaultview mydatagrid.databind()end sub </script>
<%@ Import namespace="system.data.oledb" %>
<%@import namespace="system.data.SQLclient"%><html>
<head>
<script language="vb" runat="server">
sub page_load(src as object,e as eventargs)
dim ds as dataset
Dim conn As OleDbConnection, da As OleDbDataAdapter,sql As String
conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(ConfigurationSettings.AppSettings("数据库")))
sql = "Select * From aclass"
da = New OleDbDataAdapter(sql, conn)
ds=new dataset
da.Fill(ds,"aclass")
mydatagrid.datasource = ds.tables("aclass").defaultview
mydatagrid.databind()end sub
</script>
类型“System.Data.OleDb.OleDbDataAdapter”的值无法转换为“System.Data.DataSet”。