IT Web Feeds » 4GuysFromRolla.com Headlines » March 2008

Feeds

1191 items (1191 unread) in 13 feeds

• Developer Fusion Recent Articles & Tutorials (14 unread)

WebDevelopment (892 unread)

• Open Source Web Development Tutorials - RSS Feeds (77 unread)
• 4GuysFromRolla.com Headlines (23 unread)
• ASP.NET Daily Articles (143 unread)
• dev-exchange.com (59 unread)
• SitePoint.com (46 unread)
• ScottGu's Blog (37 unread)
• C-Sharpcorner Latest Articles (190 unread)
• The Code Project Latest Articles (317 unread)
• Developer Tutorials

PHP (82 unread)

• Good PHP Tutorials - New Tutorials (82 unread)

ColdFusion (147 unread)

• Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com (147 unread)

MicrosoftExchangeServer (56 unread)

• MSExchange.org (56 unread)

4GuysFromRolla.com Headlines (4 unread)

• March 25, 2008
• 19:00

  Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet

   » ‎ 4GuysFromRolla.com Headlines

  Over the past four installments in this article series we have: created a SQL Server database for our web application; created an ASP.NET web page that enabled the visitor to upload an Excel spreadsheet and view its contents in a GridView; and created a Data Access Layer (DAL) using Typed DataSets for accessing our application database. All that remains is to import the uploaded Excel spreadsheet's data into the application database.

  In a perfect world, a user would carefully check the data in the Excel spreadsheet and cross-reference it with the data already existing in the application database. But our users are humans and bound to err. Therefore, it behooves us to design the import functionality so that it can gracefully handle common types of mistakes. We'll examine two such cases: preventing duplicate entries and ensuring that the imported data is in the appropriate format.

  Read on to learn more!
  Read More >

• March 18, 2008
• 19:00

  Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)

   » ‎ 4GuysFromRolla.com Headlines

  Over the course of the past three tutorials we have created an ASP.NET page that allows the visitor to upload and display an Excel spreadsheet in a GridView. Our end goal is to allow the user to import the rows in the spreadsheet into the two tables of our application database, a task we will complete in this fourth installment.

  In Displaying the Uploaded Excel Spreadsheet we saw how to use an OleDbConnection to programmatically connect to the Excel spreadsheet and bind it to the GridView. Likewise, we could use this same style of coding to insert data into our application database tables - connecting to the SQL Server database from code within the ASP.NET page and issuing the INSERT statements. A better approach, however, is to design a tiered architecture that separates out the different responsibilities into different layers. Specifically, we will place the code for inserting data into our database into a separate Data Access Layer (DAL), which we will create using Typed DataSets.

  With the DAL created, we can then wrap up the page's core functionality: connecting to the Excel spreadsheet, enumerating its rows, and using the DAL to insert the rows into the database. Read on to learn more!
  Read More >

• March 11, 2008
• 19:00

  Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Displaying the Uploaded Excel Spreadsheet

   » ‎ 4GuysFromRolla.com Headlines

  In Building the Importer Web Page and Uploading the Excel Spreadsheet we created an interface for users to upload an Excel spreadsheet to the web server with the end goal being that a user could import the uploaded spreadsheet's data into the application database. Before importing the data, it would be prudent to display the contents of the uploaded Excel spreadsheet to give the user one last time to look over the data and verify that they want to import it.

  The contents of an Excel spreadsheet can be programmatically queried with code and syntax similar to that used when querying a "regular" database, like Microsoft SQL Server. In this article we will see how to bind the contents of the uploaded Excel spreadsheet to a GridView. Read on to learn more!
  Read More >

• March 04, 2008
• 18:00

  Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Importer Web Page and Uploading the Excel Spreadsheet

   » ‎ 4GuysFromRolla.com Headlines

  This article is the second in a series of step-by-step tutorials by Nannette Thacker that show how to build an ASP.NET page to import an Excel spreadsheet into a database using Typed DataSets and TableAdapters. Last week's article, Building the Database, started with an overview of the system. We then created the ASP.NET website project, the database, and the two database tables, Members and Category.

  In this installment we will build the ASP.NET page for importing the Excel spreadsheet. This entails creating the page's user interface and file upload capabilities. At the conclusion of this article we will have created a page that enables users to upload their Excel spreadsheets. Read on to learn more!
  Read More >