<%@ Import Namespace="System.Data" %><%@ Import NameSpace="System.Data.OleDb" %>
Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand sub page_load(sender as Object,e as EventArgs) '1.连接数据库 dim dbname as string dbname=server.mappath("xhnew.mdb") myConnection = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="&dbname ) myConnection.Open() la1.text="Connection Opened!"... '3 更新数据(Access) myCommand = New OleDbCommand( "UPDATE aa SET name='fff' WHERE id = 7", myConnection ) myCommand.ExecuteNonQuery() la3.text="Record Updated!" ... end sub 那个update应怎么写,我老是出错....是不是更新项要是关键字?怎么设置?我的数据库是xhnew,表是aa