對(duì)于簡(jiǎn)單的應(yīng)用，不推薦使用密碼。直接使用。

1.查詢

2.綁定

綁定代碼

3.添加

添加一條記錄

4.刪除表中所有記錄

刪除一個(gè)數(shù)據(jù)表中所有記錄

5.刪除一個(gè)表

刪除一個(gè)表 1 string reg = "drop table " + TableName; 2 OleDbConnection myconnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb"); 3 myconnection.Open(); 4 5 OleDbCommand mycommand = myconnection.CreateCommand(); 6 mycommand.CommandText = reg; 7 mycommand.ExecuteNonQuery(); 8 myconnection.Close();

6.復(fù)制一個(gè)表

復(fù)制一個(gè)表 1 string reg = "select * into " + NewTableName + " from POWER "; 2 3 4 OleDbConnection myconnection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb"); 5 myconnection.Open(); 6 7 OleDbCommand mycommand = myconnection.CreateCommand(); 8 mycommand.CommandText = reg; 9 mycommand.ExecuteNonQuery(); 10 myconnection.Close();

7.獲得所有表名

獲得所有表名 1 OleDbConnection conn = new OleDbConnection(); 2 try 3 { 4 5 conn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =AxisPower.mdb"; 6 conn.Open(); 7 DataTable shemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); 8 int n = shemaTable.Rows.Count; 9 string[] strTable = new string[n]; 10 int m = shemaTable.Columns.IndexOf("TABLE_NAME"); 11 for (int i = 0; i < n; i++) 12 { 13 DataRow m_DataRow = shemaTable.Rows[i]; 14 strTable[i] = m_DataRow.ItemArray.GetValue(m).ToString(); 15 } 16 return strTable; 17 } 18 catch 19 { 20 return null; 21 } 22 finally 23 { 24 conn.Close(); 25 conn.Dispose(); 26 }

?

轉(zhuǎn)載于:https://www.cnblogs.com/shumaojie/archive/2013/04/16/3024127.html

總結(jié)

以上是生活随笔為你收集整理的C#编程-Access数据库的简单应用的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。