Forms Data Controls :: GridView Sort Not Working?
Oct 8, 2010
I'm a newbie to .NET, so the solution might be really trivial. I have a database, I have an Entity Data Model, I add in my Index.aspx page an EntitryDataSource and a GridView. I connect them and everything works fine (the data is displayed as expected). The problem is that clicking on the coulmn name or on the pagination lists doesnt do a thing... Although I did set the properties AllowSorting="True" and AllowPaging="True". I also tried with another datasource type (SqlDataSource) and the same problem.
View 2 Replies
Similar Messages:
Nov 1, 2010
I'm developing a bilingual web site, and therefore, I'm changing the text of the headings and the select buttons of my gridviews. I just discovered that if I set some code like below in the rowdatabound event of the gridview, the "linkbuttonish" headings get replaced by unclickable text. Thus, sorting the gridview is suddenly not working. What should I write instead?
If Session("lang") = "en" Then
If e.Row.RowType = DataControlRowType.Header Then
e.Row.Cells("name").Text = "Given name"
End If
End If
I guess that I should write something else than "e.Row.Cells("name").Text" to still have the click-behaviour, but I don't know what. The same question arises for the select linkbutton in a cell of the gridview's datarows.
View 2 Replies
Sep 23, 2010
Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.
I have 1 Gridview that displays 10 different scenarios based on what button is clicked.
I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.
I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.
I tried this:
Tried setting gridview1.sqldatasourceid = null; gridview1.allowsorting = false; gridview1.databind();
Here I get an error that says that the data source does not support sorting? Doesnt it say gridview1.allowsorting = false;
I also tried gridview1.sort("", SortDirection.Ascending); This does nothin... except query my database one more time because i have a onSorting event that looks like this:
[Code]....
Here is an example of just one of those SLQ statements inside GetSQLQuery:
[Code]....
View 1 Replies
Nov 2, 2010
I'm developing a bilingual web site, and therefore, I'm changing the text of the headings and the select buttons of my gridviews. I just discovered that if I set some code like below in the rowdatabound event of the gridview, the "linkbuttonish" headings get replaced by unclickable text. In another thread, I was told to change
If Session("lang") = "en" Then
If e.Row.RowType = DataControlRowType.Header Then
e.Row.Cells("name").Text = "Given name"[cod]...
in the myGV_DataBound sub.This works well, but not everywhere. A few gridviews are populated from codebehind, and this is where things go wrong. What happens is that - nothing happens (it's still the original heading). I added a Watch, but once the HeaderText property changed, the Watch never yielded another result, but stayed with the new value.
Now I suspect that even though the HeaderText property has changed, this doesn't get reflected in the GV when populated from codebehind.
I guess that I should write something else than "e.Row.Cells("name").Text" to still have the click-behaviour, but I don't know what.
The same question arises for the select linkbutton in a cell of the gridview's datarows.
View 2 Replies
Jan 15, 2010
I have a Listview control that DataBind programatically... ie I am NOT using SqlDataSource or such... I am attempting to sort a column... clicking on a link button that fires the "Sorting" event. So, after cliking on the column heading... I end up in this routine, where I hardcoded the .Sort = values (just for testing). The code is executed... but the RESULT show via Listview remains the SAME. No change!
How to fix this? I've seen some other posts examples that uses this event (ListView1_Sorting) and then sort via LINQ. I am not ready to try that...
Just want to know why dsPaymentList.Tables[0].DefaultView.Sort does not work?
I followed the example at: [URL]
protected void ListView1_Sorting(object sender, ListViewSortEventArgs e)
{
string sortExpression = e.SortExpression + " " + e.SortDirection;
DataSet dsPaymentList = new DataSet();
[Code]....
View 3 Replies
Feb 16, 2012
My Gridview sort is working only first time. My Gridview sort only first time when I click on any column
I want ASC > DESC
Again DESC > ASC
and Again ASC > DESC this way my sort should work
I have changed my code
I added Gridview binding to PAge_Load function
Code is below
Public Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myUserInfo As GCS_User_Info = Session("UI")
If Not Page.IsPostBack Then
GRDView.DataSource = GetSortableData(String.Empty) 'System.Drawing.FontFamily.Families
GRDView.DataBind()
[Code] ....
View 1 Replies
Apr 1, 2011
My Grid is bound to a collection type datasource. When I try to sort the Columns in the Grid I get Javascript error saying sorting event not implemented. Why is the default inbuilt sort functionality not working which worked fine when I directly used a sqlDataSource using smart tag. Do I have to write some code to achieve sorting ?
View 1 Replies
Jun 3, 2010
I have a simple dynamic gridview with following code -
GV = new GridView();
View 3 Replies
Jan 18, 2011
I have a gridview with data. I want a button which is not part of the gridview. Then if I press a button the gridview is sorted by two colums. i.e column1 ascending column2 descending.
I am not looking to work with a Sqldatasource as I use a data access layer. So the sort would have to be from a datatable and databind or directly with the gridview.
View 3 Replies
Feb 28, 2010
i read Matt Berseth article also i downloaded this source. But i can not do sorting event. Everything is ok but sorting is not working.
[Code]....
View 3 Replies
Jun 20, 2010
I want to create simple rating page where player's place,name and rating is displayed. I've created database with ID,Name and Rating Columns, binded Gridview to this database and created TemplateField "Place". With following code I've created numbered list for Place:
protected void Page_Load(object sender, EventArgs e){
for (int i = 0; i < GridView1.Rows.Count; i++)
View 4 Replies
Feb 2, 2011
I have 12 columns in a grid i want sort 3 of them when user clicks on Header, how can i do this.
U want these columns to be sort WOnumber,DD,PO.
View 1 Replies
Oct 1, 2010
[Code]....
Gridview does not sort on gvClaimDetails_Sorting
View 6 Replies
Mar 9, 2010
i am having a gridview in which all columns get dynamically added, i applied sorting in it, all column added as boundcolumn get sort properly but two column which are added as templated column do'nt get sort. Though my dataview have these column as it is.
View 2 Replies
Mar 14, 2011
i have the following code . .
[Code]....
i need to sort according to Due_By i mean most recent one shpuld come first . .
View 8 Replies
Mar 24, 2011
I am using gridview created by visual components. I have registered gridview_onsortclick event during the page initialisation, but when i try to click on the header of any column, this event does not get fired at that time. This event gets fired only after all the controls, sorting query is generated, filling the current dataset is done. But the same event is getting fired before query is generated and dataset is filled,for the other page. And one more thing to add with it, I want the sort function to be done on the whole dataset regardless of current page. Why is there such a difference in both the pages?
View 2 Replies
May 25, 2010
Is there a way to Sort a Gridview by a Calculated Column? I have a gridview with template fields using lablels and a linq datasource. Those columns sort just fine. I can not get the Calculated column to sort, because there is no sort expression to use...
View 4 Replies
Apr 22, 2010
I have the following sorting code that works find when clicking on a column header in a gridview.
Now, I'd like to fire this sorted table & fire it on load instead of having the user have to click a column heading.
how to do that?
Here's my code:
[Code]....
View 3 Replies
Jan 6, 2011
I have a gridview column named "Job Number" and the number is in this format: 01-04-11-3215, 01-04-11-3216 and so on...
Since the first few characters represent the date I need to sort on the last 4 digits.
View 2 Replies
Dec 7, 2010
i want to sort the datagrid(gridview) programatically.
View 4 Replies
Mar 22, 2010
I have a datatable as a datasource to a grid view, it has a column amtDue, i would like to be able to sort by this column,, while not displaying it.
View 4 Replies
Jul 1, 2010
I have a manually binded gridview, which I set AutoGenerateColumns=False. I then tried to set AllowSorting=true at runtime, but it wont work.
My gridview are created during runtime.
View 5 Replies
Apr 20, 2010
I'm using asp.net 2 and would like to add sort direction arrows to GridView column headers.Please could someone point me to a soluton, VB.Net if possible.
View 3 Replies
Mar 12, 2010
Tried several different ways to do this but am just not seeing it. Proably a quick solution for someone more skilled than me.
I have a gridview generated from a datatable. One of the columns is "client name" whose data is generated from a class.
I added a link button for the column header that fires a sub that should sort the datagrid, but is not.
Here is the code I have so far that creates the gridview which works fine:
Private Sub PopulateCaseListGrid()
'Kill the existing DataSource, in case of a page reload
gvCaseList.DataSource = Nothing
'Create a datatable with whatever column you want to use
[Code]....
View 12 Replies
Mar 15, 2010
I have a GridView and Formview attached to the same ObjectDataSource.
Everything is working ok so far.
If I enter new search criteria and click "Search", both the GridView and FormView rebind properly to the ObjectDataSource results. And I am able to page through the FormView records and they match the GridView records above.
When I click a sort link in the GridView, the ObjectDataSource returns the correct results based on the header link's commandName of 'Sort' and the CommandArg of 'SortExpression'.
The only thing wrong now is on the sort, the formview records do not reflect the reversing of the sorted record order. If I page through the FormView the records remain in the same order.
Why does the FormView not recognize the ObjectDataSource's changed results on the sort post back (even if it is only the sortExpression parameter of my ODS select method).
How do I get the FormView to rebind to the new ODS result set? I have called formview.DataBind() from every event I can think of. That does not seem to work either.
View 6 Replies
