Customer Support
6 month free email support.

Click here to contact customer support

Microsoft Certified Partner

Connecting an ASP.NET form created with SpreadsheetConverter to a database is very easy if you know some programming and Visual Studio.

We will do it in 3 steps:

  1. Calculate and save the form contents into a database.
  2. Retrieve previous entered data from the database, show it in the form and let the user edit it and recalculated and save it again.
  3. Show all submitted entries so that we can click on them to edit them.
You need Adobe Acrobat to view the articles.

Not all three steps are necessary, for example if you only need to store the values, you only need to read the first article.

Here is the necessary SQL-code.

Here is the result

In order to understand how to do this tutorial, you need to have basic knowledge of ASP.NET and databases. A good book is Beginning ASP.NET 2.0. A book for ASP.NET 1.1 is also fine. In the sample, we only use ASP.NET 1.1, for example Beginning ASP.NET 1.1 with Visual C# .NET 2003.

Free alternatives to Visual Studio

WebMatrix

http://www.asp.net/webmatrix/

There are also free version of Visual Studio 2005, called Visual Studio 2005 Express:

http://lab.msdn.microsoft.com/express/

Printer-friendly