[ASP.NET]在DataTable實現SQL"DISTINCT"的功能

2008-11-11

59424
0
ASP.NET

最近剛好要用到這樣的功能,去找了一下資料..
教大家如何在DataTable上使用SQL的"DISTINCT"的功能..

最近剛好要用到這樣的功能,去找了一下資料..

教大家如何在DataTable上使用SQL的"DISTINCT"的功能..

SQL"DISTINCT"的用法可以參考下列網址
http://www.1keydata.com/tw/sql/sqldistinct.html

asp.net(c#)
DatatableDistinct.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DatatableDistinct.aspx.cs" Inherits="DatatableDistinct" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>DatatableDistinct</title> </head> <body> <form id="form1" runat="server"> <div> 原始資料<asp:GridView ID="GridView1" runat="server"> </asp:GridView> <br /> DISTINCT 後的結果<asp:GridView ID="GridView2" runat="server"> </asp:GridView> </div> </form> </body> </html>

DatatableDistinct.aspx.cs

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Configuration; public partial class DatatableDistinct : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("select [name],[sales],[date] from table5", conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dtSource = new DataTable(); adapter.Fill(dtSource); DataTable dtDistinct = dtSource.DefaultView.ToTable(true, new string[] { "name" }); this.GridView1.DataSource = dtSource; this.GridView1.DataBind(); this.GridView2.DataSource = dtDistinct; this.GridView2.DataBind(); } } }

執行結果：

參考網址：
http://weblogs.asp.net/eporter/archive/2005/02/10/370548.aspx
http://www.cnblogs.com/hermes262/archive/2006/12/05/583406.html
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=181797&SiteID=1

回首頁