Thursday, May 20, 2010

Database Export Wizard for ASP.net and SQL Server

With this article I would like to share a simple but useful little tool: ExportWizard, a Step Wizard for Database Export.  

It guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats (CSV, HTML, XML, or SQL).

The UI: 3 simple steps

The task of exporting from a database can be broken down as follow:

Select a source database object (table, view, or query).
Select columns to include in the export.
Select the export format (CSV, HTML, XML, SQL...).
These simple sequential tasks are a good fit for a step wizard.

The implementation discussed in this article is a Web control, so the screenshots below are inside a web browser. It could be coded as a desktop application as well with the same basic elements and the same steps arrangement.

Step 1: Choose data source

Select table, view or SQL query to export data from.

Read more: Codeproject

Posted via email from jasper22's posterous