C#编程Access数据库的简单应用

对于简单的应用，不推荐使用密码。直接使用。

1.查询

2.绑定

3.添加

4.删除表中所有记录

5.删除一个表

            string reg = "drop table " + TableName;
            OleDbConnection myconnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb");
            myconnection.Open();

            OleDbCommand mycommand = myconnection.CreateCommand();
            mycommand.CommandText = reg;
            mycommand.ExecuteNonQuery();
            myconnection.Close();

6.复制一个表

            string reg = "select  *  into " + NewTableName + " from  POWER ";


            OleDbConnection myconnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb");
            myconnection.Open();

            OleDbCommand mycommand = myconnection.CreateCommand();
            mycommand.CommandText = reg;
            mycommand.ExecuteNonQuery();
            myconnection.Close();

7.获得所有表名

            OleDbConnection conn = new OleDbConnection();
            try
            {

                conn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb";
                conn.Open();
                DataTable shemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                int n = shemaTable.Rows.Count;
                string[] strTable = new string[n];
                int m = shemaTable.Columns.IndexOf("TABLE_NAME");
                for (int i = 0; i < n; i++)
                {
                    DataRow m_DataRow = shemaTable.Rows[i];
                    strTable[i] = m_DataRow.ItemArray.GetValue(m).ToString();
                }
                return strTable;
            }
            catch 
            {
                return null;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }