Then in my code behind i have the following set up in 4+ button events, since each button serves a different purpose.. Prior to this past week, i was only working with 2 gridviews on the page.. that were linked to this datasource.. so everything was fine.. but recently had to add a Datalist to display the results a certain way.. I got it all working, but now that more records are in the table the datalist is growing in length on the page and cant figure out how to modify the current code to enable paging without having to redesign the logic all together to get it enabled.
Based on what i have below and above, is there a solution i can implement to implement paging ONLY for the Datalist? Or if it cant be specific, if enabled, will it affect the gridview that is already configured to enable paging, which already works?
I started learning LINQ, So i thought of just creating gridview with sorting and paging using objectdatasource using LINQ. So i got this link
[URL] which Brian Orrel tell us how to do using IQueryable Interface. but i have nearly 300 lines of stored procedure which joins nearly 20 tables. so i thought of creating a stored procedure and using that instead of IQuerytable.
I have read many online articles showing how to implement custom paging with stored procedure and objectdatasource control. So I know the benefits of custom paging on large result sets and I know how to implement it.
In my application, I have a stored procedure which is using ROW_NUMBER and taking parameters such as startIndex, pageSize etc. I also have method in my DAL who call this stored procedure and on my page I have GridView and ObjectDataSource control and they are calling DAL methods and everything is working perfectly fine.
Now I want to implement GridView paging without ObjectDataSource control by calling the DAL methods manually. I dont want to use ObjectDataSource control because I need manual access to the DataTable my DAL methods return which I think I dont have if I use ObjectDataSource control.
how to implement paging without ObjectDataSource control
<ev_event> objev_event = new List<ev_event>(); GridView1.DataSource = objev_event.ToList(); GridView1.DataBind();
I want to enable paging for the Gridview. when I enable True for Enable paging property, The error throws.how to enable the paging for list binded GridView?
I have a need to add a new report to my page, the differnent parts of the page are all using a objectdatasource to populate the data. The new report because of all the data being returned i have started to use a repeater and a table in the ItemTemplate. Just binding the objectdatasource to the repeater works fine, but returns all the records and causes the page to be very long. I found this link for adding paging to repeater, but its setup different than what i have
[URL]
Is there any way to use what i have already and add paging to the repeater?
I am trying to experiment with things as a beginner and want to use paging in Repeater Control. Since Repeater control is light weight, I want to use that. I have heard of two methods: PagedDataSource class and the other that I dont remember. I wanted to attempt both of them. How do I proceed?
I have a strange problem. I have made a PagedRepeater control, which inherits from the Repeater, from a tutorial I saw here: http://www.4guysfromrolla.com/articles/020905-1.aspx. It's in VB and I'm in C#, and it didn't quite have all the features I was lookingfor, so, I've modified it quite a bit. I added support for a SqlDataSource control, as well. The only problem is, that it always returns the first item from the SqlDataSource, even when the CurrentPageIndex on the PagedDataSource is set to a different value.
I am using a custom membership provider. I needed to bind a repeater to a membershipusercollection but the only way I could think of was this:
There is no method to return a lcollection of membership users by userid. I basically have a friends table with a userid and a frienduserid field. both are foreign keys to the user table. So say I am userid 1 and I have two friends userid 2 and userid 3.
I needed to get a collection of membership users who are my friends (user 2 and 3)
So I did this:
Code: Dim lstAccountIDs As List(Of Integer) = bl.GetFriendsAccountByUserID(iUser) Dim mUsers As New MembershipUserCollection For Each a In lstAccountIDs mUsers.Add(Membership.GetUser(a)) Next
I get their id's and add them to to list(of Integer) then I loop through the list and get the particular user by id and add them to a membershipusercollection object.
I now need to add paging to my repeater control that uses that collection as a datasource. However the membership provider doesn't give me the ability to specify a pageindex or pagesize etc. It gives me those options in the GetAllUsers function but I need it to work in the above scenario.
I'm trying to link 2 objectdatasource together using the Control Parameter Source.However, I'm stuck at the screenshot below. The Next button is disabled.
I have a page where you can search and display other data, very simple layout. 1 Gridview and 1 objectdatasource. But i have 4 possible buttons that can populate the gridview..
i would like to control my objectdatasource from the code behind based on the button you click.
here is what i have right now.. but if possible, can this source not be hardcoded like this and only built in the code behind?
[Code]....
I found this site with a solution to this persons issue, but i cant seem to get mine working this way.
I have this as the code behind right now when you press the button.. what other parameter settings am i missing and is this the right order to populate them for the source to acknowledge my values?
I've got a repeater control containing comments. I'm about to implement ajax paging to it. I was opting to use the updatepanel (conditionally) for this thing, but I guess it's going to get kinda slow in production environment (Each time about 20 rows will be visible). I want to keep the repeater control since it contains other controls as well so I can't use a js (templates)/json approach.
I am using ObjectDataSource controll to bind gridview and using custom paging. Everything working fine but the problem arises when last page contains only one record and i try to delete it-- gridview disappear.
Below is ObjectDataSource declaration..It is working fine..only problem is with deleting from last
I am using a form view control which has two binded textbox. Now at this level it works fine and the textboxes show the values from database. But when i insert a panel inside the form view and move these two textboxes inside the panel, they dont show any values. What could be the reason for this?
I have a Custom Repeater control that inherits from Repeater and has paging functionality, however when I click the next page button the first time it refreshes the control but does not change the page, if I click it again after that it changes page perfectly. I know what the issue is, when I click the next button it does a postback, then the data is bound to the repeater, and then after that the NextButton Event is handled.
Is there any way I can change the order of the page load events?? Or force the repeater to reload again after the event is handled?? I've included my Custom Repeater class bellow:
using System.Web.UI.WebControls; using System.Web.UI; using System.Data; using System.Collections; using System; namespace ASPresentation.Controls { [ToolboxData("<cc:PagedRepeater runat=server></cc:PagedRepeater>")] public class PagedRepeater : Repeater { public int PageSize { get; set; } public int CurrentPageIndex { get { return Convert.ToInt16(Page.Session["ProjectIndex"]); } set { Page.Session.Add("ProjectIndex", value); } } public PagedDataSource pagedData = new PagedDataSource(); LinkButton NextBtn = new LinkButton(); LinkButton PrevBtn = new LinkButton(); public bool IsLastPage { get { return pagedData.IsLastPage; } } public bool IsFirstPage { get { return pagedData.IsFirstPage; } } public override object DataSource { get { return base.DataSource; } set { pagedData.DataSource = (IEnumerable)value; } } protected void NextButtonClick(object sender, EventArgs e) { if (!IsLastPage) { CurrentPageIndex++; } } protected void PrevButtonClick(object sender, EventArgs e) { if (!IsFirstPage) { CurrentPageIndex--; } } protected override void OnInit(EventArgs e) { base.OnInit(e); NextBtn.Text = "Next"; PrevBtn.Text = "Prev"; NextBtn.Click += new EventHandler(NextButtonClick); PrevBtn.Click += new EventHandler(PrevButtonClick); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); base.Controls.Add(PrevBtn); base.Controls.Add(NextBtn); } protected override void Render(HtmlTextWriter writer) { base.Render(writer); } public override void DataBind() { pagedData.AllowPaging = true; pagedData.PageSize = PageSize; pagedData.CurrentPageIndex = CurrentPageIndex; base.DataSource = pagedData; base.DataBind(); } } }
URL... I'm trying this approach and I like it, It is what i was finding. customize the function he wrote to populate the pager control:
private void PopulatePager(int recordCount, int currentPage) { double dblPageCount = (double)((decimal)recordCount / Convert.ToDecimal(PageSize)); int pageCount = (int)Math.Ceiling(dblPageCount); List<ListItem> pages = new List<ListItem>(); if (pageCount > 0)
[code]...
I need the paginator is something like that:<FIRST><BACK>1,2,3....N<NEXT><LAST>where first return back to first page, back go to previous current page, next for next page and last jump to last page.How can I do that?