Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database 27 Feb 2008 00:00 GMT
In most data-driven Web applications, users add data to the database by entering it through a web page. While this works well for most scenarios,
there are times when the user has already collected the data to enter elsewhere, and having them tediously re-enter it through a web page is not only
inefficient but prone to typos. In this multi-part series we will examine how to import data from a Microsoft Excel spreadsheet into a database from a web
page. Specifically, we will build a tiered application architecture using Typed DataSets and TableAdapters.
A ZIP file with the complete source code, Excel spreadsheet, and SQL Server Database is available
for download at the end of this article. You may easily modify this tutorial to use an existing database as well.
This article and the subsequent installments have been written with step-by-step instructions and screen shots. If you
are learning ASP.NET, please refrain from downloading the source code and plunking it into your project, as the best way to learn is
to walk through the tutorial from scratch and do each step yourself. In this first installment we will discuss the purpose and architecture of
the application and create the database tables. Read on to learn more!
Read on to learn more!
Read More >
Source: 4GuysFromRolla Use Specialty Arrays to Accelerate Your Code 21 Feb 2008 00:44 GMTLearn how to build unusually shaped triangular and sparse arrays, and arrays with non-zero lower bounds that are much faster than those provided by the standard .NET Array class.
Source: DevX Creating an AJAX-Enabled Calendar Control 20 Feb 2008 00:00 GMT
Go to any travel or event booking website and you'll find the same user interface for collecting date information: the Calendar. Providing such an interface
in an ASP.NET application is a breeze, thanks to the built-in Calendar Web control. There are two downsides to ASP.NET's Calendar control: first, it is
not very useful when selecting dates far into the future or past, as you can only navigate to the next or previous month; and, second, the Calendar does not
use AJAX techniques, so each click, be it selecting a date or moving to the next or previous month, requires a full postback.
Mehmet Genc addressed this first shortcoming in Extending
the Calendar Control's Date Navigation by showing how to add month and year drop-down lists. But Mehmet's article was written in 2004 and since then AJAX-enabled
websites have become all the rage. I decided it was high time to update Mehmet's custom Calendar control to support AJAX. Specifically, I implemented
the AJAX-enabled Calendar control as a User Control. The User Control renders a TextBox control that, when clicked, displays a Calendar control from
which the user can select the date. Like with Mehmet's Calendar, users can quickly jump to a particular month or year by using two drop-down lists.
And best of all, the user experience is very responsive.

Read on to learn more!
Read More >
Source: 4GuysFromRolla Using ASP.NET 3.5's ListView and DataPager Controls: Paging Through Data with the ListView and DataPager Controls 13 Feb 2008 00:00 GMT
The GridView, DetailsView, and FormView controls all support out of the box paging support that can be enabled at the tick of a checkbox. When configured
to enable paging, these controls automatically render a paging interface comprised of LinkButtons, Buttons, or ImageButtons. The particular paging interface
configuration - whether Next/Previous links are used, whether numeric paging options are used, the text displayed in the various buttons, and so on -
are customizable through the data Web controls' properties. While these configuration options are nice, they only allow for a small amount of customization.
For instance, the configuration options let you specify if you want the paging interface to appear at the top or bottom of the control (or in both locations).
But if you want the paging interface to appear elsewhere on the page, separate from the paging interface, you're out of luck.
The ASP.NET team remedied this problem with the ListView control by decoupling paging support from the ListView control and moving it to a separate,
stand-along control, the DataPager. The DataPager control's sole purpose is to render a paging interface and communicate to its corresponding ListView
control once the user interacts with the interface (such as choosing to move to the last page of data). This explicit separation between the ListView
and DataPager allow for a much greater degree of paging interface customization and positioning, as we will se in this article.
Read on to learn more!
Read More >
Source: 4GuysFromRolla