MS Access连接 [英] MS Access connection

问题描述

如何使用c＃语言将MS Access数据库表连接到asp.net？

how to connect MS Access datbase table to asp.net in c# language?

推荐答案

使用c＃

<访问的示例代码br />

sample code for access with c#

using System.Data.OleDb;
protected void btn_showst_Click()
    {
    OleDbConnection con;

    con = new OleDbConnection("Microsoft.Jet.OLEDB.4.0"      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\databasename.mdb");

   // Here Access database should be in App_Data Folder..


  con.Open();
  OleDbCommand cmd = new OleDbCommand("select * from  tablename", con);
  OleDbDataReader dr;
  dr = cmd.ExecuteReader();
  GridView1.DataSource = dr;
  GridView1.DataBind();
  con.Close();
}

来源：

Acess数据库连接C＃Asp.net

[ ^ ]



建议您至少先自己搜索一下...



谢谢

Source :
Acess Database Connection C# Asp.net
[^]

Suggestion for you atleast first search yourself...

Thanks

这篇关于MS Access连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！