<%@ 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=IPROMISE;database=Pubs;uid=sa;password=;");
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 :)" );
}
%>
Find finds a row based on a Sort order, and no Sort order is specified.