finddataview.aspx

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

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

<%
DataSet dstAuthors;
SqlConnection conPubs;
SqlDataAdapter dadAuthors;
DataView dvwAuthors;
Object[] arrValues = new Object[2];
 
// Grab Authors Table
dstAuthors = new DataSet();
conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
dadAuthors = new SqlDataAdapter( "Select * From Authors", conPubs );
dadAuthors.Fill( dstAuthors, "Authors" );

// Create DataView
dvwAuthors = dstAuthors.Tables[ "Authors" ].DefaultView;
dvwAuthors.Sort = "au_lname, au_fname";

// Find Ann Dull
arrValues[0] = "Dull";
arrValues[1] = "Ann";
int intRowIndex = System.Convert.ToInt32(dvwAuthors.Find (arrValues) );


// Display Phone Number
if ( intRowIndex != -1 ) 
{
  Response.Write( dvwAuthors[ intRowIndex ]["Phone"]);
} 
else
{
  Response.Write( "Can't find Ann Dull :)" );
}
%>