更新时间:2022-06-09 01:07:01
你好Joe Fasciano,
Hi Joe Fasciano,
感谢您在此发帖,
对于您的问题,这里是从Access数据库读取数据并在datagridView中显示的代码。
For your question, here is the code to read data from Access database and show in datagridView.
private void Button1_Click(object sender, EventArgs e)
{
dataGridView1.AllowUserToAddRows = false;
string strDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + textBox1.Text;
string strSQL = "SELECT * FROM Table1";
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
//myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "Table1");
DataTable dTable = dtSet.Tables[0];
dataGridView1.DataSource = dtSet.Tables["Table1"].DefaultView;
myConn.Close();
}
如果您可以在TextBox1中获取访问数据库路径和输入,则可以在datagridView中显示该表。
If you could get the access database path and input in TextBox1, you could show the table in datagridView.
***的问候,
Wendy