OLEDB数据库代码访问

来源：互联网发布：python写的大型游戏编辑：程序博客网时间：2024/04/29 12:30

.aspx代码如下：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="练习1.aspx.cs" Inherits="练习1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server">    <title></title></head><body>    <form id="form1" runat="server">    <div>    <div id="div_reader" runat="server" style ="border:1px solid gray">        </div>    </div>    </form></body></html>

.aspx.cs代码如下：

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.OleDb;public partial class 练习1 : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {       <span style="color:#cc0000;"> string str_provider = "Provider=Microsoft.Jet.OLEDB.4.0;";//这一句容易拼写出错！        string str_source = "Data Source=" + MapPath("~/mdb/mydb.mdb");</span>        string str_connection = str_provider + str_source;        OleDbConnection con;        OleDbCommand cmd;        OleDbDataReader datar;        string str_sql = "SELECT news_ttl FROM TB_NEWS ";        con = new OleDbConnection(str_connection);        con.Open();        cmd = new OleDbCommand(str_sql, con);        datar = cmd.ExecuteReader();        while (datar.Read()) {             div_reader.<span style="color:#ff0000;">InnerHtml</span>+=            datar["news_ttl"].ToString()+"<br/>";                                    }        con.Close();                }}

<span style="color:#cc0000;">string str_provider = "Provider=Microsoft.Jet.OLEDB.4.0;";//这一句容易拼写出错！        string str_source = "Data Source=" + MapPath("~/mdb/mydb.mdb");</span>

上面两句代码易错！！！
效果如图：

0 0