typeddataset.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) 
{
	SqlConnection conPubs;
	SqlDataAdapter dadTitles;
	TitlesDS objTitlesDS;
	   

	// Fill the typed dataset
	conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
	dadTitles = new SqlDataAdapter( "Select * From Titles", conPubs );
	objTitlesDS = new TitlesDS();
	dadTitles.Fill( objTitlesDS, "Titles" );


	// Display its titles
	foreach (TitlesDS.TitlesRow objTitleRow in objTitlesDS.Titles)
	{
		Response.Write("<br>" + objTitleRow.title );

		if (!objTitleRow.IsnotesNull() )
		Response.Write( "<br>" + objTitleRow.notes );

		Response.Write( "<hr>" );
	} 
}

</Script>