protected void Page_Load(object sender, EventArgs e)
{
string str_provider = "Provider=Microsoft.Jet.OLEDB.4.0;";
string str_source = "Data Source=" + MapPath("../App_Data/data.mdb");
string str_conn = str_provider + str_source;
OleDbConnection conn;
OleDbCommand comm;
OleDbDataReader datar;
string str_sql = "select c1 from data ";
conn = new OleDbConnection(str_conn);
conn.Open();
comm = new OleDbCommand(str_sql, conn);
datar = comm.ExecuteReader();
while (datar.Read())
{
reader.InnerHtml += datar["c1"].ToString() + "<br/>";
}
conn.Close();
}
----------------------------------------优化1
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + MapPath("../App_Data/data.mdb"));
conn.Open();
OleDbCommand cmd = new OleDbCommand("select c1 from data", conn);
OleDbDataReader odr = cmd.ExecuteReader();
while (odr.Read())
{
reader.InnerHtml += odr["c1"].ToString() + "<br/>";
}
conn.Close();
}
------------------------------------------------------优化2
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|datadirectory|data.mdb");
conn.Open();
OleDbCommand cmd = new OleDbCommand("select c1 from data", conn);
using (OleDbDataReader odr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (odr.Read())
{
reader.InnerHtml += odr["c1"].ToString() + "<br/>";
}
}
}
<div id="reader" runat="server" style="border: 1px solid black">