How to sort the dataset Values in Descending order , I have Followed the following way
decimal Length = 94;
decimal Width = 7;
decimal Height = 13;
DataTable dtCarton = new DataTable();
[Code]....
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?
I have a column of type varchar that lists the values in this format:
SEP-09
SEP-08
OCT-09
OCT-08
NOV-09
NOV-08
MAY-09
MAR-09
JUN-09
JUL-09
JAN-10
JAN-09
I need to sort this list by descending order treated as actual date. I tried converting it to date and then tried to extract the year and month out but I keep receiving conversion errors. Does anyone know how to get this in the descending order to it shows up like this:
JAN-10
NOV-09
OCT-09
SEP-09
JUL-09
NOV-08
OCT-08
SEP-08
JUN-09
MAY-09
MAR-09
JAN-09
This is the closest I got but it keeps sorting the list alphabetically:
select distinct periodname, Convert(varchar,periodname,112) from periodtableorder by Convert(varchar,periodname,112) desc
How do I sort a data table based on a particular column which has integer values in ascending order?
I wrote this:
'Sort the datatable based on sequence id leadtable.DefaultView.Sort ="Id" But it doesnt seem to work Datatble is defined as:
[Code]....
I want to sort by IsTop ascending, meanwhile then by jobId descending
query = query.OrderBy(p => p.IsTop).ThenOrderByDescending(p => p.JobId);
how to do it? I know the reverse
query = query.OrderByDescending(p => p.IsTop).ThenBy(p=>p.JobId)
syntax works, but not what i want What i want is actually whatever situation IsToped Item will be at top!
I want to write a LINQ to Entity query which does order by ascending or descending based on input parameter, Is there any way for that. Following is the my code.
public List<Hosters_HostingProviderDetail> GetPendingApproval(SortOrder sortOrder)
{
List<Hosters_HostingProviderDetail> returnList = new List<Hosters_HostingProviderDetail>();
int pendingStateId = Convert.ToInt32(State.Pending);
//If the sort order is ascending
if (sortOrder == SortOrder.ASC)
{
var hosters = from e in context.Hosters_HostingProviderDetail
where e.ActiveStatusID == pendingStateId
orderby e.HostingProviderName ascending
select e;
returnList = hosters.ToList<Hosters_HostingProviderDetail>();
return returnList;
}
else
{
var hosters = from e in context.Hosters_HostingProviderDetail
where e.StateID == pendingStateId
orderby e.HostingProviderName descending
select e;
returnList = hosters.ToList<Hosters_HostingProviderDetail>();
return returnList;
}
}
I have a stored proc which returns months year in nice words, but having problem ordering them:
SELECT count(id) as counter, datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate) as date
from BLG_BlogPost where active=1 group by datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate)
And that returns:
April 2009 (8)
August 2009 (3)
February 2009 (2)
How can i order them?
i m using asp.net 2005 with access 2003. i need a code using vb.
how can i sort the record in descending order?
Order by descending is not working on LINQ to Entity In the following Query In place of ascending If I keep descending it is not working.
[code]....
I need to retrieve and display directory files in descending order. For example:
file-02_01_2010.txt should display before file-01_01_2010.
I am using DirectoryInfo.getfile(searchPattern) but that will return files in random order (or maybe ascending order, I am not sure). Is there a way to specify the order in which I need files to be returned? I know I can load them into an array, sort them, etc., etc., but is there any cleaner way?
I have a button that I would like to click and will put my Listview list in Descending order. However; when I click on the button nothing happens.
[code].....
In my table I have a varchar type column, the values like..
sale_date
04/23/2010
02/03/2010
12/24/2010
I need to retrieve the records in both ascending and descending order. Problem is now it is a varchar type if I use order by o/p like
02/03/2010
04/23/2010
12/24/2010
I tried with convert(DATETIME,sale_date) but no use.
I am a bit confused how to say this but here goes.I have a sql server 2008 database tablewhere I want to select rows by descending order of a [column name] and then select first 10 rows from that output.I was trying something like select top 5 * from (select * from movie_data order by hits DESC);this does not work and I'm quite new to query-writing.
View 2 RepliesI am using dropdownlist to select whether the gridview should be filled by data arranged in ascending order or descending order with Gridview Paging. The problem i am encountering is that when i fill the data in ascending order it works fine but when i arrange the data in descending order the first page loads fine but the other pages are not filled properly in paging.
View 1 RepliesI try to sort a dictionary with no success
this code i wrote
var sortedDict = _GrandTotalUserDictionary.OrderBy(key => key.Value.Priority);
the dictionary looks like
"key1", new OrderItem(){title:'a', priority:1}
"key2", new OrderItem(){title:'b', priority:3}
"key3",
new OrderItem(){title:'c', priority:12}
If I have a specific order that I want to sort my List by, how do I do that? For instance, I have a list of items (coming from a database), with ID's ... and they come in order, i.e 1, 2, 3, 4. After receiving this list, I'd like to reorder the list above based on a specific order, e.g. 2, 4, 1, 3. How do I do this without complicate it too much?
View 11 RepliesI have 2 tables with a relationship by EmployeeID (Employee, Cases)
The relationship name is Purchases (ie employee->Purchases), and iterating through it gives each row in order by date (entry order perhaps?).
There could be thousands of rows, so I want to present this collection in reverse date order.
Would I have to define a provider or repository to call instead of just Employee->Purchases?
I am wondering if the aspnet_Users table is always sorted (by UserName) even if I add new users which are alphabetically between two already existing users.
I've noticed that the method Membership.GetAllUsers() always seems to return a sorted collection of MembershipUsers.
Also when I look into SQL Server Management Studio and run a simple SQL query without ORDERBY clause...
SELECT [UserName]
FROM [MyDb].[dbo].[aspnet_Users]
...I get always a sorted result list.
I'm still very unfamiliar with SQL Server but I expected that when I add a new row to a table it is (physically) appended to the end of the table. And when I run a select statement without ORDERBY the rows will be selected in the order they were initially inserted into the database (so without any specific sort order).
I am wrong I guess. But how does it really work? Is it perhaps something special with the aspnet_Users table?
I am happy that the MemberShipUserCollection returned by GetAllUsers() is sorted but is it always guaranteed?
Update
I've just noticed that the database contains a stored procedure called aspnet_Membership_GetAllUsers. This procedure actually contains an ORDER BY clause by UserName. So if this stored procedure is indeed always called when I use Membership.GetAllUsers() in my code (at least if I am using the SqlMembershipProvider) it explains why the collection returned by Membership.GetAllUsers() is sorted by UserName.
Remains the question: Is Membership.GetAllUsers() actually based on this stored procedure?
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?
I am trying to correct the sort order of my ASP.NET drop down list.
The problem I have is that I need to select a distinct Serial number and have these numbers organised by DateTime Desc.
However I cannot ORDER BY DateTime if using DISTINCT without selecting the DateTime field in my query.
However if I select DateTime this selects every data value associated with a single Serial number and results in duplications.
The purpose of my page is to display data for ALL Serials, or data associated to one serial. When a new cycle begins (because it is a new production run) the Serial reverts to 1. So I cannot simply organise by serial number either.
When I use the following SQL statement the list box is in the order I require but after a period of time (usually a few hours) the order changes and appears to have no organised structure.
My webGrid is working perfectly fine. However, I would like the default sort order to be in the opposite direction. If it were SQL, I'd be adding a DESC somewhere. Here's my working line of code:
[Code]....
It correctly sorts on the UWDate column, but I would like it to sort the opposite sort order. Of course, once it is displayed, you can click on the title and it will resort at that time.
I have the following code for a gridview. When I click the Header, it can be sorted by ascending order. But if click the header again , it is still ordered by descending. What I want is that the sort order can be reversed when click the header again. How to do that?
protected void gvList_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable m_DataTable = (DataTable) Session["gvListDatasource"] ;
if (m_DataTable != null)
{
[Code].....
Here's my gridview when it comes it it's sorts on Age. Sorting is available for all columns/headers. How do I make the sort order to change on the ddsrpt sort to desc order when it's clicked?
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource7" EnableModelValidation="True" Width="789px"
CaptionAlign="Top" Height="126px" BackColor="White" BorderColor="#DCBE68"
BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
HorizontalAlign="Center" CellSpacing="2" Font-Names="Arial"
AllowSorting="True" EmptyDataText="No Records" DataKeyNames="FO,CLMSSN">
[Code] ....
I got this error message - Gridviewsortdirection is not declared
For our website, we have decided we would like to maintain our user passwords as encrypted binary data in our database. We are using ASP.NET 3.5 to host our site and SQL Server Express 2008 for the database, both running on the same server. When a user logs in and submits a username and password, there will need to be some sort of encryption or decryption in order to verify the credentials. To me, it would appear that there are 3 ways to do this:
1)[C# Encyrption] On User creation, perform encryption in the Web App and submit the encrypted password to the database. To verify credentials at Login, perform the same encryption on the submitted password and ensure that it matches the value stored in the database.
2)[SQL Encryption] On User creation, submit the plain-text password to the database and have it perform one of the SQL encryption variants during INSERT. To verify credentials at Login, have the database perform decryption on the password during the SELECT statement, and compare the plain-text submitted password to the one in the database.
3)[Mix] On User creation, submit the plain-text password to the database, and have it perform one of the SQL encryption variants during INSERT. To verify credentials at Login, perform the same encryption algorithm used by SQL on the submitted password ( is this possible? ), and ensure that it matches the value stored in the database.
Does anybody have an opinion as to which of these options is best? Number 1) is the most familiar to me, and would be the easiest to use with LINQ to SQL ( which is our current data model ), so I am leaning towards that. But if there are better options I would love to know about them.
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