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)
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 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:
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.
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....?
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.
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.
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.
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...
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?
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.
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.
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?
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?
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