数据库高手请关注, 解决就给分 在线等待!!!!!!!!!!!!!
我是初学者 下面是我访问ACESS的程序 请大家帮我改改!
<% @import namespace="system.data" %>
<% @import namespace="system.data.oledb" %>
<%
dim con as oledbconnection
con=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\lsz.mdb;")
con.open()
dim sl saa string
saa="select * from t1"
dim comm as oledbdatasetcommand
dim dset as dataset=new dataset
comm=new oledbdatasetcommand(saa,con)
comm.filldataset(dset,"aaa")
con.close
con=nothing
abc.datasource=dset.tables("aaa").defaultview
abc.databind()
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<asp:datagrid id="abc" runat="server"/>
</body>
</html>