How to save and read ASP.NET form data to a database
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:
- Calculate and save the form contents into a database.
- Retrieve previous entered data from the database, show it in the form and let the user edit it and recalculated and save it again.
- Show all submitted entries so that we can click on them to edit them.
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.
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
There are also free version of Visual Studio 2005, called Visual Studio 2005 Express:
