gv,Repeater分页示例代码

   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

 <add name="WS2ConnString" connectionString="Data Source=./SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Warehouse2.mdf" providerName="System.Data.SqlClient"/>

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"><!-- function checkAll() { var checkall = document.getElementById("chkall"); //var grid = document.getElementById("gvGallery"); var grid = document.getElementById("<%=gvGallery.ClientID %>"); var chks = grid.getElementsByTagName("input"); if (checkall.checked == true) { for (var i = 0; i < chks.length; i++) { if (chks[i].type == "checkbox") { chks[i].checked = true; } } } else { for (var i = 0; i < chks.length; i++) { if (chks[i].type == "checkbox") { chks[i].checked = false; } } } } // --></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" οnclick="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="删除" />