Default.aspx
View Code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!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>无标题页</title> <style type="text/css"> .style1 { width: 13%; } </style> </head> <body> <form id="form1" runat="server"> <div> <table class="style1"> <tr> <td> 原始排序:</td> </tr> <tr> <td> <asp:GridView ID="gv1" runat="server" AutoGenerateColumns="False" Width="306px" CellPadding="4" ForeColor="#333333" GridLines="None" style="font-size: small"> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <Columns> <asp:BoundField DataField="id" HeaderText="编号" /> <asp:BoundField DataField="name" HeaderText="信息主题" /> <asp:BoundField DataField="userName" HeaderText="联系人" /> <asp:BoundField DataField="issueDate" HeaderText="发布日期" /> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#999999" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> </td> </tr> <tr> <td> 按信息主题排序:</td> </tr> <tr> <td> <asp:GridView ID="gv2" runat="server" AutoGenerateColumns="False" Width="306px" CellPadding="4" ForeColor="#333333" GridLines="None" style="font-size: small"> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <Columns> <asp:BoundField DataField="id" HeaderText="编号" /> <asp:BoundField DataField="name" HeaderText="信息主题" /> <asp:BoundField DataField="userName" HeaderText="联系人" /> <asp:BoundField DataField="issueDate" HeaderText="发布日期" /> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#999999" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> </td> </tr> <tr> <td> 按发布日期排序:</td> </tr> <tr> <td> <asp:GridView ID="gv3" runat="server" AutoGenerateColumns="False" Width="306px" CellPadding="4" ForeColor="#333333" GridLines="None" style="font-size: small"> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <Columns> <asp:BoundField DataField="id" HeaderText="编号" /> <asp:BoundField DataField="name" HeaderText="信息主题" /> <asp:BoundField DataField="userName" HeaderText="联系人" /> <asp:BoundField DataField="issueDate" HeaderText="发布日期" /> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#999999" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> </td> </tr> </table> </div> </form> </body> </html>
Default.aspx.cs
View Code
using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string conStr = ConfigurationSettings.AppSettings["strCon"];//获取数据库连接字符串 SqlConnection conn = new SqlConnection(conStr);//创建连接对象 if (conn.State.Equals(ConnectionState.Closed)) conn.Open();//显式地打开数据库连接 string strsql = "select top 5 id,name,userName,issueDate from tb_inf"; SqlDataAdapter da = new SqlDataAdapter(strsql, conn);//创建数据适配器 DataSet ds = new DataSet();//创建数据集 da.Fill(ds, "tb_inf");//填充数据集 gv1.DataSource = ds.Tables["tb_inf"]; DataView view2 = new DataView(ds.Tables["tb_inf"]); view2.Sort = "userName";//设置排序表达式 gv2.DataSource = view2;//将排序后的DataView视图中数据绑定到GridView控件中 DataView view3 = new DataView(ds.Tables["tb_inf"]); view3.Sort = "issueDate";//设置排序表达式 gv3.DataSource = view3;//将排序后的DataView视图中数据绑定到GridView控件中 Page.DataBind();//为整个页面中控件绑定数据 conn.Close();//关闭数据库连接 } } }