針對access數據庫的增刪改查

1、執行查詢操作：（ExecuteReader方法）

string myConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "+Server.MapPath("~/") +"App_Data/access.mdb"; //使用相對路徑連接數據庫

string mySelectQuery = "select * from login where userName ='lwjj'";//查詢語句

OleDbConnection myConnection = new OleDbConnection(myConnectionString);

OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

myConnection.Open();

OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

?? while(myReader.Read())
?? {
????? Console.WriteLine(myReader.GetString(0));
????? //GetString(0,1,2....)
?? }
?? myReader.Close();

?

2、執行增、刪、改操作：（ExecuteNonQuery方法）

private void dbcz()
??? {
??????? string myConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "+Server.MapPath("~/") +"App_Data/IPTJ.mdb";? //Data Source = 數據庫絕對路徑

string myExecuteQuery = "insert into accIP (IP,地址) values ('" + 參數1+ "','" + 參數2+ "')";//增、刪、改等語句

OleDbConnection myConnection = new OleDbConnection(myConnectionString);

OleDbCommand myCommand = new OleDbCommand(myExecuteQuery,myConnection);

myCommand.Connection.Open();

myCommand.ExecuteNonQuery();//返回影響的行數

myConnection.Close();

}