gridview用法总结无代码分页排序

GridView 使用方法总结1.GridView无代码分页排序：1.AllowSorting设为True，aspx代码中是AllowSorting="True"；2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。

3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

2.GridView选中，编辑，取消，删除：后台代码：你可以使用sqlhelper,本文没用。

代码如下：代码using System;using System.Data;using System.Configuration;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;public partial class _Default : System.Web.UI.Page{//清清月儿/21aspnetSqlConnection sqlcon;SqlCommand sqlcom;string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){bind();}}protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e){GridView1.EditIndex = e.NewEditIndex;bind();}//删除protected void GridView1_RowDeleting(object sender, GridViewDeleteEventA rgs e){string sqlstr = "delete from 表 where id='" + GridView1.DataKeys[e.Ro wIndex].Value.ToString() + "'";sqlcon = new SqlConnection(strCon);sqlcom = new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();bind();}//更新protected void GridView1_RowUpdating(object sender, GridViewUpdateEventA rgs e){sqlcon = new SqlConnection(strCon);string sqlstr = "update 表 set 字段1='"+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).T ext.ToString().Trim() + "',字段2='"+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).T ext.ToString().Trim() + "',字段3='"+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).T ext.ToString().Trim() + "' where id='"+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";sqlcom=new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();GridView1.EditIndex = -1;bind();}//取消protected void GridView1_RowCancelingEdit(object sender, GridViewCancelE ditEventArgs e){GridView1.EditIndex = -1;bind();}//绑定public void bind(){string sqlstr = "select * from 表";sqlcon = new SqlConnection(strCon);SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();sqlcon.Open();myda.Fill(myds, "表");GridView1.DataSource = myds;GridView1.DataKeyNames = new string[] { "id" };//主键GridView1.DataBind();sqlcon.Close();}}前台主要代码代码前台主要代码：... ...<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Cell Padding="4"ForeColor="#333333" GridLines="None" OnRowDeleting=" GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"OnRowUpdating="GridView1_RowUpdating" OnRowCanceling Edit="GridView1_RowCancelingEdit"><FooterStyle BackColor="#990000" Font-Bold="True" Fo reColor="White"/><Columns><asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True"/><asp:BoundField DataField="姓名" HeaderText="用户姓名"/><asp:BoundField DataField="员工性别" HeaderText="性别"/><asp:BoundField DataField="家庭住址" HeaderText="家庭住址"/><asp:CommandField HeaderText="选择" ShowSelectButton="True"/><asp:CommandField HeaderText="编辑" ShowEditButton="True"/><asp:CommandField HeaderText="删除" ShowDeleteButton="True"/></Columns><RowStyle ForeColor="#000066"/><SelectedRowStyle BackColor="#669999" Font-Bold="Tru e" ForeColor="White"/><PagerStyle BackColor="White" ForeColor="#000066" Ho rizontalAlign="Left"/><HeaderStyle BackColor="#006699" Font-Bold="True" Fo reColor="White"/></asp:GridView>3.GridView正反双向排序：效果图：点姓名各2次的排序，点其他也一样可以。

GridView无代码分页排序GridView选中，编辑，取消，删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“...”代替超长字符串GridView一般换行与强制换行GridView显示隐藏某一列GridView弹出新页面/弹出新窗口GridView固定表头(不用javascript只用CSS，2行代码，很好用) GridView合并表头多重表头无错完美版（以合并3列3行举例）GridView突出显示某一单元格（例如金额低于多少，分数不及格等）GridView加入自动求和求平均值小计GridView数据导入Excel/Excel数据读入GridView在对GridView编辑的时候实现自动计算实现类似winform的点击行选中功能GridView在编辑的时候控制编辑框的列宽。

给Gridview加入Tooltip的功能1.GridView无代码分页排序：1.AllowSorting设为True，aspx代码中是AllowSorting="True"；2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。

3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

2.GridView选中，编辑，取消，删除：效果图：后台代码：你可以使用sqlhelper,本文没用。

代码如下：using System;using System.Data;using System.Configuration;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;public partial class _Default : System.Web.UI.Page{//清清月儿/21aspnetSqlConnection sqlcon;SqlCommand sqlcom;string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){bind();}}protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {GridView1.EditIndex = e.NewEditIndex;bind();}//删除protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {string sqlstr = "delete from 表where id='" +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";sqlcon = new SqlConnection(strCon);sqlcom = new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();bind();}//更新protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {sqlcon = new SqlConnection(strCon);string sqlstr = "update 表set 字段1='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='"+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";sqlcom=new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();GridView1.EditIndex = -1;bind();}//取消protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){GridView1.EditIndex = -1;bind();}//绑定public void bind(){string sqlstr = "select * from 表";sqlcon = new SqlConnection(strCon);SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();sqlcon.Open();myda.Fill(myds, "表");GridView1.DataSource = myds;GridView1.DataKeyNames = new string[] { "id" };//主键GridView1.DataBind();sqlcon.Close();}}前台主要代码：... ...<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"ForeColor="#333333" GridLines="None"OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit"><FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /><Columns><asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" /><asp:BoundField DataField="姓名" HeaderText="用户姓名" /><asp:BoundField DataField="员工性别" HeaderText="性别" /><asp:BoundField DataField="家庭住址" HeaderText="家庭住址" /><asp:CommandField HeaderText="选择" ShowSelectButton="True" /><asp:CommandField HeaderText="编辑" ShowEditButton="True" /><asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> </Columns><RowStyle ForeColor="#000066" /><SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" /><PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" /><HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /></asp:GridView>3.GridView正反双向排序：（用到数据库视图DATAVIEW及GRIDVIEW的VIEWSTAT 类）效果图：点姓名各2次的排序，点其他也一样可以。

今天发现，原来gridview的自动分页和手动分页有很大的区别。

但共同的都要进行以下两步操作：1、设置AllowSorting属性：true;2、指定SortExpression字段值（指定对哪些字段进行排序操作）3、“绑定数据源后再取消”与“直接写BoundFieldDataField="Account(绑定的某个字段名)"”后具体的动态设置不同。

（1）“绑定数据源后再取消”由于绑定数据源的时候已经将SortExpression字段进行了绑定，此时只要在page_load()和GridView1_Sorting()中添加事件即可。

protectedvoid Page_Load(object sender,EventArgs e){ if(!IsPostBack){this. GridView1.Attributes.Add("SortExpression","value");//定义gridview排序的字段值this. GridView1.Attributes.Add("SortDirection","ASC");//预设gridview为正向排序This.BindData();//绑定数据(已经定义的一个函数)}}protectedvoid GridView1_Sorting(object sender,GridViewSortEventArgs e){string strDirect = (e.SortDirection ==SortDirection.Ascending) ?"ASC":"DESC";if((e.SortExpression ==this.GridView1.Attributes["SortExpression"].ToString()) && (strDirect==this.GridView1.Attributes["SortDirection"].ToString())){strDirect = (strDirect =="ASC") ?"DESC":"ASC";//交换排序方向}this. GridView1.Attributes["SortExpression"] = e.SortExpression;this. GridView1.Attributes["SortDirection"] = strDirect;ds =getAllReportInforDal.GetAllReportInfor();//获得gridview的数据集DataView dv =new DataView();dv.Table =ds.Tables[0];rows = dv.Table.Rows.Count;dv.Sort =string.Format("{0} {1}", e.SortExpression, strDirect);//将数值字段的排序返回this. GridView1.DataSource = dv;//重新绑定this. GridView1.DataBind();this.GridView1.BottomPagerRow.Visible =true;}（2）直接写BoundField DataField="Account(绑定的某个字段名)"，由于SortExpression字段没有自动绑定，此时，在页面加载时候需要具体定义排序字段protectedvoid Page_Load(object sender,EventArgs e){if(!IsPostBack){this.GridView1.Attributes.Add("SortExpression","Account");this.GridView1.Attributes.Add("SortExpression","create_date");this.GridView1.Attributes.Add("SortDirection","ASC");this.BindData();}}protectedvoid GridView1_Sorting(object sender,GridViewSortEventArgs e)//实现排序{//从事件参数获取排序数据列string sortExpression = e.SortExpression.ToString();//假定为排序方向为“顺序”string sortDirection ="ASC";// “ASC”与事件参数获取到的排序方向进行比较，进行GridView排序方向参数的修改if(sortExpression ==this. GridView1.Attributes["SortExpression"]){//获得下一次的排序状态sortDirection = (this. GridView1.Attributes["SortDirection"].ToString() ==sortDirection ?"DESC":"ASC");}//重新设定GridView排序数据列及排序方向this. GridView1.Attributes["SortExpression"] = sortExpression;this. GridView1.Attributes["SortDirection"] = sortDirection;this.BindGridView();//再次绑定}privatevoid BindGridView()//绑定到GridView{//获取GridView排序数据列及排序方向string sortExpression =this. GridView1.Attributes["SortExpression"];string sortDirection =this. GridView1.Attributes["SortDirection"];//调用数据访问层获取方法string reportId = Request.QueryString["reportID"].ToString().Trim();DataSet ds = dal.GetUserByReportId(reportId);rows = ds.Tables[0].Rows.Count;DataTable dtBind =ds.Tables[0];//根据GridView排序数据列及排序方向设置显示的默认数据视图if((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection))) {dtBind.DefaultView.Sort =string.Format("{0} {1}", sortExpression, sortDirection);}// GridView绑定并显示数据this. GridView1.DataSource = dtBind;this. GridView1.DataBind();}GridView自带了数据排序功能。

ASPxGridView属性：概述设置（Settings）<SettingsGridLines="Vertical" : 网格样式 Vertical, Both, NoneShowGroupPanel="True" : 分组面板ShowFooter="True" : 脚注面板ShowFilterRow="True" : 过滤器行ShowHeaderFilterButton="true" : 表头过滤按钮ShowFilterBar :允许显示过滤工具条ShowGroupFooter="VisibleAlways" : 分组脚注面板 Hidden | VisibleIfExpand | Vis ibleAlwaysShowPreview="true" : 预览面板ShowVerticalScrollBar="True" : 垂直滚动条VerticalScrollableHeight="250" : 垂直滚动条/>行为设置（SettingsBehavior）<SettingsBehaviorAllowDragDrop="False" : 允许托拽ColumnResizeMode="Control" : 列宽度调整模式AllowFocusedRow="True" : 鼠标点击选择行AllowSort :允许排序AllowGroup :允许分组autoExpandAllGroups ：自动展开所有组ConfirmDelete ：允许提交删除AllowMultiSelection ：允许选择多行/>分页（SettingsPager）<SettingsPagerPageSize="30" : 分页大小Mode="ShowAllRecords" : 展示模式SEOFriendly="Enabled" : Search engine friendlyPosition="TopAndBottom" : 分页控件位置><Summary AllPagesText="页: {0} / {1} ({2}行)" /></SettingsPager>文本设置（SettingsText）<SettingsTextTitle="标题"EmptyDataRow="无数据"PopupEditFormCaption="编辑"ConfirmDelete="确定删除？"/>Loading 面板设置（SettingsLoadingPanel）<SettingsLoadingPanel Mode="ShowOnStatusBar" />编辑视图设置（SettingsEditing）<SettingsEditingPopupEditFormWidth = "600px"NewItemRowPosition = "Bottom"Mode = "PopupEditForm"/>编辑模式 SettingsEditing.ModeEditForm : 当前行转化为表单，嵌入在行中EditFormAndDisplayRow : 同EditForm，但保留当前行Inline : 在当前行现场编辑PopupEditForm : 弹出窗口编辑行详细设置（SettingDetail）<SettingDetailAllowOnlyOneMasterRowExpanded :允许只展开一列详细信息ShowDetailRow ：允许显示详细列表IsDetailGrid ：允许显示分组>动态选中某一行：AspxgridView1.Selection.SetSelection(i.true)遍历所有行：声明变量：DataRowView dvFor(int i=0;i< AspxgridView1.VisbleRowCount;i++){选中行提取数据：if(AspxgridView1.Selection.IsRowSelected(i)){行数据集 dv=（DataRowView）AspxgridView1.GetRow(i);}}ASPxGridView样式& 格式---------------------------------------------------------集中式样式<Styles><Header HorizontalAlign="Center" /> : 标题居中对齐<AlternatingRow Enabled="true"/> : 交错行效果<CommandColumn Paddings-Padding="1" /> :</Styles>列样式<dxwgv:GridViewDataTextColumn FieldName="Total" UnboundType="Decimal"> <FooterCellStyle ForeColor="Brown"/></dxwgv:GridViewDataTextColumn>数字日期格式金额<dxwgv:GridViewDataTextColumn FieldName="UnitPrice" ><PropertiesTextEdit DisplayFormatString="c" /></dxwgv:GridViewDataTextColumn>时间<dxwgv:GridViewDataDateColumn Caption="Time" FieldName="Time"> <PropertiesDateEdit DisplayFormatString="HH:mm:ss" /><CellStyle HorizontalAlign="Right" /></dxwgv:GridViewDataDateColumn>图像<Images ImageFolder="~/App_Themes/Glass/{0}/"><CollapsedButton Height="12px" Width="11px" /><DetailCollapsedButton Height="9px" Width="9px" /><PopupEditFormWindowClose Height="17px" Width="17px" /></Images>ASPxGridView分组& 汇总& 排序---------------------------------------------------------间隔分组：将时间日期字段按个性分组，如年、月、日、周、季度、上周、下周.....<dxwgv:GridViewDataDateColumn FieldName="OrderDate" VisibleIndex="3" GroupInd ex="0"><Settings GroupInterval="DateYear"/></dxwgv:GridViewDataDateColumn>汇总<TotalSummary><dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/> <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/><dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" /><dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" /><dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" /> </TotalSummary>分组汇总<GroupSummary><dxwgv:ASPxSummaryItem FieldName="Country" SummaryType="Count" /><dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Sum" /><dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFor mat="{0:c}"/></GroupSummary>ASPxGridView 列：---------------------------------------------------------基本列(GridViewDataColumn)<dxwgv:GridViewDataColumn FieldName="Country" VisibleIndex="5" />其他列<dx:GridViewDataTextColumn /> : 文本列<dx:GridViewDataMemoColumn /> : 长文本列<dx:GridViewDataImageColumn /> : 图像列<dx:GridViewDataBinaryImageColumn /> : 二进制图像列<dx:GridViewDataDateColumn /> : 日期列<dx:GridViewDataTimeEditColumn /> : 时间列<dx:GridViewDataComboBoxColumn /> : 组合框列<dx:GridViewDataDropDownEditColumn /> : 下拉框编辑列？<dx:GridViewCommandColumn /> : 命令按钮列<dx:GridViewDataButtonEditColumn /> : 编辑按钮列？<dx:GridViewDataCheckColumn /> : 复选框列<dx:GridViewDataColorEditColumn /> : 色彩列<dx:GridViewDataHyperLinkColumn /> : 超链接列<dx:GridViewDataProgressBarColumn /> : 进度条列<dx:GridViewDataSpinEditColumn /> : SpinEdit列长文本列（GridViewDataMemoColumn）编辑时展现为多行文本框<dx:GridViewDataMemoColumn FieldName="Remarks" Caption="备注"EditCellStyle-BackColor="Yellow" // 行的背景颜色PropertiesMemoEdit-Rows="4" // 添加或是修改时跨行EditFormSettings-ColumnSpan="2" //添加或是修改时跨列/>超链接列(GridViewDataHyperLinkColumn)<dx:GridViewDataHyperLinkColumn FieldName="ArticleId" Caption="查看" > <PropertiesHyperLinkEdit Text="查看" TextFormatString="" /> </dx:GridViewDataHyperLinkColumn>组合框列（GridViewDataComboBoxColumn）<dx:ASPxGridView OnCellEditorInitialize="grid_CellEditorInitialize"><dxwgv:GridViewDataComboBoxColumn FieldName="City" VisibleIndex="2"> <PropertiesComboBox EnableSynchronization="False" EnableIncrementalFiltering ="True" DropDownStyle="DropDown" /></dxwgv:GridViewDataComboBoxColumn></dx:ASPxGridView>protected void grid_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e){// 用下拉框展示国家下的所有城市绑定数据源if(grid.IsEditing && e.Column.FieldName != "City" && !grid.IsNewRowEditing){ASPxComboBox combo = e.Editor as ASPxComboBox;string country = (string)grid.GetRowValuesByKeyValue(e.KeyValue, "Country");FillCityCombo(combo, country);}}命令按钮列（GridViewCommandColumn）<dx:ASPxGridView runat="server" KeyFieldName="ID"OnRowDeleting="gv_RowDeleting" OnRowUpdating="gv_RowUpdating" OnRowIn serting="gv_RowInserting"<Columns>一种是添加图片的<dx:GridViewCommandColumn VisibleIndex="0" ButtonType="Image" Caption=操作"><EditButton Visible="True"><Image ToolTip="修改" Url="Images/edit.png" /></EditButton><NewButton Visible="True"><Image ToolTip="新建" Url="Images/new.png" /></NewButton><DeleteButton Visible="true"><Image ToolTip="删除" Url="Images/del.png" /></DeleteButton><CancelButton Visible="True"><Image ToolTip="关闭" Url="Images/cancel.png" /></CancelButton><UpdateButton Visible="True"><Image ToolTip="保存" Url="Images/update.png" /></UpdateButton><ClearFilterButton Visible="true"><Image ToolTip="清空" Url="Images/del2.png" /></ClearFilterButton><HeaderStyle HorizontalAlign="Center" /></dx:GridViewCommandColumn>一种就只这种标准的：<dxwgv:GridViewCommandColumn><EditButton Visible="True" Text="修改" /><DeleteButton Visible="true" Text="删除" /><NewButton Visible="True" Text="新建" /><CancelButton Visible="true" Text="取消" /><UpdateButton Visible="true" Text="保存" /><ClearFilterButton Visible="true" Text="取消过滤" /></dxwgv:GridViewCommandColumn></Columns></dx:ASPxGridView>代码详见《ASPxGridView.DataBind》复选框列<dxwgv:GridViewCommandColumn ShowSelectCheckbox="True"/><dxwgv:GridViewCommandColumn ShowSelectCheckbox="True"><HeaderTemplate><input type="checkbox" onclick="grid.SelectAllRowsOnPage(this.checked);" t itle="选择/放弃选择本页的所有行" /></HeaderTemplate><HeaderStyle HorizontalAlign="Center" /></dxwgv:GridViewCommandColumn>自定义按钮“删除”按钮<dx:GridViewCommandColumn Caption="删除"><CustomButtons><dx:GridViewCommandColumnCustomButton ID="DeleteFile" Text="删除" /> </CustomButtons></dx:GridViewCommandColumn>protected void gv_CustomButtonCallback(object sender, ASPxGridViewCustomBu ttonCallbackEventArgs e){if (e.ButtonID == "DeleteFile"){long fileId = Convert.ToInt64(gv.GetRowValues(e.VisibleIndex, "FileId"));string fileName = gv.GetRowValues(e.VisibleIndex, "FileName").ToString();string filePath = Common.Config.Path.PhysicalUploadFolder + gv.GetRowV alues(e.VisibleIndex, "FilePath").ToString();System.IO.File.Delete(filePath);using (DbFile db = new DbFile())db.DelFile(fileId);ShowData(this.FileBatchId);}}“复制行”按钮<dx:ASPxGridView runat="server" OnCustomButtonCallback="grid_CustomButto nCallback"><Columns><dxwgv:GridViewCommandColumn VisibleIndex="0"><CustomButtons><dxwgv:GridViewCommandColumnCustomButton Text="复制行" ID=" Copy" /></CustomButtons></dxwgv:GridViewCommandColumn></Columns></dx:ASPxGridView>Hashtable copiedValues;protected void grid_CustomButtonCallback(object sender, ASPxGridViewCustomB uttonCallbackEventArgs e){if(e.ButtonID == "Copy"){copiedValues = new Hashtable();foreach(string fieldName in copiedFields)copiedValues[fieldName] = grid.GetRowValues(e.VisibleIndex, fieldNam e);grid.AddNewRow();}}protected void grid_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataI nitNewRowEventArgs e){if(copiedValues != null)foreach(string fieldName in copiedFields)e.NewValues[fieldName] = copiedValues[fieldName];}非绑定列（GridViewDataTextColumn）<dxwgv:GridViewDataTextColumn FieldName="Total" UnboundType="Decimal" /> protected void grid_CustomUnboundColumnData(object sender, DevExpress.Web.ASP xGridView.ASPxGridViewColumnDataEventArgs e){// Total = UnitPrice * Quantityif(e.Column.FieldName == "Total"){decimal price = (decimal)e.GetListSourceFieldValue("UnitPrice");int quantity = Convert.ToInt32(e.GetListSourceFieldValue("Quantity"));e.Value = price * quantity;}}模板列（GridViewDataTextColumn）onhtmlrowcreated="grid_HtmlRowCreated"<dxwgv:GridViewDataTextColumn Name="Percent" Caption="Change" FieldName="Ch ange"><DataItemTemplate><asp:Image ID="changeImage" runat="server" ImageUrl="~/Images/arGreen.gi f" Visible="false" GenerateEmptyAlternateText="True" /><asp:Label ID="changePercent" runat="server" Text="" /><a href="javascript:void(0);" onclick="OnMoreInfoClick(this, '<%# Container.Ke yValue %>')">更多...</a><a href="../pages/download.ashx?path=../uploads/<%#Eval("FilePath")%>&na me=<%#Eval("FileName") %> " >下载</a></DataItemTemplate></dxwgv:GridViewDataTextColumn>protected void grid_HtmlRowCreated(object sender, ASPxGridViewTableRowEventArgs e){if (!grid.IsEditing && e.RowType == DevExpress.Web.ASPxGridView.GridViewRowT ype.Data){// 操作Label 控件Label label = grid.FindRowCellTemplateControl(e.VisibleIndex, null, "changePerc ent") as Label;decimal change = (decimal)grid.GetRowValues(e.VisibleIndex, "Change");label.Text = string.Format("{0:p}", change);// 操作Image 控件System.Web.UI.WebControls.Image img = (System.Web.UI.WebControls.Image) grid.FindRowCellTemplateControl(e.VisibleIndex, null, "changeImage");img.Visible = false;if(change != 0){img.Visible = true;img.ImageUrl = change < 0 ? "~/Images/arRed.gif" : "~/Images/arGreen.gif ";label.ForeColor = change < 0 ? Color.Red : Color.Green;}}}注：模板列中的事件如何写？手工写事件，如btn.OnClick += ...;注：视图模板请参考文档《ASPxGridView.Templates》ASPxGridView 事件RowCreated（创建行数据时触发，类似GridView 的DataItemCreate 事件）protected void grid_HtmlRowCreated(object sender, DevExpress.Web.ASPxGridView.A SPxGridViewTableRowEventArgs e){if(e.RowType != DevExpress.Web.ASPxGridView.GridViewRowType.Data) return;// 设置模板列lable控件值Label label = grid.FindRowCellTemplateControl(e.VisibleIndex, null, "changePercent ") as Label;decimal change = (decimal)grid.GetRowValues(e.VisibleIndex, "Change");label.Text = string.Format("{0:p}", change);// 设置模板列image控件的图像System.Web.UI.WebControls.Image img = (System.Web.UI.WebControls.Image)gri d.FindRowCellTemplateControl(e.VisibleIndex, null, "changeImage");img.Visible = false;if(change != 0) {img.Visible = true;img.ImageUrl = change < 0 ? "~/Images/arRed.gif" : "~/Images/arGreen.gif";label.ForeColor = change < 0 ? Color.Red : Color.Green;}}HtmlRowPrepared（行准备？可在此设置行的展示效果，如背景）protected void grid_HtmlRowPrepared(object sender, ASPxGridViewTableRowEventArg s e){bool hasError = e.GetValue("FirstName").ToString().Length <= 1;hasError = hasError || e.GetValue("LastName").ToString().Length <= 1;hasError = hasError || !e.GetValue("Email").ToString().Contains("@");hasError = hasError || (int)e.GetValue("Age") < 18;DateTime arrival = (DateTime)e.GetValue("ArrivalDate");hasError = hasError || DateTime.Today.Year != arrival.Year || DateTime.Today.Mo nth != arrival.Month;if(hasError) {e.Row.ForeColor = System.Drawing.Color.Red;}}UnboundColumnData （非绑定列数据填充）protected void grid_CustomUnboundColumnData(object sender, DevExpress.Web.ASP xGridView.ASPxGridViewColumnDataEventArgs e){if(e.Column.FieldName == "Total"){decimal price = (decimal)e.GetListSourceFieldValue("UnitPrice");int quantity = Convert.ToInt32(e.GetListSourceFieldValue("Quantity"));e.Value = price * quantity;}}CustomColumnDisplayText（定制列文本展示）protected void grid_CustomColumnDisplayText(object sender, DevExpress.Web.ASPx GridView.ASPxGridViewColumnDisplayTextEventArgs e){if(object.Equals(e.Column, grid.Columns["Size"]))e.DisplayText = GetSizeDisplayText(e.Value);}SummaryDisplayText（合计行文本展示）protected void grid_SummaryDisplayText(object sender, DevExpress.Web.ASPxGridVi ew.ASPxGridViewSummaryDisplayTextEventArgs e) {if(e.Item.FieldName == "Size") {e.Text = GetSizeDisplayText(e.Value);}}HeaderFilterFillItems（自定义过滤器处理逻辑）protected void grid_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEve ntArgs e){if(object.Equals(e.Column, grid.Columns["Total"])) {PrepareTotalFilterItems(e);return;}if(object.Equals(e.Column, grid.Columns["Quantity"])) {PrepareQuantityFilterItems(e);return;}}---------------------------------------------------------回调处理---------------------------------------------------------CustomCallback（Ajax 回调处理）<select id="selGridLayout" onchange="grid.PerformCallback(this.value);" > <option selected="selected" value="0">Country</option><option value="1">Country, City</option><option value="2">Company Name</option></select>protected void grid_CustomCallback(object sender, ASPxGridViewCustomCallbackEven tArgs e){int layoutIndex = -1;if(int.TryParse(e.Parameters, out layoutIndex))ApplyLayout(layoutIndex); // 更换布局}CustomButtonCallback（定制按钮的ajax回调处理）protected void grid_CustomButtonCallback(object sender, ASPxGridViewCustomButton CallbackEventArgs e){if(e.ButtonID != "Copy") return;copiedValues = new Hashtable();foreach(string fieldName in copiedFields)copiedValues[fieldName] = grid.GetRowValues(e.VisibleIndex, fieldName);grid.AddNewRow();}---------------------------------------------------------编辑视图---------------------------------------------------------InitNewRow（新建行的数据初始化处理）protected void grid_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNe wRowEventArgs e){if(copiedValues == null) return;foreach(string fieldName in copiedFields) {e.NewValues[fieldName] = copiedValues[fieldName];}}CellEditorInitialize（编辑器初始化）protected void grid_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e){if(grid.IsEditing && !grid.IsNewRowEditing && e.Column.FieldName == "City"){string country = (string)grid.GetRowValuesByKeyValue(e.KeyValue, "Country");ASPxComboBox combo = e.Editor as ASPxComboBox;FillCityCombo(combo, country);combo.Callback += new CallbackEventHandlerBase(cmbCity_OnCallback);}}StartRowEditing（开始编辑）protected void grid_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e){if(!grid.IsNewRowEditing) {grid.DoRowValidation();}}RowValidating （行数据验证）protected void grid_RowValidating(object sender, DevExpress.Web.Data.ASPxDataVali dationEventArgs e){foreach(GridViewColumn column in grid.Columns) {GridViewDataColumn dataColumn = column as GridViewDataColumn;if(dataColumn == null) continue;if(e.NewValues[dataColumn.FieldName] == null) {e.Errors[dataColumn] = "Value can't be null.";}}if(e.Errors.Count > 0) e.RowError = "Please, fill all fields.";if(e.NewValues["FirstName"] != null && e.NewValues["FirstName"].ToString().Lengt h < 2) {AddError(e.Errors, grid.Columns["FirstName"], "First Name must be at least two characters long.");}if(e.NewValues["LastName"] != null && e.NewValues["LastName"].ToString().Lengt h < 2) {AddError(e.Errors, grid.Columns["LastName"], "Last Name must be at least two characters long.");}if(e.NewValues["Email"] != null && !e.NewValues["Email"].ToString().Contains("@")) {AddError(e.Errors, grid.Columns["Email"], "Invalid e-mail.");}int age = 0;int.TryParse(e.NewValues["Age"] == null ? string.Empty : e.NewValues["Age"].ToS tring(), out age);if(age < 18) {AddError(e.Errors, grid.Columns["Age"], "Age must be greater than or equal 1 8.");}DateTime arrival = DateTime.MinValue;DateTime.TryParse(e.NewValues["ArrivalDate"] == null ? string.Empty : e.NewValu es["ArrivalDate"].ToString(), out arrival);if(DateTime.Today.Year != arrival.Year || DateTime.Today.Month != arrival.Month) {AddError(e.Errors, grid.Columns["ArrivalDate"], "Arrival date is required and mu st belong to the current month.");}if(string.IsNullOrEmpty(e.RowError) && e.Errors.Count > 0) e.RowError = "Please, correct all errors.";if (e.NewValues["Name"] == null){e.RowError = "功能名称不能为空，请填写功能名称";return;}if (e.NewValues["Remarks"] == null){e.RowError = "功能备注不能为空，请填写功能备注";return;}}行修改事件 RowUpdatingprotected void gvFunction_RowUpdating(object sender,DevExpress.Web.Data.ASPxDataUpdatingEventArgs e){ = e.NewValues[0].ToString();// 组名称functionModel.Remarks = e.NewValues[1].ToString(); // 组备注functionModel.FunctionId = e.Keys[0].ToString();// IDrmodel = client.FunctionEdit(functionModel);// 返回类型表gvFunction.CancelEdit();//结束编辑状态e.Cancel = true;FunctionDataBind();//更新数据}行添加事件RowInsertingprotected void gvFunction_RowInserting(object sender,DevExpress.Web.Data.ASPxDataInsertingEventArgs e){ = e.NewValues[0].ToString();// 组名称functionModel.Remarks = e.NewValues[1].ToString(); // 组备注rmodel = client.FunctionSubmit(functionModel);// 返回类型表gvFunction.CancelEdit();//结束编辑状态e.Cancel = true;FunctionDataBind();//更新数据}行删除事件RowDeletingprotected void gvFunction_RowDeleting(object sender,DevExpress.Web.Data.ASPxDataDeletingEventArgs e){functionModel.FunctionId = e.Keys[0].ToString();// IDclient.FunctionInfoDelete(functionModel);gvFunction.CancelEdit();//结束编辑状态e.Cancel = true;FunctionDataBind();//更新数据}初始化回调事件 Callbackprotected void callbackPanel_Callback(object sender,DevExpress.Web.ASPxClasses.CallbackEventArgsBase e){strGroupID = e.Parameter.ToString();DataBindInfo();// 初始化页面信息SelectUser();// 查找组里面的所有用户DataCheck();}获取行展开改变事件DetailRowExpandedChangedprotected void gvGroup_DetailRowExpandedChanged(object sender, ASPxGridViewDetailRowEventArgs e){SYSolution_WebUI.ServiceReference.GroupInfo groupInfoModel =(SYSolution_WebUI.ServiceReference.GroupInfo)((ASPxGridView)sender).GetRow(e.VisibleIndex);/ / 获取选中行实体ASPxGridView gv =(ASPxGridView)gvGroup.FindDetailRowTemplateControl(e.VisibleIndex, "gvGroupName"); // 获取模板内aspxgridView ID名称SYSolution_WebUI.ServiceReference.GroupInfo[] model =client.GroupSelUserList("GroupId='" + groupInfoModel.GroupId + "'");// 通过组ID值获取实体对象 if (model[0].UserInfoList != null && gv != null)// 当用用户列表值与子aspxgridView 不为空{gv.DataSource = model[0].UserInfoList; // 子aspxgridView绑定数据源gv.DataBind();}if (model[0].UserInfoList[0].Name == "") // 如果子aspxgridView中的用户列表为空时不显示不展开{gvGroup.SettingsDetail.AllowOnlyOneMasterRowExpanded = false;}}排序事件中重新绑定数据 BeforeColumnSortingGroupingprotected void gvGroup_BeforeColumnSortingGrouping(object sender, ASPxGridViewBeforeColumnGroupingSortingEventArgs e){gvGroup.DetailRows.CollapseAllRows();// 关闭所有DetailoRowgvGroup.DetailRows.ExpandRow(3);}重绑定数据使用时先选中行，再查看 FocusedRowChangedProtected void aspxGridView_FocusedRowChanged(object sender,EventArgs e){}行列绑定数据事件CustomUnboundColumnDataProtected void aspxGridView_CustomUnboundColumnData(object sender,EventArgs e){}.隐藏编辑列，在DataBound事件中protected void ASPxGridView1_DataBound(object sender, EventArgs e) {if(ASPxGridView1.VisibleRowCount>0){//ASPxGridView1.Columns[命令列索引](ASPxGridView1.Columns[4] as GridViewCommandColumn).NewButton.Visible = false;}}。

1.GridView代码分页排序：效果图：1.AllowSorting设为True，aspx代码中是AllowSorting="True"；2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。

3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

1：分页保存选中状态保存CheckBox的值GridView在分页过程中并不维护CheckBox的选择状态，幸运的是，我们可以使用Session来维护CheckBox的状态，这个功能使用RememberOldValues完成private void RememberOldValues(){ArrayList categoryIDList = new ArrayList();int index = -1;foreach (GridViewRow row in okZMGV.Rows){index =Convert .ToInt32( okZMGV.DataKeys[row.RowIndex].Value);bool result = ((CheckBox)row.FindControl("IsCheckBox")).Checked;// Check in the Sessionif (Session["state"] != null)categoryIDList = (ArrayList)Session["state"];if (result){if (!categoryIDList.Contains(index))categoryIDList.Add(index);}elsecategoryIDList.Remove(index);}if (categoryIDList != null && categoryIDList.Count > 0)Session["state"] = categoryIDList;}还原CheckBox的状态下一步，需要定义一个方法来还原Checkbox的状态值private void RePopulateValues(){ArrayList categoryIDList = (ArrayList)Session["state"];if (categoryIDList != null && categoryIDList.Count > 0){foreach (GridViewRow row in okZMGV .Rows){int index = (int)okZMGV.DataKeys[row.RowIndex].Value;if (categoryIDList.Contains(index)){CheckBox myCheckBox = (CheckBox)row.FindControl("IsCheckBox"); myCheckBox.Checked = true;}}}}最后，在分页事件里调用上面两个方法protected void page_Click(object sender, ImageClickEventArgs e){RememberOldValues();string count = ((ImageButton)sender).CommandArgument.ToString().ToLower ();switch(count){case"prev":if (okZMGV.PageIndex > 0){okZMGV.PageIndex -= 1;}break;case"next":if (okZMGV.PageIndex < okZMGV.PageCount - 1){okZMGV.PageIndex += 1;}break;case "0":okZMGV.PageIndex=0;break;case "last":okZMGV.PageIndex= okZMGV.pagecount-1;break;}BrndOKBind();RePopulateValues();}2.GridView选中，编辑，取消，删除：效果图：后台代码：你可以使用sqlhelper,本文没用。

Gridview⽤法⼤总结（全程图解珍藏版）
由于篇幅限制，代码就不贴啦，要的请点击这⾥；希望朋友们能给出⼀些好的建议，本⼈将尽⼒不断完善本⽂！来点掌声吧，o(∩_∩)o...哈哈
1：在Gridview中⽆须编写后台代码，直接实现增除删改
2：在Gridview中添加新记录
3：在Gridview中实现编辑和更新操作
4：在Gridview中实现⼀次性更新所有记录
5：在Gridview中固定表头的实现
6：在Gridview中合并单元格的实现
7：在Gridview中将数据操作结果显⽰在Footer中
8：在Gridview中添加表头
9：在Gridview中将数据导出
10：在Gridview中实现数据导⼊
11：在Gridview中实现嵌套功能
12：在Gridview中实现多层嵌套
13：在Gridview中实现排序
14：在Gridview中实现分页
15：Gridivew结合CheckBox控件的使⽤
16：Gridview结合DropDownList控件的使⽤
17：Gridview结合RadioButtom的使⽤
18：Gridview内嵌DropDownList控件
19：Gridview结合JS，在客户端结合CheckBox的使⽤
20：在Gridview中设置数据⾏的背景颜⾊
21：在Gridview中设置数据⾏的事件
22：在Gridview中设置数据⾏的其他属性
23：在Gridview中索引主键的使⽤。

Gridview用法(个人总结)202X803Gridview用法(个人总结)202*0803Gridview的一些操作：1、添加删除列：直接使用Gridview的删除事件：1）选择Gridview的右上角任务栏，打开之后选择编辑列，然后选择CommandFiled，打开CommandFiled选择删除，然后选择添加，设置HeadText为删除。

2）打开Gridview控件的属性对话框，在事件中双击RowDeleting，然后添加删除事件代码：protectedvoidGridView1_RowDeleting(objectsender,GridViewDelete EventArgse){StringBuildersb=newStringBuilder();sb.AppendFormat(@"DELETEFRO MSUPPLIERSWHEREID="+Convert.ToInt32(GridView1.DataKeys[e.RowIndex] .Value));SQLHelperhelper=newSQLHelper();helper.ExecuteSql(sb.ToStr ing());Bindon();}不使用Gridview的删除事件：使用添加LinkButton的方法实现删除选定行1）选择Gridview的右上角任务栏，打开之后选择编辑列，然后选择TemplateField，设置HeadText为删除，然后在脚本中添加下面代码：2）打开Gridview控件的属性对话框，在事件中双击RowDataBound，添加如下代码：//获取删除行的IDif(e.Row.RowType==DataControlRowType.DataRow){stringid=GridVie w1.DataKeys[e.Row.RowIndex].Value.ToString();//得到idLinkButtonibtnDel=(LinkButton)e.Row.FindControl("delet");//实例化LinButton按钮控件mandArgument=id;//指定删除按钮的关联参数ibtnDel.Attributes.Add("onclick","returnconfirm("确定要删除吗？");");}3）打开Gridview控件的属性对话框，在事件中双击RowCommand，添加如下代码：if(mandName=="del"){stringid=mandArgument.ToString();//获得IDStringBuildersb=newStringBuilder();sb.AppendFormat(@"DELETEFROMSUPPLIERSWHEREID="+id);SQLHelperhe lper=newSQLHelper();helper.ExecuteSql(sb.ToString());Bindon();}即可。

SqlSugarGridViewaspnetpager分页排序HTML页⾯<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %><asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"><div class="jumbotron"><asp:GridView ID="GridView1" runat="server" AllowSorting="true" OnSorting="GridView1_Sorting" Width="98%"OnRowCommand="GridView1_RowCommand" AutoGenerateColumns="false"><RowStyle Height="20px" HorizontalAlign="Center" ForeColor="#000066"></RowStyle><Columns><asp:BoundField DataField="ID" HeaderText="编号" SortExpression="ID"/><asp:BoundField DataField="HotelID" HeaderText="酒店编码" SortExpression="HotelID"/><asp:BoundField DataField="TypeName" HeaderText="类型名称" SortExpression="TypeName"/><asp:BoundField DataField="CreateTime" HeaderText="⽣成时间" SortExpression="CreateTime"/><asp:BoundField DataField="CreateBy" HeaderText="创建⼈" SortExpression="CreateBy"/><asp:TemplateField HeaderText="操作"><ItemTemplate><asp:LinkButton ID="LinkButton1" runat="server" CommandName="Del" CommandArgument='<%# Eval("ID") %>'>删除</asp:LinkButton> </ItemTemplate></asp:TemplateField></Columns></asp:GridView></div><div><webdiyer:aspnetpager ID="AspNetPager1" runat="server" PageSize="35" Width="95%"FirstPageText="⾸页" PrevPageText="前页" LayoutType="Table" NextPageText="后页"LastPageText="尾页" AlwaysShow="true" UrlPaging="false"showcustominfosection="Left" onpagechanging="AspNetPager1_PageChanging" class="gl-number-page"></webdiyer:aspnetpager></div></asp:Content>Model CardType类using SqlSugar;using System;using System.Collections.Generic;using System.Linq;using System.Web;[Serializable][SugarTable("tb_CardType")]public class CardType{[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]public int ID { get; set; }public int HotelID { get; set; }public string TypeName { get; set; }public DateTime CreateTime { get; set; }public string CreateBy { get; set; }}页⾯后台代码using SqlSugar;using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : Page{protected SqlSugarClient db = new SqlSugarClient(new ConnectionConfig(){ConnectionString = "server=JYJKQC53O;uid=sa;pwd=1a2s3d4f5g6h;database=Hotel345",DbType = DbType.SqlServer,//设置数据库类型IsAutoCloseConnection = true,//⾃动释放数据务，如果存在事务，在事务结束后释放InitKeyType = InitKeyType.Attribute //从实体特性中读取主键⾃增列信息});protected void Page_Load(object sender, EventArgs e){if (db.Queryable<CardType>().Count() < 50){var list = new List<CardType>();CardType cartype;for (int i = 0; i < 50; i++){cartype = new CardType();cartype.HotelID = 3;cartype.TypeName = "居民⾝份证" + i.ToString();cartype.CreateTime = DateTime.Now;cartype.CreateBy = "fermnng";list.Add(cartype);}db.Insertable(list.ToArray()).ExecuteCommand();}if (!Page.IsPostBack){ViewState["sort"] = "ASC";ViewState["sortExpression"] = "ID";DataBin();}}protected void DataBin(){int total = 0;var getPage = db.Queryable<CardType>().ToPageList(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, ref total);//根据分页查询if (ViewState["sort"].ToString() == "ASC"){getPage = getPage.OrderBy(s => GetPropertyValue(s, ViewState["sortExpression"].ToString())).ToList<CardType>();}else{getPage = getPage.OrderByDescending(s => GetPropertyValue(s, ViewState["sortExpression"].ToString())).ToList<CardType>();}this.GridView1.DataSource = getPage;this.GridView1.DataBind();AspNetPager1.RecordCount = total;ViewState["getPage"] = getPage;}protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e){AspNetPager1.CurrentPageIndex = e.NewPageIndex;DataBin();}protected void GridView1_Sorting(object sender, GridViewSortEventArgs e){string sortExpression = e.SortExpression;var list = ViewState["getPage"] as List<CardType>;if (ViewState["sort"].ToString() == "ASC"){list = list.OrderByDescending(s => GetPropertyValue(s, sortExpression)).ToList<CardType>();ViewState["sort"] = "DESC";}else{list = list.OrderBy(s => GetPropertyValue(s, sortExpression)).ToList<CardType>();ViewState["sort"] = "ASC";}if (list.Count > 0){ViewState["sortExpression"] = sortExpression;GridView1.DataSource = list;GridView1.DataBind();}}public object GetPropertyValue(object obj, string property){System.Reflection.PropertyInfo propertyInfo = obj.GetType().GetProperty(property);return propertyInfo.GetValue(obj, null);}protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e){if (mandName == "Del"){int RowID = Convert.ToInt32(mandArgument);var result = db.Deleteable<CardType>().In(RowID).ExecuteCommand();DataBin(); }}}。

至顶网()-中国最大的企业级IT资源门户-技术成就商务首页网络安全存储服务器软件桌面产品库开发 CIO 白皮书管理软件新闻下载社区专家博客视频CNETNews 中小企业网站联盟开发者在线 /开发者社区首页C/S开发数据库中间件Web嵌入式项目管理网页设计社区搜索《博客三人行》《软话连篇》《边看边读》《至顶大课堂》站点导航：开发者在线 编程[冷枫]关于VS2005中GridView的自定义分页，单选、多选、排序、自增列的简单应用[冷枫]关于VS2005中GridView的自定义分页，单选、多选、排序、自增列的简单应用开发者在线 更新时间:2007-09-23作者：冷枫来源:CSDN本文关键词：冷枫分页单选排序自增列关于VS2005中GridView的自定义分页，单选、多选、排序、自增列的简单应用。

多选时，只有全部选中时“多选”才选中。

图片效果：简单示例，代码如下，fenpage.aspx的代码：<%@ Page Language="C#" AutoEventWireup="true" CodeFile="fenpage.aspx.cs" Inherits="gridview_fenpage" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head runat="server"><title></title><script language="javascript" type="text/javascript">// 判断多选是否与选中项（没有选中的返回false）function slcNo_click(){if (document.form1.checkboxname.length){for (var i=0;i<document.form1.checkboxname.length;i++){if(document.form1.checkboxname[i].checked){return true;}}}else{if(document.form1.checkboxname.checked){return true;}}alert("请选择后再操作！");return false;}// 鼠标经过改变行的颜色if (!objbeforeItem){var objbeforeItem=null;var objbeforeItembackgroundColor=null;}function ItemOver(obj){if(objbeforeItem){objbeforeItem.style.backgroundColor = objbeforeItembackgroundColor; }objbeforeItembackgroundColor = obj.style.backgroundColor;objbeforeItem = obj;obj.style.backgroundColor = "#B9D1F3";}//// 多选的全选与取消function checkJs(boolvalue){if(document.all.checkboxname.length>1){for(var i=0;i<document.all.checkboxname.length;i++){document.all.checkboxname[i].checked = boolvalue; }}elsedocument.all.checkboxname.checked = boolvalue;}//// 只有全部选中时“全选”选中function SingleCheckJs(){var flag1=false;var flag2=false;if (document.form1.checkboxname.length){for (var i=0;i<document.form1.checkboxname.length;i++){if(document.form1.checkboxname[i].checked)flag1 = true;elseflag2 = true;}}else{if(document.form1.checkboxname.checked)flag1 = true;elseflag2 = true;}if(flag1==true&&flag2==false)document.getElementById("chk").checked = true;elsedocument.getElementById("chk").checked = false;}//</script></head><body><form id="form1" runat="server"><div><table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px"><tr><td align="center"><asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"AutoGenerateColumns="False" AllowPaging="True" PageSize="12" BorderColor="Silver"BorderStyle="Solid" BorderWidth="1px" OnRowDataBound="GridView1_RowDataBound"ShowFooter="True" EmptyDataText="没有数据记录！！"AllowSorting="True" OnSorting="GridView1_Sorting"><Columns><asp:BoundField HeaderText="编号" DataField="id" Visible="False" /><asp:TemplateField HeaderText="&lt;input type='checkbox' id='chk' name='chk' onclick='checkJs(this.checked);' /&gt;全选" FooterText="全选"><ItemTemplate><input type="checkbox" id="checkboxname" name="checkboxname" value='<%# DataBinder.Eval(Container.DataItem, "id")%>' onclick='SingleCheckJs();' /></ItemTemplate></asp:TemplateField><asp:TemplateField HeaderText="单选" FooterText="单选"><ItemTemplate><input type="radio" id="RadioName" name="RadioName" value='<%# Eval("id")%>' /></ItemTemplate></asp:TemplateField><asp:TemplateField HeaderText="自增列" FooterText="自增列"><ItemTemplate><%#(Container.DataItemIndex+1).ToString()%></ItemTemplate></asp:TemplateField><asp:BoundField HeaderText="姓名" FooterText="姓名" DataField="name" SortExpression="name" /><asp:BoundField HeaderText="身份证号" FooterText="身份证号" DataField="card" SortExpression="card" /><asp:BoundField HeaderText="价格" FooterText="价格" DataField="price" DataFormatString=""HtmlEncode="False" SortExpression="price" /> <asp:BoundField HeaderText="数字" FooterText="数字" DataField="price" DataFormatString=""HtmlEncode="False" SortExpression="price" /> <asp:BoundField HeaderText="建立时间" FooterText="建立时间" DataField="createdate" DataFormatString=""HtmlEncode="False"SortExpression="createdate" /></Columns><RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <EditRowStyle BackColor="#999999" /><SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /><PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /><AlternatingRowStyle BackColor="White" ForeColor="#284775" /><PagerSettings Visible="False" /><FooterStyle Font-Bold="True" /><HeaderStyle Font-Bold="False" Font-Italic="False" /> </asp:GridView></td></tr><tr><td align="center" style="height: 25px"><asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"runat="server">首页</asp:LinkButton><asp:LinkButton ID="btnPrev" CommandArgument="prev" OnClick="PagerButtonClick" runat="server">上一页</asp:LinkButton><asp:LinkButton ID="btnNext" CommandArgument="next" OnClick="PagerButtonClick" runat="server">下一页</asp:LinkButton><asp:LinkButton ID="btnLast" CommandArgument="last" OnClick="PagerButtonClick" runat="server">尾页</asp:LinkButton><asp:Label ID="LblCurrentIndex" runat="server"></asp:Label><asp:Label ID="LblPageCount" runat="server"></asp:Label> <asp:Label ID="LblRecordCount" runat="server"></asp:Label></td></tr><tr><td><asp:Button ID="Button2" runat="server" Text="checkbox得到选择的行" OnClick="Button2_Click"></asp:Button><asp:Button ID="Button1" runat="server" Text="radio得到选择的行" OnClick="Button1_Click"></asp:Button></td></tr></table></div></form></body></html>fenpage.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;public partial class gridview_fenpage : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){Button2.Attributes["onclick"] = "return slcNo_click();";GridViewBind("");}private void GridViewBind(string Sqlsort){string connStr = ConfigurationManager.ConnectionStrings["ConnString1"].ConnectionString;string SqlStr = "SELECT * FROM test01 where id<1000" + Sqlsort;DataSet ds = new DataSet();try{SqlConnection conn = new SqlConnection(connStr);if (conn.State.ToString() == "Closed") conn.Open();SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);da.Fill(ds, "test01");if (conn.State.ToString() == "Open") conn.Close();GridView1.DataSource = ds.Tables[0].DefaultView;GridView1.DataBind();LblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";LblPageCount.Text = "共 " + GridView1 .PageCount.ToString()+ " 页"; LblRecordCount.Text = "总共 "+ds.Tables[0].Rows.Count.ToString()+" 条";if (ds.Tables[0].Rows.Count == 0){btnFirst.Visible = false;btnPrev.Visible = false;btnNext.Visible = false;btnLast.Visible = false;LblCurrentIndex.Visible = false;LblPageCount.Visible = false;LblRecordCount.Visible = false;}else if (GridView1.PageCount == 1){btnFirst.Visible = false;btnPrev.Visible = false;btnNext.Visible = false;btnLast.Visible = false;}// 计算生成分页页码,分别为："首页" "上一页" "下一页" "尾页"mandName = "1";mandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());mandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());mandName = GridView1.PageCount.ToString();//}catch(Exception ex){Response.Write("数据库错误，错误原因："+ex.Message);Response.End();}}protected void PagerButtonClick(object sender, EventArgs e){GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName)-1;GridViewBind("");}protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {e.Row.Attributes["onmouseover"] = "ItemOver(this)";}protected void Button2_Click(object sender, EventArgs e){string str="";string []ckb=null;str=Request.Form.Get("checkboxname");ckb=str.Split(new char[]{','});Response.Write("直接在页面中得到的值为："+str+"<br>");Response.Write("处理后存放在数组中，如下：<br>");for(int i=0;i<ckb.Length;i++){Response.Write("ckb["+i+"]的值为："+ckb[i]+"<br>");}}protected void Button1_Click(object sender, EventArgs e){Response.Write(Request.Form.Get("RadioName"));}protected void GridView1_Sorting(object sender, GridViewSortEventArgs e){string sql = "";if (ViewState["SortDirection"] == null || ViewState["SortDirection"].ToString().CompareTo("") == 0){ViewState["SortDirection"] = " desc";}elseViewState["SortDirection"] = "";sql = " order by " + e.SortExpression + ViewState["SortDirection"];GridViewBind(sql);}}数据库中表的生成代码：CREATE TABLE [dbo].[test01] ([id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[createdate] [datetime] NULL) ON [PRIMARY]GOALTER TABLE [dbo].[test01] ADDCONSTRAINT [DF_test01_createdate] DEFAULT (getdate()) FOR [createdate], CONSTRAINT [PK_test01] PRIMARY KEY CLUSTERED([id]) ON [PRIMARY]GOTrackback: /TrackBack.aspx?PostId=1312814推荐阅读与冷枫分页单选排序自增列相关开发者在线内容冷枫分页单选排序自增列相关技术文章几条常见的数据库分页 SQL 语句调用Oracle存储过程实现快速分达梦数据库查询结果集分页实现使用VS2005打造简单分页浏览器基于的自定义分页显示程序中用Repeater实现分页 翻页后继续维持排序利用实现分页管理器中实现大结果集分页研讨用户评论评论列表发表评论用户名评论内容用户名：邮件地址：BBS讨论ASP怎样显示记录集中的某一记录出现这种错误提示是为什么？？？就这段代码明明是对的啊，怎么说有错数据透视表相加如何操作问两道 sql题新建的SQL数据库怎么设置登陆名和密phpcms discuz这个连接查询怎么做？什么叫做唯一约束？我理解的对吗？SET sql_mode='' 什么意思更多最新文章?热门栏目推荐C/S开发数据库开发 WEB开发移动嵌入式项目管理网页设计新品快看技术英雄技术看板图片故事热门软件技术推荐XML C/C++ C# Java Oracle Mysql .Net CSS SQL database UNIX Linux Jsp PHP Perl JavaScript ColdFusion ASP/ Apache AJAX开发者在线冷枫最新报道怎样用VS2005进行三层结构应用程序的开发[冷枫]用OTA下载本机J2me程序至手机[冷枫]J2ME中两种Http连接方式Post&Get的比较[冷枫]J2ME开发中的按键事件[冷枫]MIDP2.0声音用法[冷枫]在无线J2ME设备上实现超文本传输协议[冷枫]自己收藏的HelloWorld[冷枫]J2me多线程[冷枫]ASP数据库简单操作教程[冷枫]J2EE架构的6个最佳实践开发者在线分页最新报道几条常见的数据库分页 SQL 语句调用Oracle存储过程实现快速分页达梦数据库查询结果集分页实现使用VS2005打造简单分页浏览器基于的自定义分页显示程序中用Repeater实现分页利用实现分页管理器中实现大结果集分页研讨 2.0数据处理之高级分页/排序一个用JSP实现的分页的类及调用方法开发者在线单选最新报道Delphi中为TreeView添加单选和复选框开发者在线排序最新报道 翻页后继续维持排序 2.0数据处理之高级分页/排序V$TEMPSEG_USAGE与Oracle排序v$tempfile与v$sort_usage之关系解析PB中实现数据窗口动态排序的三种方法 翻页后继续维持排序(2) 翻页后继续维持排序(1)DataGrid同时具有分页和排序功能及注意点 翻页后继续维持排序-爱卡汽车网 | 网上车市 | CNET科技资讯网 | CWEEK | 蜂鸟网 | GameSpot China| 个人电脑 | 开发者在线 | PChome | Solidot | SPN |投影顾问网 | 万维家电网 | 网友世界 | 西域IT | ZDNet China | 中关村在线 | 中小企业成长网 | onlylady女人志联系我们 | 网站导航 | 网站简介 | 友情链接 | 申请自助链接 CNET Networks旗下网站: 选择网站CNET CNET CNET ReviewsCNET mySimonReleaseWebshotsZDNet Copyright ? 1997-2008 CNET Networks 版权所有。