C#讀取access表，并把數(shù)據(jù)顯示在gridcontrol中

2019-11-17 04:04:18

字體：大中小

供稿：網(wǎng)友

//讀取標(biāo)準(zhǔn)列表
        PRivate void setModelList()
        {
            OleDbConnection Connection = null;
            string tableName = "";
            try
            {
                string strMdb = this.textBox5.Text;//mdb路徑
                Connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdb + "");
                Connection.Open();

                DataTable schemaTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                foreach (DataRow dr in schemaTable.Rows)
                {
                    //表名
                    tableName = dr["TABLE_NAME"].ToString();

                    //字段名
                    //DataTable columnTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, dr["TABLE_NAME"].ToString(), null });
                    //foreach (DataRow dr2 in columnTable.Rows)
                    //{
                    //    Console.WriteLine("{0}", dr2["COLUMN_NAME"]);
                    //}
                }
             }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            DataTable dt = new DataTable();
            string sSql = "select * from " + tableName + "";
            OleDbDataAdapter da = new OleDbDataAdapter(sSql, Connection);
            da.Fill(dt);

            this.gridControl1.DataSource = dt;

        }

上一篇：如何：在 Visual C# .NET 中建立一個(gè)平滑的進(jìn)度條（Q323116）

下一篇：java連接池淺談