C#读取access表，并把数据显示在gridcontrol中

2019-11-17 04:04:18

字体：大中小

来源：转载

供稿：网友

//读取标准列表
        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 中建立一个平滑的进度条（Q323116）

下一篇：java连接池浅谈