.NET news » Search results
Search results for query "System" (117):
Using MSMQ , Backgroundworker Threads in C#
Building ASP.NET Validator using Data Annotations
Customer Support in Silverlight
System.Transactions and ADO.NET 2.0
Global Shortcuts in WinForms and WPF
Common Table Expressions (CTE) in SQL Server 2005
Products, Customers, Orders, OrderDetails, and so on - but we may need to
run reports on a particular subset of the data or against aggregate data across these tables. Or the reporting queries we need
might need to group or filter by results returned by scalar subqueries. Typically, views are used to break down complex queries into digestible chunks or to provide scalar subquery results that can be grouped and filtered.
Views, however, are sometimes overkill, as they are permanent objects at the system-level. If we only need to reference
this complex query in a single stored procedure or UDF, another option is to use a derived
table. Unfortunately, derived tables muddle the readability of the query and must be repeated for each use in a statement..
Displaying Files and Folders in a GridView
The .NET Framework provides a variety of classes in the System.IO namespace that
simplify working with the file system. Using these classes it's possible to delete files and folders, to create new files, to edit existing files, and more. These
classes, combined with ASP.NET's suite of Web controls and databinding syntax, make it quite easy to present information about the files on the web server's file system
to visitors to your website. With a bit of markup and code, it's possible to add a simple file browser to a web page that allows users to view the files and folders from
a particular directory on the web server. Such file browsers are useful if you let users upload content to the website and need to let them view their uploaded content.
If you have a folder that contains user-accessible content like images, PDF files and Word documents, a file browser offers a quick and easy way for users to see what
content is available and to view content of interest.
Back in 2003 I wrote an article titled Displaying the Files in a Directory using a DataGrid that showed how to list the files of a particular folder in a DataGrid Web control. This dated article still attracts a decent amount of traffic and questions from readers, so much so that I thought it worthwhile to update the content to use the latest technology, namely ASP.NET 4 and the GridView Web control. I also added some new features. For example, the file browser now lists both files and folders, allowing users to view the files in subfolders. Also, I moved the markup and code into a User Control, which simplifies adding the file browser to an ASP.NET page. This article walks through this new, updated version; the complete, working code is available for download at the end of this article.


Syndicate