<%@ page language="c#" contenttype="text/html" responseencoding="gb2312" %>
<script language="c#" runat="server">
void page_load()
{
string db_path = @"data\db.mdb"; //把路径更改可看到错误信息
string db = server.mappath(db_path);
string strsql = "select * from admin";
string connstring = "provider=microsoft.jet.oledb.4.0;data source=" + db;
system.data.oledb.oledbdatareader dr;
system.data.oledb.oledbconnection conn = null;
system.data.oledb.oledbcommand cmd = null;
//=======================================================
try
{
conn = new system.data.oledb.oledbconnection(connstring);
cmd = new system.data.oledb.oledbcommand(strsql,conn);
cmd.connection.open();
}
catch (exception ex)
{
conn.close();
response.write("connection was closed!<br>" + ex.message);
return;
}
//=======================================================
dr = cmd.executereader();
datagrid1.datasource = dr;
datagrid1.databind();
conn.close();
}
</script>
<asp:datagrid id="datagrid1" runat="server"></asp:datagrid>
