sqldelete.aspx

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

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

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	SqlConnection conPubs;
	string  strDelete;
	SqlCommand cmdDelete;

	conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;database=Pubs" );
	strDelete = "Delete Authors Where au_lname='Smith'";
	cmdDelete = new SqlCommand( strDelete, conPubs );
	conPubs.Open();
	cmdDelete.ExecuteNonQuery();
	conPubs.Close();
	Response.Write("Records Deleted!");
}
</script>