且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

数据库连接字符串

更新时间: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