oledbinsert.aspx

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

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

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

conAuthors = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\\Authors.mdb" );
strInsert = "Insert Into Authors ( au_fname, au_lname ) Values ('Bertrand', 'Russell' )";
cmdInsert = new OleDbCommand( strInsert, conAuthors );
conAuthors.Open();
cmdInsert.ExecuteNonQuery();
conAuthors.Close();
Response.Write("New Author Added!");
}
</script>