i am building my objectdatasource dynmically when certain buttons are clicked on the page.. and with that the gridview is being displayed with the results of the objectdatasource that was built.
So my gridview code looks like this:
[Code]....
How can i enable sorting and paging if the datasource is being built on button click event?
I have the following on my aspx page
[Code]....
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?
[Code]....
ObjectDataSource - Custom Gridview Paging and Sorting?
View 2 RepliesI have a Gridview that I am trying to add Paging to, however when the 2nd page is selected I get my EmptyDataText.n reviewing multiple sites and forums they have stated to send your Datatable to a Session - What am I missing here?
[Code]....
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.
[code]...
Moderators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.
1. i can use the images to indicate the sorting direction
2. I can have the custom pager like
[code]
<<Previous 1 2 3 .. 7 Next >>.
[/code]
When i click the next when i am viewing the page at 3 , the pager links should change as
[code]
<<Previous 2 3 4 .. 7 Next >>
[/code]
Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.
I want to sorting via clicking header ( kod , aciklama, yeri, are headers ) with list view component and ObjectDataSource. ObjectDataSource use komponentListesi() method for selecting. How can i sorting with use listview component.
Data Object layer
[Code]....
Data Access layer
[Code]....
Listview
[Code]....
I have a gridview being data bound by an objectdatasource which points to a BLL/DAL. I have paging and sorting enabled within the gridview. I have the fields configured in the look/fell I want from a templatefield. This templatefield has the sort expression (date) I want things to be sorted by. All this works as it should and I have no issues with it.But, the issue is that when I click on the header to sort asc/desc by date, I have to click on it twice for it switch to descending order. E.g. I hit the webpage and it lists all the information in the gridview, sorted by date, ascending order. If I want to sort by descending order, I have to click the date header twice in order for the gridview to sort the information in descending order; the clicks cause a post-back and the whole screen is refreshed.
View 2 RepliesI am having some difficulty enabling sorting on a gridview that has data in it that has come from an objectdatasource.
The AllowSorting="True" function doesnt work for ObjectDataSource so I need to find a work around...I am guessing that I will need to do something in code in order to get this off the ground.
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
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
page which is containing only single record.
<asp:ObjectDataSource ID="ODS1" runat="server"
TypeName="MyClass"
SelectCountMethod="GetDataCount"
SelectMethod="BindData"
DeleteMethod="DeleteData"
EnablePaging="true"
StartRowIndexParameterName="StartRowIndex"
MaximumRowsParameterName="MaxRowCount"
>
<DeleteParameters>
<asp:Parameter Name="ID" DbType="int" />
</DeleteParameters>
</asp:ObjectDataSource>
i want to load a usercontrol that contains a gridview with paging and sorting capabilities without postback.
Code for Load UserControl in case Dynamically is:
[Code]....
what I am trying to do;I want it so that when the user clicks on the datagrid column headers to sort the records, or when they go to page the datagrid, that a confirmation pop-up appears first, confirming that their changes are going to be lost (unless they click "Cancel").I have the confirmation pop-up scripted in Javascript and is added to the controls on the page using
[Code]....
How do I attach this to a datagrid header and to the pager?Do the columns need to be Template columns and the header text being hyperlink? If so, how do I set it up so it will, if the user clicks "OK" in the confirmation pop-up, still sort?
I am binding DataView data to GridView and using paging and sorting mechanism of the GridView.
In case of sorting, I define the sort expression based on user's selection and assign the same to DataView and then bind the same to GridView.
Issue:
Everytime I sort the DataView, I see different set of rows on the same page on GridView. The issue is, the column which is used in sorting has many rows with same values. So everytime I sort DataView using sort expression and bind it to GridView, it displays different sets of rows and sorts randomly.
What should I do to make sure that it always display same rows? I cant change the sorting expression as it is selected by the user. Or only way is to append sort expression containing unique key internally ?
I need the consistent set of rows as I am operating on rows selected by users and make them editable and allow user to udate values and display the same.
how to set paging and sorting to true in gridview
[Code]....
I need to create a dynamic gridviews with pagind ans sorting events .I tried like this
foreach (DataTable table in dsDynamic.Tables)
GridView gv = new GridView();
gv.ID = "gv" + table.TableName;
gv.SkinID = "grid";//theme for gridview.this theme has the gridview page size 5
[code]...
Am trying to use sorting and paging using a Asp.net DataList Control.....I found a Tutorial at asp.net website, but not able to understand that. I found other two links ,which exactly is of my need...but the only thing is that , it is in VB...[URL]
But Am working with C# I wanna Use Sorting & Paging For this
[Code]...
[Code]...
I am trying to sort and page a dataset/table.
Problem: it will sort and paging correctly but when after change a page, it will not display the corrected sorted order.
Protected Sub PFTGridView_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) Handles PFTGridView.PageIndexChanging
Dim PFTObj As New PFT
Dim PFTDST As New Data.DataSet
[Code]....
I have a problem with the allow paging and sorting in the gridview. I have a button to export the gridview data to excel and I need to disable the paging and sorting in code behind. When I export to excel it have the link numbers of the paging and the column header as a link to sorting. I'm using VB.
[Code]....
I don't get the paging and sorting disable.
I modified my gridview to include paging and it messed up my sorting.See a sample code below and it is not working unfortunately
[Code]...
I've reviewed a couple other sources and none seem to be complete, there is always a 'oh, ya, but you have to do this if you have this, or comments left about it not working etc... So this is my attempt to get a complete answer in one place. No datasourceControl, datasource being assigned programatically upon a button click event. My button click event that originally binds data to the gridview looks like this:
[Code]....
and of course the first code I try to implement the paging, doesn't work. Which is this:
[Code]....
the result is not an error, just an empty gridview. What am I missing? That's just an example of most of the examples out there saying how simple it is and you only need a few lines of code being wrong, or maybe not wrong, but incomplete. So I'm not going to even bother with the bidirectional sorting examples I came accross as there are usually comments about it not working, or not actually being bidirectional. I'm sure it is simple, once you actually have the information you need, getting that information is the harder part. So, anyone here care to take a shot at a complete example of implementing paging and bidirectional sorting on a gridview when not using a datasourceControl?
Would it be possible to do Sorting and Paging in a DataGrid, My dataGrid is place inside an asp:wizard which is inside an Update Panel.
[Code]....
I am using a GridView with an ObjectDataSource bound to a DataTable. I am using the GridView for displaying a report, NO editing is being done, just read only, however, I am sorting and paging. I need to turn off ViewState for the GridView to improve performance. After turning off the ViewState I start getting the error messages for both paging and sorting:The GridView 'gridView' fired event Sorting which wasn't handled.This is fine I just need to know how to implement the Sorting and Paging events correctly to leveage the ObjectDataSource. I would preffer not to remove the ObjectDataSource from use, especially if there is a way I can manually wire up the datasource correctly to continue to use the GridView as I had been when ViewState was on.Any help on getting the datasource wired up or a solution for handling the events in the context of the datasource would be great.
View 1 RepliesI was able to get the formview bound to the objectdatasource, it works great for the first record, but when i select the next record it gives me error below is all my code, if there is something else that i need to post .
[Code]....
know in asp.net 1.0 the grid display controls would pull all the data in, and then provide paging but the paging was done in memory.Are there any smarter controls that provide paging where they only pull the data relevent to current page being displayed?ie. select 10 rows for the current page, instead of doing a select of ALL the rows in the table.
View 1 Replies