userlist.aspx.cs

用Excel文件做数据库进行数据的读写,实现数据集的读取

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.OleDb;

//*********************Write by PudnPh

public partial class UserList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;

        string Path = Server.MapPath("App_Data") + "\\FreeDB.xls";
        string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + Path + "';Extended Properties=Excel 8.0;";
        OleDbConnection conn = new OleDbConnection(ConnStr);
        conn.Open();
        string SelectText = "select * from [Sheet1$]";
        OleDbDataAdapter da = new OleDbDataAdapter(SelectText, conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();

        DataList1.DataSource = ds;
        DataList1.DataBind();
    }
}