//Autohor:段小勇 //Email:web718@126.com //QQ:6532053 //严禁转载 |
<%@ Page language="c#" Codebehind="DataGrid1.aspx.cs" AutoEventWireup="false" Inherits="News.DataGrid1" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>DataGrid1</title> <meta content="Microsoft Visual Studio 7.0" name="GENERATOR"> <meta content="C#" name="CODE_LANGUAGE"> <meta content="JavaScript" name="vs_defaultClientScript"> <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> </HEAD> <body MS_POSITIONING="GridLayout"> <form runat="server"> <TABLE id="Table1" cellSpacing="1" cellPadding="1" width="100%" border="0"> <TR> <td><asp:datagrid id="DataGrid2" runat="server" AllowSorting="True" AutoGenerateColumns="False" AllowPaging="True" PageSize="10" Width="100%" GridLines="Horizontal" AlternatingItemStyle-BackColor="#eeeeee"> <SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle> <AlternatingItemStyle BackColor="#EEEEEE"></AlternatingItemStyle> <HeaderStyle BackColor="#00AAAA"></HeaderStyle> <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle> <Columns> <asp:TemplateColumn HeaderText="选择"> <HeaderStyle Width="40px"></HeaderStyle> <ItemStyle HorizontalAlign="Center"></ItemStyle> <ItemTemplate> <asp:CheckBox id="checkbox" runat="server"></asp:CheckBox> </ItemTemplate> <EditItemTemplate> <asp:CheckBox id="chkExportON" runat="server"></asp:CheckBox> </EditItemTemplate> </asp:TemplateColumn> <asp:BoundColumn DataField="id" SortExpression="id" HeaderText="ID号"></asp:BoundColumn> <asp:HyperLinkColumn DataNavigateUrlField="id" DataNavigateUrlFormatString="javascript:varwin=window.open('detail.aspx?ID={0}',null,'width=300,height=200');window.Close();" DataTextField="username" HeaderText="用户名" SortExpression="username"></asp:HyperLinkColumn> <asp:BoundColumn DataField="email" HeaderText="Email" SortExpression="email"></asp:BoundColumn> <asp:TemplateColumn HeaderText="Email"> <ItemTemplate> <asp:Label id=lblColumn runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.id") %>'> </asp:Label> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle HorizontalAlign="Right" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle> </asp:datagrid></td> </TR> <tr> <td> <P><asp:panel id="Panel1" runat="server" HorizontalAlign="Right"> <asp:label id="lblPageCount" runat="server"></asp:label> <asp:label id="lblCurrentIndex" runat="server"></asp:label> <asp:LinkButton id="btnFirst" runat="server" CommandName="First">首页</asp:LinkButton> <asp:LinkButton id="btnPrevious" runat="server" CommandName="Previous">上一页</asp:LinkButton><FONT face="宋体"> <asp:LinkButton id="btnNext" runat="server" CommandName="Next">下一页</asp:LinkButton> <asp:LinkButton id="btnEnd" runat="server" CommandName="End">未页</asp:LinkButton> <asp:TextBox id="txtIndex" runat="server" Width="24px" MaxLength="2" Columns="2"></asp:TextBox> <asp:Button id="btnGo" runat="server" Text="Go!" BackColor="Gainsboro" BorderWidth="1px" BorderStyle="Solid" BorderColor="Silver"></asp:Button> <asp:Label id="lblError" runat="server" Visible="False" ForeColor="Red">No that page!</asp:Label></FONT></asp:panel></P> </td> </tr> <tr> <td> <asp:button id="cmdSelectAll" runat="server" Text="全选"></asp:button><asp:button id="cmdFindSelected" runat="server" Text="取得选择的项"></asp:button> <asp:panel id="pnlIndex" runat="server"></asp:panel> <asp:label id="Label1" runat="server"></asp:label></td> </tr> </TABLE> </form> </body> </HTML> |
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Configuration; using System.Data.SqlClient; namespace News { /// <summary> /// DataGrid1 的摘要说明。 /// </summary> public class DataGrid1 : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid DataGrid2; protected System.Web.UI.WebControls.Button Button1; protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.LinkButton btnPrevious; protected System.Web.UI.WebControls.LinkButton btnNext; protected System.Web.UI.WebControls.TextBox txtIndex; protected System.Web.UI.WebControls.Button btnGo; protected System.Web.UI.WebControls.Label lblError; protected System.Web.UI.WebControls.Panel Panel1; protected System.Web.UI.WebControls.Panel pnlIndex; protected System.Web.UI.WebControls.LinkButton btnFirst; protected System.Web.UI.WebControls.LinkButton btnEnd; protected System.Web.UI.WebControls.Label lblPageCount; protected System.Web.UI.WebControls.Label lblCurrentIndex; protected System.Web.UI.WebControls.Button cmdSelectAll; protected System.Web.UI.WebControls.Button cmdFindSelected; string ConnectionStr=ConfigurationSettings.AppSettings["connStr"]; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if(!IsPostBack) { //设置排序表达式 ViewState["SortOrder"] = "id"; //设置排序的升降序 ViewState["OrderDire"] = "ASC"; BindGrid(); } } private void BindGrid() //进行数据绑定 //显示当前分页信息 #region Web Form Designer generated code } //翻页效果 public void DataGridPage_Page(object sender, DataGridPageChangedEventArgs e) } private void cmdSelectAll_Click(object sender, System.EventArgs e) cmdSelectAll.Text = "全消"; private void cmdFindSelected_Click(object sender, System.EventArgs e) chkExport = (CheckBox)oDataGridItem.FindControl("checkbox"); private void DataGrid2_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e) } |