如何在数据网格视图中从MS Access查看数据
本文关键字:数据 MS Access 视图 数据网 网格 | 更新日期: 2023-09-27 18:08:19
我是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;
参考代码:
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;
试试这个
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 BlockFinally Block