如何在数据网格视图中查看MS Access中的数据？

Question

我是C-Sharp的新手，我试图从C-Sharp访问我的数据库，我写了下面的代码，我不知道在查看数据旁边写什么。我在网上搜索过，但没有太多。请用简单的代码告诉我。

string connection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb"; 

OleDbConnection conn = new OleDbConnection(connection); 
conn.Open(); 
OleDbCommand cmd = new OleDbCommand("Select * from score", conn); 

OleDbDataAdapter da = new OleDbDataAdapter(cmd); 
da.SelectCommand = cmd; 

Answer 1

请参阅下面的代码：

string strProvider = "@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb"; 
string strSql = "Select * from score"; 
OleDbConnection con = new OleDbConnection(strProvider); 
OleDbCommand cmd = new OleDbCommand(strSql, con); 
con.Open(); 
cmd.CommandType = CommandType.Text; 
OleDbDataAdapter da = new OleDbDataAdapter(cmd); 
DataTable scores = new DataTable(); 
da.Fill(scores); 
dataGridView1.DataSource = scores; 

希望它有帮助。

Answer 2

试试这个

 try 
     { 

     Dataset myDataSet=new Dataset(); 

     string connection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb"; 
     OleDbCommand cmd = new OleDbCommand("Select * from score", conn); 
     OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd); 

     connection .Open(); 
     myDataAdapter.Fill(myDataSet,"TableName"); 

     } 
     catch (Exception ex) 
     { 
       Console.WriteLine("Error: Failed to retrieve the required data from the DataBase.\n{0}", ex.Message); 
       return; 
     } 
     finally 
     { 
       connection .Close(); 
     } 

记住良好的编码习惯，总是连接应该是开放的try块 和关闭finally块