如何在C#连接access数据库 [英] How to connect access database in c#
本文介绍了如何在C#连接access数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有7桌在它的Access数据库文件,但我不知道如何连接并显示所有的表,如果有人能帮助我吗?
这是我的code,但它并没有显示任何东西。
私人无效的button1_Click(对象发件人,EventArgs的)
{
OleDbConnection的康恩=新的OleDbConnection();
字符串连接=供应商= Microsoft.ACE.OLEDB.12.0;数据源= | DataDirectory目录| \\ Tables.accdb;坚持安全信息=真;
字符串SQL =选择客户端表;
conn.ConnectionString =连接;
conn.Open();
的DataSet ds为新的DataSet();
DataGridView的dataGridView1的=新的DataGridView();
BindingSource的bSource =新的BindingSource();
OleDbDataAdapter的适配器=新OleDbDataAdapter的(SQL,康涅狄格州);
adapter.Fill(DS);
//conn.Close();
dataGridView1.DataSource = DS;
解决方案
试试这个code,
公共无效ConnectToAccess()
{
System.Data.OleDb.OleDbConnection康恩=新
System.Data.OleDb.OleDbConnection();
// TODO:修改连接字符串,并包括任何
//额外要求的性能为您的数据库。
conn.ConnectionString = @供应商= Microsoft.Jet.OLEDB.4.0; +
@数据源= C:\的Documents and Settings \用户名\+
@我的文档\ AccessFile.mdb;
尝试
{
conn.Open();
//将code来处理数据。
}
赶上(例外前)
{
的MessageBox.show(无法连接到数据源);
}
最后
{
conn.Close();
}
}
<一个href="http://msdn.microsoft.com/en-us/library/5ybdbtte(v=vs.71).aspx">http://msdn.microsoft.com/en-us/library/5ybdbtte(v=vs.71).aspx
I have access database file with 7 tables in it but I don't know how to connect and show all tables, If some one can help me?
this is my code but it doesn't show anything
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
String connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\Tables.accdb;Persist Security Info=True";
string sql = "SELECT Clients FROM Tables";
conn.ConnectionString = connection;
conn.Open();
DataSet ds = new DataSet();
DataGridView dataGridView1 = new DataGridView();
BindingSource bSource = new BindingSource();
OleDbDataAdapter adapter = new OleDbDataAdapter(sql,conn);
adapter.Fill(ds);
//conn.Close();
dataGridView1.DataSource = ds;
解决方案
Try this code,
public void ConnectToAccess()
{
System.Data.OleDb.OleDbConnection conn = new
System.Data.OleDb.OleDbConnection();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= C:\Documents and Settings\username\" +
@"My Documents\AccessFile.mdb";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
http://msdn.microsoft.com/en-us/library/5ybdbtte(v=vs.71).aspx
这篇关于如何在C#连接access数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文