gv,Repeater分页示例代码

来源：互联网发布：医药进销存软件免费版编辑：程序博客网时间：2024/04/26 14:49

web:

if (!IsPostBack)
this.GridView1.Sort("ID", SortDirection.Ascending);

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1" AllowSorting="True"> <Columns> <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" /> <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" /> <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" /> <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" /> </Columns> </asp:GridView> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" TypeName="BLL.UserInfo" SelectMethod="GetUserInfo" EnablePaging="True" SelectCountMethod="GetUserInfoCount" SortParameterName="sortParam"></asp:ObjectDataSource>

BLL

using System.Data;using System.ComponentModel;namespace BLL{ [DataObject] public class UserInfo { [DataObjectMethod(DataObjectMethodType.Select, true)] public static DataTable GetUserInfo(int maximumRows, int startRowIndex, string sortParam) { DAL.UserInfoDal dal = new DAL.UserInfoDal(); return dal.GetUserInfo(maximumRows,startRowIndex,sortParam); } public static int GetUserInfoCount() { DAL.UserInfoDal dal = new DAL.UserInfoDal(); return dal.GetUserInfoCount(); } }}

DAL

namespace DAL{ public class UserInfoDal { #region ProcedurePages// ALTER PROCEDURE [dbo].[GetUserInfoPaged]// @startRowIndex int,// @maximumRows int,// @IsGetCount bit,// @SortParam nvarchar(50)//AS//BEGIN// SET NOCOUNT ON;// if(@IsGetCount=1)// select count(ID) from UserInfo// else begin// declare @Sql nvarchar(2000);// set @Sql = 'with TempTable as(// SELECT ID, UserName, Password,Age , ROW_NUMBER() OVER(ORDER BY ' + @SortParam + ') AS RowNumber FROM UserInfo)// select * from TempTable// where RowNumber between ' + cast(@StartRowIndex + 1 as varchar(50)) + ' and ' + cast(@StartRowIndex + @MaximumRows as varchar(50));// exec(@Sql);// end//END//---------------------------2000---------------------------------------//ALTER PROCEDURE [dbo].[GetUserInfoPaged]// @startRowIndex int,// @maximumRows int,// @IsGetCount bit,// @SortParam nvarchar(50)//AS//BEGIN// SET NOCOUNT ON;// if(@IsGetCount=1)// select count(ID) from UserInfo// else begin// declare @EndRowIndex int// set @EndRowIndex = @startRowIndex + @maximumRows// -- Create temp table// create table #RowsIndexTable(RowIndex int identity(0,1) not null, UserID int)// -- Insert row(s) into temp table// set rowcount @EndRowIndex// if(Len(@SortParam) = 0) begin// -- when @SortParam="", do not sort// insert into #RowsIndexTable(UserID)// select ID from UserInfo // end// else begin// -- when @SortParam <> "", sort by @SortParam// declare @sql nvarchar(2000)// set @sql = 'insert into #RowsIndexTable(UserID) ' +// 'select ID from UserInfo order by ' + @SortParam// exec (@sql)-- or use exec sp_executesql @sql// end// select ID, UserName, Password,Age from UserInfo u// inner join #RowsIndexTable t on u.ID = t.UserID// and t.RowIndex >= @startRowIndex and t.RowIndex <= @EndRowIndex // order by t.RowIndex// end//END// ---------------------------------2000 top--------// ALTER PROCEDURE [dbo].[GetUserInfoPaged]// @startRowIndex int,// @maximumRows int,// @IsGetCount bit,// @SortParam nvarchar(50)//AS//BEGIN// SET NOCOUNT ON;// if(@IsGetCount=1)// select count(ID) from UserInfo// else begin// declare @EndRowIndex int// set @EndRowIndex = @startRowIndex + @maximumRows// -- Create temp table// create table #RowsIndexTable(RowIndex int identity(0,1) not null, UserID int)// -- Insert row(s) into temp table// --set rowcount @EndRowIndex// declare @sql nvarchar(2000)// if(Len(@SortParam) = 0) begin// -- when @SortParam="", do not sort//--insert into #RowsIndexTable(UserID)//--select top cast(@EndRowIndex as varchar(50)) ID from UserInfo // set @sql = 'insert into #RowsIndexTable(UserID) ' +// 'select top ' + cast(@EndRowIndex as varchar(50)) + ' ID from UserInfo'// exec (@sql)-- or use exec sp_executesql @sql// end// else begin// -- when @SortParam <> "", sort by @SortParam// set @sql = 'insert into #RowsIndexTable(UserID) ' +// 'select top ' + cast(@EndRowIndex as varchar(50)) + ' ID from UserInfo order by ' + @SortParam// exec (@sql)-- or use exec sp_executesql @sql// end// select ID, UserName, Password,Age from UserInfo u// inner join #RowsIndexTable t on u.ID = t.UserID// and t.RowIndex >= @startRowIndex and t.RowIndex <= @EndRowIndex // order by t.RowIndex// end//END #endregion public DataTable GetUserInfo(int maximumRows, int startRowIndex,string sortParam) { DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection("Data Source=STARGATEPC;Initial Catalog=MyDB;User ID=sa;Password=sa")) { //SqlCommand cmd = new SqlCommand("select * from UserInfo", conn); SqlCommand cmd = new SqlCommand("GetUserInfoPaged", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@startRowIndex", SqlDbType.Int); cmd.Parameters.Add("@maximumRows", SqlDbType.Int); cmd.Parameters.Add("@IsGetCount", SqlDbType.Bit); cmd.Parameters.Add("@SortParam", SqlDbType.VarChar,50); cmd.Parameters[0].Value = startRowIndex; cmd.Parameters[1].Value = maximumRows; cmd.Parameters[2].Value = false; cmd.Parameters[3].Value = sortParam; conn.Open(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds); } return ds.Tables[0]; } public int GetUserInfoCount() { int count = 0; using (SqlConnection conn = new SqlConnection("Data Source=STARGATEPC;Initial Catalog=MyDB;User ID=sa;Password=sa")) { SqlCommand cmd = new SqlCommand("GetUserInfoPaged", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@startRowIndex", SqlDbType.Int); cmd.Parameters.Add("@maximumRows", SqlDbType.Int); cmd.Parameters.Add("@IsGetCount", SqlDbType.Bit); cmd.Parameters.Add("@SortParam", SqlDbType.VarChar, 50); cmd.Parameters[0].Value = 1; cmd.Parameters[1].Value = 10; cmd.Parameters[2].Value = true; cmd.Parameters[3].Value = "ID"; conn.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); } return count; } }}

