DataView.Find 和 DataView.Sort的关系

最新推荐文章于 2025-07-06 15:42:21 发布

原创最新推荐文章于 2025-07-06 15:42:21 发布 · 2.4k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #import #object #server #table #c#

本文介绍了一个使用 C# 编写的简单示例程序，该程序连接到 SQL Server 数据库并从 Authors 表中检索数据。文章展示了如何创建数据视图、进行排序及查找特定记录的方法。

<%@ 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.