DataTable.DefaultView.Sort Doesn't Seem To Be Working?

Feb 19, 2010

I populate a DataTable, then sort the DefaultView of that DataTable. When I set the DataTable as the source for my report, the sort doesn't work. here is the code (GetData returns a valid DataTable):

Dim dt As DataTable = a.GetData(Parm1, Parm2, Parm3)
If rbtSortByField1.Checked Then
dt.DefaultView.Sort = "Field1 ASC"
ElseIf rbtSortByField2.Checked Then
dt.DefaultView.Sort = "Field2 ASC"
ElseIf rbtSortByField3.Checked Then
dt.DefaultView.Sort = "Field3 ASC"
End If
rpt.SetDataSource(dt.DefaultView.Table)
'This also doesn't work
'rpt.SetDataSource(dt)

View 1 Replies


Similar Messages:

Web Forms :: Sort Datatable Without DefaultView.Sort?

Apr 20, 2010

I'm looking for a way to sort the rows of a datatable without setting the DefaultView.Sort to a specific column. I have a datatable in session that users can add records to. I want them to be able to sort the data by clicking on a button. But new records added after that need to show up at the bottom of the list until the sort button is clicked again.

View 2 Replies

Forms Data Controls :: Listview Dataset Tables[0] DefaultView Sort Not Working?

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

DataSource Controls :: Datatable Defaultview On Unique Date?

Jun 8, 2010

I have a datatable and I want to have a view on it with unique dates. The thing is that I want the date to be unique if the year,month and day are the same, I dont care for the exact time.

I now have:

Dim dtUniqueDates As System.Data.DataTable
dtUniqueDates = dt.DefaultView.ToTable(True, "updatedate")

So in this case 12 february 2011 13:54 is different from 12 february 2011 15:54. But since year,month and day are the same I want them to be unique.

View 1 Replies

Sort An Unbound Datatable?

Jul 2, 2010

Is it possible that once I have created a datatable programatically, I can then sort that datatable before binding it to a asp:repeater? I have a number of records that I have to get from a com object that has not been eliminated. The com object populates an array, then I loop through the array to pull data from my datatbase, adding the db data to the datatable. Then I bind the datatable to a repeater.

1) the array is multidimensional
2) The COM object doesn't sort the data by company ID (which is what I need to do)

View 3 Replies

How To Sort The Data In Column Of Datatable

Feb 26, 2010

how can i sort the data in col of datatable or other way to sort

View 7 Replies

DataSource Controls :: Sort By Col. In Datatable?

Feb 23, 2010

I have seq no col in the datatable.how can i order by the seq no so that re-arrage the datatable.or other method have the sort function.and then bind to repeater.

View 3 Replies

C# - Way To Sort GridView Bound To DataTable

Jul 13, 2010

I have a repository that contains all of my LINQ queries for this project that I am working on. I am able to get the LINQ results to a DataTable and bind that to a gridview for displaying the data. Now I need to make the gridview sortable. I have set AllowSorting="true" and I have the OnSort event handled in a routine in the codebehind.

View 2 Replies

Creating A Sort Expressions For Datatable In Vb.net?

Feb 2, 2010

I have got a datatable which contains many columns in which three are main:

hotelid
dshotelid
hotelname

Some hotels contain only dshotelid, some contains only hotelid and some contain both dshotelid and hotelid.

I need sort in such way so that those hotels who got both dshotelid and hotelid should be on top and then those hotels who have got only dshotelid and at last those hotels who have got only hotelid...

I created this :

dtmaintable.DefaultView.Sort = "dshotelid, hotelid"

but it Is not giving me desired output.

View 2 Replies

Sort The Datatable After Binding The Dataset?

Apr 16, 2010

How to Sort The datatable in asp.net. after binding the dataset values i have stored into one table how can i sort the values of the dataset in asp.net with C#

View 4 Replies

DataSource Controls :: Trying To Sort A DataTable, And Not Always Succeeding?

Apr 27, 2010

I am trying to sort a DataTable. If I declare a DataView and use the following approach it works perfectly:

Dim dt As DataTable = getData()
Dim dv2 As New DataView(dt)
dv2.Sort = "surname, name"
dt = dv2.ToTable

I wanted to do this without using a DataView though if possible to reduce the impact on resources. I tried the following approach but it doesn't work. I might be writing the code wrong so

Dim dt As DataTable = getData()
dt.DefaultView.Sort = "surname, name"

View 3 Replies

DataSource Controls :: Datatable Sort In A Particular Order?

Oct 22, 2010

How do I sort a data table based on a particular column which has integer values in ascending order?

I wrote this:

leadtable.DefaultView.Sort = "Id"

But it doesnt seem to work, it displays fine but when i get try to get the values of the sorted datatable in an array they dont come in an sorted ordere Datatble is defined as:view plaincopy to clipboardprint?

View 3 Replies

Web Forms :: Sort Datatable Does Not Work Properly?

Mar 15, 2010

now i use the dataview to sort the seq of datatable and bind to repeater, it can only display the seq correctly.but i found that it is not the actual database seq, when i remove the row from the datatable, it is not remove the record that i see from the UI.do i need to sort the seq to the actual datatable not the dataview.now i use the seq (int) in datatable to sort the datatable as belows:

