数据网格视图到c＃中的ms访问 [英] datagrid view to ms access in c#

问题描述

我需要将记录从datagridview导入到ms访问。有人能为我提供一个小型的samble项目吗？

解决方案

尝试：

  string  strConnect =  @  Provider = Microsoft.ACE.OLEDB.12.0; Data Source = d：\Temp\myAccessDatabase.accdb; 
 使用（OleDbConnection con =  new  OleDbConnection（strConnect））
 {
 con.Open（）; 
 使用（OleDbCommand cmd =  new  OleDbCommand（   SELECT * FROM MyTable，con））
 {
 OleDbDataAdapter da = 新 OleDbDataAdapter（cmd）; 
 DataTable dt =  new  DataTable（）; 
 da.Fill（dt）; 
 myDataGridView.DataSource = dt; 
} 
} 
 

试试这样，

如有任何问题发表评论。

i假设您在连接字符串中选择正确的提供商时会遇到问题..因为我不知道您使用哪个版本的Excel ...

  private   void  button1_Click（ object  sender，EventArgs e）
 {
  string  connString = 
   Provider = Microsoft.ACE.OLEDB.12.0; data source = C：\\ excelFileName.accdb; 
 
 DataTable dataTableRes =  new  DataTable（）; 
 
 使用（OleDbConnection conn =  new  OleDbConnection（connString））
 {
 OleDbCommand cmd =  new  OleDbCommand（  SELECT * FROM SheetName，conn）; 
 
 conn.Open（）; 
 
 OleDbDataAdapter adapter =  new  OleDbDataAdapter（cmd）; 
 
 adapter.Fill（dataTableRes）; 
} 
 
 dataGridView1.DataSource = dataTableRes; 
} 
 

参考 - 如何在数据网格视图中查看MS Access中的数据？ [ ^ ]和答案。

I need to import record's from datagridview to ms access. Can somebody provide me a small samble project?

解决方案

Try:

string strConnect = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Temp\myAccessDatabase.accdb";
using (OleDbConnection con = new OleDbConnection(strConnect))
    {
    con.Open();
    using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM MyTable", con))
        {
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        myDataGridView.DataSource = dt;
        }
    }

try like this,
if any issues post a comment.
i assume you will get issue on the choosing the correct provider in connection string..as i don't know which version of excel u r using...

private void button1_Click(object sender, EventArgs e)
       {
           string connString =
               "Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\\excelFileName.accdb";

           DataTable dataTableRes = new DataTable();

           using (OleDbConnection conn = new OleDbConnection(connString))
           {
               OleDbCommand cmd = new OleDbCommand("SELECT * FROM SheetName", conn);

               conn.Open();

               OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);

               adapter.Fill(dataTableRes);
           }

           dataGridView1.DataSource = dataTableRes;
       }

Refer - How to View Data from MS Access in Data Grid View?[^] and the answers.

这篇关于数据网格视图到c＃中的ms访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！