c操作Access数据库的方法大全.doc

c#操作Access数据库的方法大全 using System.Data.OleDb;using System.Data;连接字符串：String connectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=product.mdb;建立连接：OleDbConnection connection = new OleDbConnection(connectionString);使用OleDbCommand类来执行Sql语句：OleDbCommand cmd = new OleDbCommand(sql, connection);connection.Open();cmd.ExecuteNonQuery(); 1.创建mdb库，例程如下：需要注意的是：参数mdbPath是mdb的完整路径（不包含表的名称）。例如：D:\\test.mdb ??????? //创建mdb ??????? public static bool CreateMDBDataBase(string mdbPath) ??????? { ??????????? try ??????????? { ??????????????? ADOX.CatalogClass cat = new ADOX.CatalogClass(); ??????????????? cat.Create(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + mdbPath + ;); ??????????????? cat = null; ??????????????? return true; ??????????? } ??????????? catch { return false; } ??????? }2.创建具体的表，例程如下：通常一个mdb的可以包含n个表。下面的程序主要是创建一个table。 ??????? //新建mdb的表 ??????? //mdbHead是一个ArrayList，存储的是table表中的具体列名。 ??????? public static bool CreateMDBTable(string mdbPath,string tableName, ArrayList mdbHead) ??????? { ??????????? try ??????????? { ??????????????? ADOX.CatalogClass cat = new ADOX.CatalogClass(); ??????????????? string sAccessConnection = @Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + mdbPath; ??????????????? ADODB.Connection cn = new ADODB.Connection(); ??????????????? cn.Open(sAccessConnection, null, null, -1); ??????????????? cat.ActiveConnection = cn; ??????????????? //新建一个表 ??????????????? ADOX.TableClass tbl = new ADOX.TableClass(); ??????????????? tbl.ParentCatalog = cat; ??????????????? tbl.Name = tableName; ??????????????? int size = mdbHead.Count; ??????????????? for (int i = 0; i size; i++) ??????????????? { ??????????????????? //增加一个文本字段 ??????????????????? ADOX.ColumnClass col2 = new ADOX.ColumnClass(); ??????????????????? col2.ParentCatalog = cat; ??????????????????? col2.Name = mdbHead[i].ToString();//列的名称 ??????????????????? col2.Properties[Jet OLEDB:Allow Zero Length].Value = false; ??????????????????? tbl.Colu