sqldeleterecordsaffected.aspx

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

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

<script runat=server>

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

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