Web Forms :: Display Directory Files In Descending Order?
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
Similar Messages:
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
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
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
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
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
Mar 17, 2013
In mu asp.net+vb web there is a page in which i display files from a folder in web. the code i sused id as under
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim filePaths() As String = Directory.GetFiles(Server.MapPath("~/Result/comn/"))
[Code]....
as of now all the files in that directory is displayed . i want to display only pdf files
View 1 Replies
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
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
May 7, 2015
How I can see my folders in a list or DataGridView,and save images in the selected folder.
View 1 Replies
May 7, 2015
I want perticular file from sub directory i only know name of parent directory then how to get fileÂ
But it gives me string arrayÂ
I want info like   FileInfo[] listfiles = root.GetFiles();
So I can get all info with extension..
View 1 Replies
May 10, 2010
I have zip files in one directory . I want to iterate through all files and check the file size. If file size <>0 kb then want to move to another directory. How can I do that?
View 6 Replies
Jan 15, 2010
In my project i am uploding images and videos using file upload control
My problem is that suppose two users upload two files with same name on the system then how should i distinguish them
and whether I should first save fle or first make its entry in database.
View 2 Replies
Aug 8, 2012
I want delete all the datas in server side folder 'documents' when the page load.I am using following codeÂ
string filePath = Server.MapPath("documents");Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â System.IO.File.Delete(filePath);Â Â
when i run the following error occur.Access to the path 'D:Librarydocuments' is denied.How to delete server side folder either it has data or not?
View 1 Replies
Jul 7, 2010
Is it possible to display the items in a dropdown list not by the order of insertion?
i want to display the orders alphabetically.
View 3 Replies
Apr 28, 2010
We are currently updating our policy page on our intranet. Currently the page is written in ASP and connects to an Excel spreadsheet that serves as an index, which contains policy name and number. We also have a directory that contains all of the policiesnamed the policy number. The control that is currently being used will get all of the policies listed in the index and create links for them. We do not have to manually create the hundreds of links we just update the index. Does anyone have an idea of a control or a way I can accomplish this in asp.net?
View 1 Replies
Jan 20, 2010
Am using the addrotator in an update panel to display people images.
The data source is MS SQL server.
On my data access layer I have queried the information Ordered alphabetically using Names.
However the add rotator displays them randomly.
View 7 Replies
Jul 20, 2010
In Gridview, Item Template i want to display Dropdown containing Order Status. On Dropdown selection I want to update Status corresponding to that Order. I just want to know how can I get OrderID value(which I had stored in Label in Item Template), in dropdown onselectedindex event. Grid view can't have Edit button.
View 3 Replies
Nov 6, 2010
I want to create Graphical Report to display Order Summary,etc. how to create Graphical Report???
View 4 Replies
Mar 13, 2010
I have a ListBox1 on the Form that I read in the same Directories: "GetS" as in the code below.
Now I select the first index wich is 0 in the listBox with the mouse and press Button1.
What the code below does is to find that specific folder that also contains a .BMP file and a file: File1.txt
So I will first delete the .bmp file and the File1.txt and at last the directory.
My problem is as follows. When I press Button1 the First time, nothing at all was deleted but the second time I press the Button1, the .BMP file and the File1.txt were delete fine.
But the code breaks at this line and says that the directory isn´t empty. But the directory is empty as I can see when open it manually.
So initially my problem is why the .BMP, File1.txt and the directory aren´t deleted at the first press of Button1 ? (ListBox1 has AutoPostBack set to TRUE and everything is put inside an updatepanel)
[Code]....
View 7 Replies
Nov 3, 2010
I have some issues regarding listing images from inside a directory. What I want to do is to create a Default.aspx page that will search and list the images located inside a folder of my website (where I simply drop them in it). I tried with a treeview, DirectoryInfo and both worked when I compiled my website with visual studio, but when I access them via another computer, I get a 404 for the page. My bet is that iis7 is blocking my code from accessing the folder containing the images. Any idea of how to fix this and make it work ?the code I use to browse in my image folder
string path = AppDomain.CurrentDomain.BaseDirectory;
DirectoryInfo diFiles = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory + @"contentmiscimages");
foreach (var f in diFiles.GetFiles("*.jpg"))
{
Lit.Text += "<a href="" + f + ""rel="lightbox[img]" title=" + f + ">" + f + "</a>" + "<br />"; //I format the image as an url inside a literal
}
View 1 Replies
Aug 7, 2012
I have seen in your's Save and Retrieve Files from SQL Server Database using ASP.Net
there it is accepting only specific file but i want it should take all type of files. and store it in the database.
View 1 Replies