<%@ import namespace="System.Data.SqlClient"%>Dim conn As New SqlConnection("server=(local);database=pubs;uid=sa;pwd=;") conn.Open() Dim da As New SqlDataAdapter("select * from authors", conn) Dim ds As DataSet da.Fill(ds)
<%@ import namespace="System.Data" %> <%@ import Namespace="System.Data.Oledb" %> <script language="vb" runat= "server">sub page_load(...) dim Con as new oledbconnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=c:\...\wjh.mdb")dim Da as new oledbdataadapter("select * from aothors",con) dim ds as dataset=new dataset("my") da.fill(ds,"mymy") datagrid1.datasource=ds.tables("mymy") datagrid1.databind() end sub
conn.Open()
Dim da As New SqlDataAdapter("select * from authors", conn)
Dim ds As DataSet
da.Fill(ds)
你写的我也知道的,可就是调试的时候出现我说的错误啊?
你写的我也知道的,可就是调试的时候出现我说的错误啊?
<%@ import Namespace="System.Data.Oledb" %>
<script language="vb" runat= "server">sub page_load(...)
dim Con as new oledbconnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=c:\...\wjh.mdb")dim Da as new oledbdataadapter("select * from aothors",con)
dim ds as dataset=new dataset("my")
da.fill(ds,"mymy")
datagrid1.datasource=ds.tables("mymy")
datagrid1.databind()
end sub
和<%@ import namespace="System.Data.SqlClient" %>
有什么区别吗?
感觉还是不错的。