sqldataadapter.aspx

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

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

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	DataSet dstAuthors;
	SqlConnection conPubs;
	SqlDataAdapter dadAuthors;

	dstAuthors = new DataSet();
	conPubs = new SqlConnection( @"Server=localhost;Database=Pubs;Integrated Security=SSPI" );
	dadAuthors = new SqlDataAdapter( "Select * From Authors", conPubs );
	dadAuthors.Fill( dstAuthors, "Authors" );
	Response.Write("Authors table added to DataSet!");
}
</script>