Access和Excel做数据源

可以直接将创建的Access或者是Excel数据源文件直接放到项目中去，就是将数据源文件直接复制粘贴到

App_Data文件夹下面的，这里的复制不是直接将文件拖进来，而是复制文件将数据文件复制到目录下面去

，然后点击解决方案上面有个显示所有文件的按钮，然后将数据文件包含在项目中就行了!

Access作为数据源
//引入命名空间
using System.Data.OleDb;

namespace WebApplication
{
    public class AccessHelper
    {
        static readonly string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=F:\\试验\\Access\\WebAccess\\WebApplication\\App_Data\\Database.accdb;Persist

Security Info=False";

        public OleDbConnection OledCon()
        {
            OleDbConnection con = new OleDbConnection(strConnection);
            con.Open();
            return con;
        }

        public DataSet GetData(string strAccess)
        {
            OleDbConnection odc = OledCon();
            using (odc)
            {
                OleDbDataAdapter odda = new OleDbDataAdapter(strAccess, odc);
                DataSet ds = new DataSet();
                odda.Fill(ds);
                return ds;
            }
        }
    }
}

页面后台
public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Get();
            }
        }

AccessHelper Ah = new AccessHelper();

        protected void Get()
        {
            string strsql = "select * from 个人信息表";
            DataSet ds = Ah.GetData(strsql);
            DLOne.DataSource = ds;
            DLOne.DataBind();
        }
    }

页面前台
<form id="form1" runat="server">
    <div>
        <asp:DataList ID="DLOne" runat="server">
            <ItemTemplate>
                <%# Eval("myname") %>
            </ItemTemplate>
        </asp:DataList>
    </div>
    </form>

Excel作为数据源
//引入命名空间
using System.Data.OleDb;

namespace WebApplication
{
    public partial class Excel
    {
        public DataSet GetDataFromExcel_(string strsql)
        {
            OleDbConnection connection = new OleDbConnection

("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\试验\\Access\\WebAccess\\WebApplication\

\App_Data\\Info.xls;Extended Properties=Excel 8.0");
            OleDbDataAdapter dataadapter = new OleDbDataAdapter(strsql,connection);
            DataSet dataset = new DataSet();
            dataadapter.Fill(dataset);
            return dataset;
        }
    }
}

页面后台
public partial class ExcelHelper : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GetDatal();
            }
        }

Excel E = new Excel();

        protected void GetDatal()
        {
            DataSet ds= E.GetDataFromExcel_("select * from [info$]");
            gridview.DataSource = ds;
            gridview.DataBind();
        }
    }
页面前台
<form id="form1" runat="server">
    <div>
        <asp:GridView ID="gridview" runat="server">
        </asp:GridView>
    </div>
    </form>