显示结果
CustomerID
CompanyName
Country
WHITC
White Clover Markets
USA
TRAIH
Trail's Head Gourmet Provisioners
USA
THECR
The Cracker Box
USA
THEBI
The Big Cheese
USA
SPLIR
Split Rail Beer & Ale
USA
SAVEA
Save-a-lot Markets
USA
RATTC
Rattlesnake Canyon Grocery
USA
OLDWO
Old World Delicatessen
USA
LONEP
Lonesome Pine Restaurant
USA
LETSS
Let's Stop N Shop
USA
LAZYK
Lazy K Kountry Store
USA
HUNGC
Hungry Coyote Import Store
USA
GREAL
Great Lakes Food Market
USA
源代码
<% @Import Namespace="System.Data" %> <% @Import Namespace="System.Data.SqlClient" %> <HTML> <HEAD> <title>使用DataTable进行检索和排序示例</title> <script language="C#" runat="server"> void Page_Load(object sender, System.EventArgs e) 
{ 
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"]; string Sql = "SELECT CustomerID, CompanyName, Country FROM Customers"; SqlConnection thisConnection = new SqlConnection(ConnectionString); SqlDataAdapter adapter = new SqlDataAdapter(Sql, thisConnection); // 创建DataTable对象 DataTable table = new DataTable(); // 填充数据到DataTable adapter.Fill(table); // 定义筛选条件字符串和排序字符串 string strExpr = "Country = 'USA'"; string strSort = "CompanyName DESC"; // 获得经过筛选和排序后的数据 DataRow [] resultRows = table.Select(strExpr, strSort); // 显示经过筛选和排序后的数据 DisplayRows(resultRows, DisplayLabel); 
} // 显示DataRow数组中的内容 public void DisplayRows(DataRow [] rows, Label label) { // 检查返回数据是否为空 if(rows.Length <= 0) 
{ label.Text = "没有数据"; return; 
} label.Text = ""; // 遍历DataRow数组的行和列，显示数据 label.Text += "<Table border='1'>"; label.Text += "<TR><TH>CustomerID</TH><TH>CompanyName</TH><TH>Country</TH></TR>"; foreach(DataRow row in rows) { label.Text += "<TR>"; for(int i=0; i<row.Table.Columns.Count; i++) { label.Text += "<TD>"; label.Text += row[i]; label.Text += "</TD>"; } label.Text += "</TR>"; } label.Text += "</Table>"; } </script> </HEAD> <body> <form id="Form1" method="post" runat="server"> <H3>使用DataTable进行检索和排序示例</H3> <asp:Label id="DisplayLabel" runat="server">Label</asp:Label> </form> </body> </HTML> 
【责编:Peng】
相关文章编辑推荐
相关产品和培训
文章评论
认证培训 专题推荐
今日更新 社区讨论 博客论点 频道精选
您现在的位置： 
佚名
2007-4-29
