MS Access连接

MS Access连接

问题描述:

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

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

使用c#


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