C# - Order By Descending Based On Condition
Apr 15, 2010
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;
}
}
View 2 Replies
Similar Messages:
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
Jan 12, 2010
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?
View 3 Replies
Aug 14, 2010
i m using asp.net 2005 with access 2003. i need a code using vb.
how can i sort the record in descending order?
View 3 Replies
Apr 15, 2010
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]....
View 1 Replies
Apr 16, 2010
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]....
View 6 Replies
Dec 13, 2010
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?
View 7 Replies
Oct 12, 2010
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.
View 4 Replies
Jan 25, 2010
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
View 2 Replies
Mar 20, 2010
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 Replies
Oct 22, 2010
I have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
View 7 Replies
Oct 16, 2012
I 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 Replies
Mar 29, 2011
I have dropdown and textbox, I want to pass dropdown value as condition in generic handler through jquery autocomplete I am using generic handler for getting values from database.
View 2 Replies
Oct 25, 2010
I am using c# 2.0 and ASP.NET. I have a button in my web page. I want to enable the button only for the last 5 working days of any month. How to enable the button only for the last 5 working days(business days) that is Monday to Friday.
View 9 Replies
Jul 30, 2010
I have CheckedListbox and grid. Based on what are the items checked in listbox that much of items need to be shown in grid. My SQL procedure like ;
select * from Emp
where city in (@Names)
Everything is ok if I am checked any of the item and click OK. If I am nothing checked from the listbox I need to display all of the cities from DB. I need to do this work without modifying my procedure. So need to work out in front/end. If I pass nothing from the code the query seemed as select
* from Emp
where city in ('')
So no records getting...
View 7 Replies
Feb 19, 2011
I want to change a particular row color of gridview based on some condition, i am using ASP.NET with c#.
View 2 Replies
Jan 11, 2011
I have four textbox fields for ItemName, ItemDescription, Length and Quantity.
One radiobuttonlist and its listitems are FixedLength and Random Length.
One button field called Submit and one gridview.
In the GridView I have 4 bound columns and 1 template column such as ItemName, ItemDescription, Length, Quantity and IsFixed_f(flag field). I have added one checkbox in the GridView's Template column for the IsFixed_f field.
After entering all textbox fields, I have to select either one listitem in the radiobuttonlist(FixedLength or RandomLength). After completing these things. If I enter the Submit button, all the values in the textbox to be displayed under the GridView's corresponding column name and checkbox to be checked if FixedLength listitem is selected otherwise the checkbox.checked should be false. How to do this?
In the Button Click event, i have used like this
[code]....
View 3 Replies
Feb 11, 2011
I want to hide a column of GridView based on a condition. How can I access the column in C# code?
if() // condition
{
// Disable code here. ?????
}
View 2 Replies
Sep 15, 2010
I have an asp.net application that uses validation controls on textboxes. However, if the user enters a value in txtFieldA, then I want to disable the validation controls on txtFieldB and txtFieldC.
View 2 Replies
Feb 3, 2011
Is there a way to conditionally attach a RadToolTip to a GridHyperLinkColumn?
View 1 Replies
May 21, 2010
Am displaying the contents of a folder(folders n files) in a gridview.In the gridview,file/foldername ,type ,size ,Last modified date columns are displayed.the datasource for this gridview is supplied manually through a datatable.
I need to display folder/file images beside folder/filename.if the datasource is from a database we can give a if condition in the following way.
[code]....
But here in itemtemplate I am binding the data using bind expression instead of Eval .So I could not give if condition here.
How can I display folder or file image based on a condition ?the datasource is provided manually to the gridview not from a database.
View 5 Replies
Dec 22, 2010
I want to create new string or stringbuilder based on condition; Example . I am updating a count variable "i"; if i = 100, i need to create a string or stringbuilder; if else i = 200 i need to create a new string or stringbuilder; if else i = 300 i need to create a new string or stringbuilder; and so on how i can achive this?
View 8 Replies
Jan 15, 2011
Am trying to bind data to a dropdown list on pageload based on a condition. Code explains further below.
public partial class AddExhibit : System.Web.UI.Page {
string adminID, caseIDRetrieved;
DataSet caseDataSet = new DataSet();
SqlDataAdapter caseSqlDataAdapter = new SqlDataAdapter();
string strConn = WebConfigurationManager.ConnectionStrings["CMSSQL3ConnectionString1"].ConnectionString;
protected void Page_Load(object sender, EventArgs e) {
adminID = Request.QueryString["adminID"];
caseIDRetrieved = Request.QueryString["caseID"];
if (caseIDRetrieved != null) {
CaseIDDropDownList.Text = caseIDRetrieved;
//CaseIDDropDownList.Enabled = false;
} else { try { CreateDataSet();
DataView caseDataView = new DataView(caseDataSet.Tables[0]);
CaseIDDropDownList.DataSource = caseDataView;
CaseIDDropDownList.DataBind(); }
catch (Exception ex) {
string script = "<script>alert('" + ex.Message + "');</script>";
} } }
The CreateDataset method that is called in the if..else statement is contains the following code.
private void CreateDataSet() {
SqlConnection caseConnection = new SqlConnection(strConn);
caseSqlDataAdapter.SelectCommand = new SqlCommand("Select CaseID FROM Cases", caseConnection);
caseSqlDataAdapter.Fill(caseDataSet); }
However when I load the page and as usual the condition that is supposed to bid the data is met, the gridview decides to displays as follows. Is it me or its the Datagrid?
View 3 Replies
Mar 9, 2011
i have two textboxes and two required filedvalidators for each one.and i have to validate based on the radio button slections.
1)if i select Radiobutton1 it has to validate both textboxes.
2)if i select Radiobutton2 it has to validate only one textbox.
View 2 Replies
Feb 14, 2011
I´m using some code I found on how to send files to a FTP address. It´s having a Public sub. Within there is there is a credentials set. I need to set different credentials based on which button was clicked. Somthing like:
Public Sub uploadFileUsingFTP(ByVal CompleteFTPPath As String, ByVal CompleteLocalPath As String, Optional ByVal UName As String = "", Optional ByVal PWD As String = "")
If Button1.Click Then
reqObj.Credentials = New NetworkCredential("User1", "PASS")
elseif Anotherbbutton.Click then
reqObj.Credentials = New NetworkCredential("User2", "PASS")
End If
View 3 Replies