DataView view = dt.DefaultView;
view.Sort = "SEQ";
repeater.datasource=view;
repeater.databind();

View 4 Replies

DataSource Controls :: DataTable.select() Wrong Sort?

Feb 11, 2010

I have a little problem with a DataTable.

[Code]....

The values are number but varchar, for example '100', '73', '87'. When i see the data this return 100, 87, 73, when should by 73, 87, 100 how can i sort the data????

View 2 Replies

Data Controls :: How To Sort DataTable Before Binding To GridView

May 7, 2015

sorting of datatable and bind it to grid view

View 1 Replies

Forms Data Controls :: Sort Gridview Generated From Datatable?

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

Sort Datatable / Dataview / Gridview Of Files Based On File Modified Date?

Aug 2, 2010

I have a page which lists all the files in a particular folder (all PDFs), using a data-table and gridview.

I'm currently sorting this table by the filename (by using a dataview), which isn't that helpful, and I want the gridview of files sorted by the file created or file modified date (as recorded in Windows).

If that's not possible, a second option would be to extract the date from the file name string (no problem doing that), and sort the dataview/datatable or gridview based on that. Example Filename: DailySalesReport-1-15-2010. My only hangup with this is how do I sort on date, when it's a string value? Convert to date? How would I sort the whole dataset based on this converted value?

[Code]....

View 2 Replies

Data Controls :: Sort DataTable Rows / Order By Date And Populate GridView

Aug 18, 2015

I want to orderby the list. Today date is on the top and then next date and all dates but when today date is passed then it comes on the end of the list. Is there any formal query in linq or some other code is used to achieve this?

08/01/2015
09/01/2015

but when today is passed then it automatically go to end and next today date is on the top

View 1 Replies

Web Forms :: The Control Doesn't Remember The Last Sort Direction?

Mar 2, 2011

Asp.net.3.5 gridview on sorting problem The control not remember the last sort direction on the source side

AllowSorting="True"

EnableViewState="true"

on the server event

[Code]....

View 2 Replies

AJAX :: Gridview.Sort Doesn't Work In UpdatePanel

Dec 5, 2010

I have a GridView in an UpdatePanel and in the code behind I bind to a Datatable and call the GridView's Sort method:

gvUsers.DataSource = dt;
gvUsers.DataBind();
gvUsers.Sort("DateOfBirth", SortDirection.Descending);

However, this doesn't sort the records. I have the Sort event as an asynch trigger for the grid.

View 4 Replies

Data Controls :: Sort DataTable Rows In Ascending Or Descending Order Based On DateTime

Apr 28, 2013

I have a datatable,columns are(User_id,Name,Address,DOB)

values like(12,abc,delhi,22/2/2000)

(14,pqr,mumbai,13/3/1989)

(8,klm,banglore,17/5/2001)

(9,asd,pune,12/9/1999)

Now I want to sort these rows on DOB in descending order..how can i do so?

View 1 Replies

Forms Data Controls :: Gridview Doesn't Sort On A Specific Column After Updating

May 10, 2010

I have been struggling with this problem for a long time. Does anyone have any clue about this problem? I created a gridview and set the allowsorting to true. This gridview has four columns: Name, Position, StartDate, and EndDate. I want the gridview to be sorted on the EndDate.

Inside of the save event, I called the BindGrid() function to rebind the datasource to the gridview. The changes will shown immediately, but the problem is that the records are not sorting on EndDate. I have to refresh the page manually to get the view sorted.

<asp:GridView ID="gvInfos" runat="server"
CheckBoxEnabled = "true"
ShowEmptyTable = "true"
AutoGenerateColumns = "False"
CssClass = "gv_white"
DataKeyNames = "Id"
GridLines = "None"
Width = "100%"
AllowSorting = "true"
>
<Columns>
<asp:ButtonField CommandName="Select" DataTextField="Name" HeaderText="Name" />
<asp:BoundField DataField="Position" HeaderText="Position" />
<asp:BoundField DataField="StartDate" HeaderText="Start Date"
DataFormatString="{0:Y}" />
<asp:TemplateField HeaderText="End Date" SortExpression="EndDate">
<ItemTemplate>
<%# (((DateTime)Eval("EndDate")).Year == (DateTime.MaxValue.Year) || (DateTime)Eval("EndDate") == null) ? "Present" : ((DateTime)Eval("EndDate")).ToString("y")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

View 11 Replies

Forms Data Controls :: Gridview Sorting Function Doesn't Sort Correct In Sequence 1,2 3, 3 But 1,10,100?

Mar 31, 2010

the datatype in my database is Varchar, so that my gridview Sorting Function doesn't sort correct in sequence 1,2 3, 3 but 1,10,100, how can I sort in sequence 1,2,3,4 but no changing the datatype in database?

View 2 Replies

Custom Sort In ASPXGridView Not Working With Paging?

Nov 2, 2010

I've implemented a custom sort for a aspxgridview, following the steps mentioned here: [URL]

However, I've noticed that it only sorts the current active page, so whenever I go to another page I have to click again on the column to sort it.

Is this behavior correct, or am I missing something? How can I solve it?

PS: I thought about capturing the PageIndexChanged event and manually sort the active page, but that seems too hackish...

View 3 Replies

Web Forms :: GridView Sort Is Working Only First Time

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







Copyrights 2005-15 www.BigResource.com, All rights reserved