Search results matching tag 'Sort'

Narrowing Dropdownlist contents

aneasytorememberid — Sun, 08 Nov 2009 05:00:00 GMT

I have a dropdownlist which is databound to a DB call depending on other form parameters. I need to have a textbox with a narrrow button which will take the user to a partial match in the dropdownlist. For eg. If the user enters "Joh" the dropdownlist should go to the first selected name with "joh". How do I do this?

The best way to sort xml and bind it

pierremesso — Wed, 15 Jul 2009 04:00:00 GMT

Hi,

I'm having trouble finding out the best way for my solution. Here's what I want to do:

Read an XML containing books with info. I then want to sort that xml. Finally I want to present the result somehow, maybe bind it to a repeater or something and beside each book title I want to have a checkbox.

Only the Title for the books will be visible in the presentation but I need to store all the information about each checked book in a database when the client submits the form.

I've tried several ways but I can't get it all together. Anyone that have a guideline for the best way to solve this?

Best regards,

Pierre

How to Sort custom data inside GridView TemplateField?

MinimalTech — Thu, 14 May 2009 04:00:00 GMT

Hello there!

I have a problem with my GridView Control. In my aspx page, i have a GridView1 with columns:

<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:TemplateField HeaderText="CustomWord">    
	<ItemTemplate>
		<asp:Label ID="lblWord" runat="server" Text=""></asp:Label>
	</ItemTemplate>
</asp:TemplateField>

The 'Name' column gets the data from the GridView1's SqlDataSource. Sorting is working well at that point.

BUT,

The 'lblWord' label of the 'CustomWord' column, gets the data from the custom-made function 'makeWord()' in the GridView1_RowDataBound() Event.

The 'makeWord()' function generates a string by adding and reading different variables....

HOW can i enable sort for the 'CustomWord' column? The GridView1's SqlDataSource does not have any relationship with 'makeWord()' function...

The 'makeWord()' function does not includes any DataSource....

Please, help! I have read a lot of articles inside and outside of forums.asp.net but i can't find the answer...

how to sort record by date

indianmaestro — Thu, 19 Feb 2009 05:00:00 GMT

Hi friend,

I would like to sort my records by Date and fill then in datagrid. while adding them i am converting the date format to System.DateTime.Now.ToString("dd/MM/yyyy HH:mm");

but when i am selecting the record with this query

strquery = "select * from Clients order by date desc" the records r sorted by date but notby month , becoze the date is fiest and monthe is second and year is third in the Sql server data base.

how can i get the record sorted by month. I want the latest record first

How to do 2 sorts in the same arraylist.

PascalCmoa — Tue, 03 Feb 2009 05:00:00 GMT

Hi every body

I created a class to sort an arraylist that i used to bind a GridView. In this case i have no problems, in this case i sort my arraylist with the id_user.

But i don't know how sort this same arraylist with id_user and date, in fact i want te realized a sort with the id_user in the first sort and after with the date, 2 sorts in my arraylist. But i don't know how to do that.

You may see my class below:

Public Class trieur
    Public Function Compare(ByVal x As Object, ByVal y As Object) As Integer Implements System.Collections.IComparer.Compare
        Dim valeurX As modif = CType(x, modif)
        Dim valeurY As modif = CType(y, modif)
        Select Case valeurX.id_User- valeurY.id_User
            Case Is > 0
                Return 1
            Case Is = 0
                Return 0
            Case Else
                Return -1
        End Select

    End Function
End Class

Dynamic Data Entity Framework: Initial Sort Order

BHunsaker — Sun, 18 Jan 2009 05:00:00 GMT

Dynamic Data 3.5 SP1

For just one of my Dynamic Data Entities tables I would like to control the order of the displayed records, specifically I would like to order a date column descending.

The (SQL Server) table is named "EventLog" with a column "datLocalTimestamp" of type DateTime.

In my "meta" .cs file, I have tried adding the following:

[MetadataType(typeof(EventLogMetaData)), DisplayColumn("datLocalTimestamp", "datLocalTimestamp", true)]

public partial class EventLog

{

}

This did nothing. Next, I tried adding a IComparer class:

internal class EventLogCompare : IComparer<EventLog>

{

    public int Compare( EventLog logA, EventLog logB )

    {

        return DateTime.Compare( logB.datLocalTimestamp, logA.datLocalTimestamp);

    }

}

I put a breakpoint on the Compare method but it is never invoked.

Do I need to modify the Page_Load event in the ListDetails.aspx.cs page template file? That doesn't seem like the way to go for a single table...

Thanks for your help.

Default sorting with descending order

Balyk — Tue, 25 Nov 2008 05:00:00 GMT

I have some table with Date column. I want to have default sorting on my Date column with descending order that rows with last date wil be on the top. I have a LINQ to SQL DataSource. I have attempted to use OrderByParameters, but I can't make descending order on my column. Which the best way to resolve my problem? May be there is some way in Dynamic Data framework not in DataSource. How can I intercept creating Select command to database?

Setting initial sort order

smhontz — Tue, 19 Aug 2008 04:00:00 GMT

I'm using Dynamic Data 3.5 SP1. I have two questions on setting the initial sort order for Gridviews displaying data from the LINQ data source.

1. Is there a way to impose my own sort order on the table gridviews that dynamic data is automatically generating? Is there some attribute I can set in the partial class, or do I have to make a custom page?

2. I have some stored procedures that I dragged into the ORM designer. I created a new page, put a gridview for each procedure on it (it's a summary page, designed to show just a few rows from selected tables.) In the code-behind, I set the Page_Load code like this:

MyDataContext dc = new MyDataContext();

FirstGridview.DataSource = dc.spMyFirstProc();

FirstGridView.DataBind();

Is there some way for me to force the sort order of the grid view here, too?

Are these more LINQ questions, rather than Dynamic Data? I'm pretty new to both.

Re: File Object

igor.p — Mon, 18 Aug 2008 04:00:00 GMT

Hello,

Yes, the code as you have it will not work. You need to sort the collection before you write the information. You can create a custom Comparer (by implementing IComparer interface -- see http://msdn.microsoft.com/en-us/library/system.collections.icomparer.aspx), add the items to an ArrayList, sort it and then render the file information.

I have a question for you. How come you're using Server.CreateObject?

I hope this helps.

How to sort the gridview with custom queries

Sal — Sun, 10 Aug 2008 04:00:00 GMT

I have a gridview databound to an access database. I am allowing users to select the individual letters of the alphabet with individual link buttons (A,B,C...) (I know, this is not the best way to do this but it's what I have for now.) to return the employees whose last name starts with that particular letter. The problem is when I attempt to sort the names, the gridview goes blank. Other than that , the thing works fine. From my understanding, when doing any sorting the page does a post back so I'm thinking the select statment goes blank or null when the postback occurs. Does anybody have any suggestions on how to solve this? Some ideas I have which may not be correct or possible are:

1.) retrieve the last query, (but how?)
2.) bind the returned data to the gridview (but how?)
3.) will viewstate do it?
4.) some other .net framework feature work?

Thanks,

Sal