   <asp:GridView ID="gvTraderFavourable" runat="server" AutoGenerateColumns="False"
                DataKeyNames="TraderFavourableInfoID" AllowSorting="true" OnRowCommand="gvTraderFavourable_RowCommand"
                OnSorting="gvTraderFavourable_Sorting">

<asp:HiddenField ID="HidSortDirection" Value="DESC" runat="server" />
<asp:HiddenField ID="HidSortExpression" Value="TraderFavourableInfoID" runat="server" />

protected void gvTraderFavourable_Sorting(object sender, GridViewSortEventArgs e) { string p_SortDirection = this.HidSortDirection.Value; this.HidSortExpression.Value = e.SortExpression.ToString(); if (p_SortDirection == "ASC") { this.HidSortDirection.Value = "DESC"; } else if (p_SortDirection == "DESC") { this.HidSortDirection.Value = "ASC"; } this.DaBind(e.SortExpression, p_SortDirection); } protected void gvTraderFavourable_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Del") { b_TraderFavourableInfo.Delete(Convert.ToInt32(e.CommandArgument.ToString())); this.DaBind(this.HidSortExpression.Value, this.HidSortDirection.Value); }}//this.DaBind（）方法不能放在 if (e.CommandName == "Del")方法外，否则报未激活...._Sorting(..)排序错误

Repeater 内嵌Repeater/datalist

int cityID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "CityID").ToString());

protected void rptHotel_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HiddenField hidHotelID = e.Item.FindControl("hidHotelID") as HiddenField;
            Repeater rptGuestRoom = e.Item.FindControl("rptGuestRoom") as Repeater;//找到里层的repeater对象

rptGuestRoom.DataSource = ds;
rptGuestRoom.DataBind();

}

　if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
　　　{

Repeater   rep=(Repeater)e.Item.FindControl("Repeater_VODMovies");
int   cid=int.Parse((Datalist_VODCategory.DataKeys[e.Item.ItemIndex]).ToString());
DataView   view=table;
view.RowFilter="SubCategoryID='"+cid+"'";
rep.DataSource=view;
rep.DataBind();

}

Repeater
foreach (Control c in this.rptEstablishment.Controls)
        {
            CheckBox chkEstablishmentAll = c.FindControl("chkEstablishmentAll") as CheckBox;
            if (chkEstablishmentAll != null)
            {
                if (chkEstablishmentAll.Checked)//不限不选中时
                {
                    hotelEstablishment = "";
                    break;
                }
            }

}

HOW TO：使用嵌套 Repeater 控件和 Visual C# .Net 显示分层数据
http://support.microsoft.com/kb/306154/zh-cn?spid=1108&sid=global

<mce:script language="javascript" type="text/javascript"></mce:script><asp:GridView ID="gvGallery" runat="server" AutoGenerateColumns="False" ShowFooter="true"> <Columns> <asp:TemplateField HeaderText="选择" ItemStyle-CssClass="listcheck"> <HeaderStyle Wrap="True" /> <ItemTemplate> <asp:CheckBox ID="chkid" runat="server" /><asp:HiddenField ID="hidID" runat="server" Value='<%#Eval("ImgID")%>' /> </ItemTemplate> <FooterTemplate> <input id="chkall" type="checkbox" onclick="checkAll()" />全部</FooterTemplate> </asp:TemplateField> </Columns></asp:GridView>for (int i = 0; i < gv.Rows.Count; i++){ System.Web.UI.WebControls.CheckBox chkID = gv.Rows[i].FindControl("chkID") as System.Web.UI.WebControls.CheckBox; if (chkID != null && chkID.Checked == true) { DataRow row = table.NewRow(); row["ImageID"] = ((System.Web.UI.WebControls.Label)gv.Rows[i].FindControl(lblImgID)).Text; table.Rows.Add(row); }}

子Repeater 取夫Repeater 的值

<asp:Button ID="btnDelete" runat="server" CommandName="delete" CommandArgument='<%#Eval("ID")+ "_" + DataBinder.Eval(((RepeaterItem)Container.Parent.Parent).DataItem, "Level")+"_"+DataBinder.Eval(((RepeaterItem)Container.Parent.Parent).DataItem, "TypeID")%>' OnClientClick="return confirm('确认删除吗？')" CssClass="newBtn_1" Text="删除" />