oledbdelete.aspx

来自「asp.net技术内幕的书配源码」· ASPX 代码 · 共 20 行

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

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

conAuthors = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\\Authors.mdb" );
strDelete = "Delete From Authors Where au_lname='Frege'";
cmdDelete = new OleDbCommand( strDelete, conAuthors );
conAuthors.Open();
cmdDelete.ExecuteNonQuery();
conAuthors.Close();
Response.Write("Records Deleted!");
}

</script>