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