oledbupdate.aspx

asp.net技术内幕的书配源码

<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
OleDbConnection conAuthors;
 string  strUpdate;
 OleDbCommand cmdUpdate;

conAuthors = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\\Authors.mdb" );
strUpdate = "Update Authors set au_lname='Frege' Where au_lname='Russell'";
cmdUpdate = new OleDbCommand( strUpdate, conAuthors );
conAuthors.Open();
cmdUpdate.ExecuteNonQuery();
conAuthors.Close();
Response.Write("Author Updated!");
}
</script>