-------------------------------------------------------------------------------- dim objConnection as OleDbConnection dim objCommand as OleDbCommand objConnection=new OleDbConnection(Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath(strDb)) objCommand=new OleDbCommand("這里是SQL語句" , objConnection) objConnection.Open() objDataReader=objCommand.ExecuteNoQuery()
下面再舉例子說明一下SQL語句(access): 添加記錄: insert int o 表名 (字段1,字段2) values (字符串1,字符串2) where 條件 刪除記錄: delete from 表名 where 條件 修改記錄: update 表名 set 字段1=××,字段2=×× where 條件