个人建站需要多少钱,什么是运营管理,临淄网站建设公司,413 request entity too large wordpress演练#xff1a;使用 ListView Web 服务器控件修改数据 演练#xff1a;使用 ListView Web 服务器控件对数据进行显示、分页和排序 DataPager 控件 注意DataPager控件只能和ListView控件使用,不能和其他数据绑定控件使用! 以下ListView 里面的代码都是按照上面链接里面说的步…演练使用 ListView Web 服务器控件修改数据 演练使用 ListView Web 服务器控件对数据进行显示、分页和排序 DataPager 控件 注意DataPager控件只能和ListView控件使用,不能和其他数据绑定控件使用! 以下ListView 里面的代码都是按照上面链接里面说的步骤执行生成的代码…,不过下面的删除功能有问题,因为删除的时候他涉及到外键关系… % Page LanguageC# AutoEventWireuptrue CodeBehinddatasUseGridView.aspx.csInheritstestWeb.databing.datasUseGridView EnableViewStatetrue %!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
html xmlnshttp://www.w3.org/1999/xhtml
head runatservertitleListView和DataPager/title
/head
bodyform idform1 runatserverdivasp:ListView IDListView1 runatserver DataKeyNamesDepartmentID DataSourceIDSqlDataSource2InsertItemPositionLastItemAlternatingItemTemplatetr stylebackground-color: #FFFFFF; color: #284775;tdasp:Button IDDeleteButton runatserver CommandNameDelete Text删?除y OnClientClickreturn confirm(Are you sure?); /asp:Button IDEditButton runatserver CommandNameEdit Text编à辑- //tdtdasp:Label IDDepartmentIDLabel runatserver Text%# Eval(DepartmentID) % //tdtdasp:Label IDNameLabel runatserver Text%# Eval(Name) % //tdtdasp:Label IDGroupNameLabel runatserver Text%# Eval(GroupName) % //td/tr/AlternatingItemTemplateEditItemTemplatetr stylebackground-color: #999999;tdasp:Button IDUpdateButton runatserver CommandNameUpdate Text更ü新? /asp:Button IDCancelButton runatserver CommandNameCancel Text取?消? //tdtdasp:Label IDDepartmentIDLabel1 runatserver Text%# Eval(DepartmentID) % //tdtdasp:TextBox IDNameTextBox runatserver Text%# Bind(Name) % //tdtdasp:TextBox IDGroupNameTextBox runatserver Text%# Bind(GroupName) % //td/tr/EditItemTemplateEmptyDataTemplatetable runatserver stylebackground-color: #FFFFFF; border-collapse: collapse;border-color: #999999; border-style: none; border-width: 1px;trtd未′返μ回?数y据Y。/td/tr/table/EmptyDataTemplateInsertItemTemplatetr styletdasp:Button IDInsertButton runatserver CommandNameInsert Text插?入? /asp:Button IDCancelButton runatserver CommandNameCancel Text清?除y //tdtdnbsp;/tdtdasp:TextBox IDNameTextBox runatserver Text%# Bind(Name) % //tdtdasp:TextBox IDGroupNameTextBox runatserver Text%# Bind(GroupName) % //td/tr/InsertItemTemplateItemTemplatetr stylebackground-color: #E0FFFF; color: #333333;tdasp:Button IDDeleteButton runatserver CommandNameDelete Text删?除y /asp:Button IDEditButton runatserver CommandNameEdit Text编à辑- //tdtdasp:Label IDDepartmentIDLabel runatserver Text%# Eval(DepartmentID) % //tdtdasp:Label IDNameLabel runatserver Text%# Eval(Name) % //tdtdasp:Label IDGroupNameLabel runatserver Text%# Eval(GroupName) % //td/tr/ItemTemplateLayoutTemplatetable runatservertr runatservertd runatservertable iditemPlaceholderContainer runatserver border1 stylebackground-color: #FFFFFF;border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;font-family: Verdana, Arial, Helvetica, sans-serif;tr runatserver stylebackground-color: #E0FFFF; color: #333333;th runatserver/thth runatserverDepartmentID/thth runatserverName/thth runatserverGroupName/th/trtr iditemPlaceholder runatserver/tr/table/td/trtr runatservertd runatserver styletext-align: center; background-color: #5D7B9D; font-family: Verdana, Arial, Helvetica, sans-serif;color: #FFFFFF/td/tr/table/LayoutTemplateSelectedItemTemplatetr stylebackground-color: #E2DED6; font-weight: bold; color: #333333;tdasp:Button IDDeleteButton runatserver CommandNameDelete Text删?除y /asp:Button IDEditButton runatserver CommandNameEdit Text编à辑- //tdtdasp:Label IDDepartmentIDLabel runatserver Text%# Eval(DepartmentID) % //tdtdasp:Label IDNameLabel runatserver Text%# Eval(Name) % //tdtdasp:Label IDGroupNameLabel runatserver Text%# Eval(GroupName) % //td/tr/SelectedItemTemplate/asp:ListView //数据源控件asp:SqlDataSource IDSqlDataSource2 runatserver ConnectionString%$ ConnectionStrings:AdventureWorksConnectionString %DeleteCommandDELETE FROM HumanResources.Department WHERE (DepartmentID DepartmentID)InsertCommandINSERT INTO HumanResources.Department(Name, GroupName)
VALUES (Name, GroupName)SelectCommandSELECT DepartmentID, Name, GroupName
FROM HumanResources.DepartmentUpdateCommandUPDATE HumanResources.Department
SET Name Name, GroupName GroupName
WHERE (DepartmentID DepartmentID)
DeleteParametersasp:Parameter NameDepartmentID //DeleteParametersInsertParametersasp:Parameter NameName /asp:Parameter NameGroupName //InsertParametersUpdateParametersasp:Parameter NameName /asp:Parameter NameGroupName /asp:Parameter NameDepartmentID //UpdateParameters/asp:SqlDataSource %--默认的--%%--asp:DataPager IDDataPager1 runatserver PagedControlIDListView1 PageSize5Fieldsasp:NextPreviousPagerField ButtonTypeButton ShowFirstPageButtonTrue ShowNextPageButtonFalseShowPreviousPageButtonFalse /asp:NumericPagerField /asp:NextPreviousPagerField ButtonTypeButton ShowLastPageButtonTrue ShowNextPageButtonFalseShowPreviousPageButtonFalse //Fields/asp:DataPager--%%--自定义分页控件样式--%asp:DataPager runatserver IDDataPager2 PageSize8 PagedControlIDListView1Fieldsasp:TemplatePagerFieldPagerTemplatenbsp;asp:TextBox IDCurrentRowTextBox runatserver AutoPostBacktrue Text%# Container.StartRowIndex 1%Columns1 Styletext-align: right OnTextChangedCurrentRowTextBox_OnTextChanged /toasp:Label IDPageSizeLabel runatserver Font-Boldtrue Text%# Container.StartRowIndex Container.PageSize Container.TotalRowCount ? Container.TotalRowCount : Container.StartRowIndex Container.PageSize % /ofasp:Label IDTotalRowsLabel runatserver Font-Boldtrue Text%# Container.TotalRowCount % //PagerTemplate/asp:TemplatePagerFieldasp:NextPreviousPagerField ShowFirstPageButtontrue ShowLastPageButtontrueFirstPageText| LastPageText | NextPageText PreviousPageText //Fields/asp:DataPager/div/form
/body
/html后台… using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;namespace testWeb.databing
{public partial class datasUseGridView : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){}protected void CurrentRowTextBox_OnTextChanged(object sender, EventArgs e){TextBox t (TextBox)sender;DataPager pager (DataPager)this.FindControl(DataPager2);//如?果?DataPager放?在úListView控?件t里?面?,则ò需è要a使1用?下?面?的?方?式?获?取?//DataPager pager (DataPager)ListView1.FindControl(DataPager2);pager.SetPageProperties(Convert.ToInt32(t.Text) - 1, pager.PageSize, true);}}
}Technorati 标签: ListView,DataPager转载于:https://www.cnblogs.com/jinho/archive/2010/06/21/1762308.html
