典型代码-.net连接access(网站)

来源：互联网发布：网络挣钱路子编辑：程序博客网时间：2024/05/24 06:38

建立空网站

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

        //数据库连接，记录集的获取
        //注意更改路径
        String sqlconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\\DataBase\\xxx.mdb;";
        OleDbConnection myConnection = new OleDbConnection(sqlconn);
        myConnection.Open();
        OleDbCommand myCommand = new OleDbCommand("select * from info", myConnection);
        OleDbDataReader myReader;
        myReader = myCommand.ExecuteReader();

        //读取记录集
        Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
        Response.Write("<tr bgcolor=#DAB4B4>");
        for (int i = 0; i < myReader.FieldCount; i++)
            Response.Write("<td>" + myReader.GetName(i) + "</td>");
        Response.Write("</tr>");

        while (myReader.Read())
        {
            Response.Write("<tr>");
            for (int i = 0; i < myReader.FieldCount; i++)
                Response.Write("<td>" + myReader[i].ToString() + "</td>");
            Response.Write("</tr>");
        }
        Response.Write("</table>");

        //关闭记录集和连接
        myReader.Close();
        myConnection.Close();

}
}

执行效果

idnonameage112345了哈12223456lha24334567和和和36

0 0