sqlupdaterecordsaffected.aspx

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

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

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
	SqlConnection conPubs;
	string  strUpdate;
	SqlCommand cmdUpdate;
	int intUpdateCount;

	conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;database=Pubs" );
	strUpdate = "Update Authors set  au_lname='Smith' Where au_lname='Bennet'";
	cmdUpdate = new SqlCommand( strUpdate, conPubs );
	conPubs.Open();
	intUpdateCount = cmdUpdate.ExecuteNonQuery();
	conPubs.Close();
	Response.Write(intUpdateCount.ToString());
	Response.Write(" Records Updated!");
}
</script>