Creating an ASP.NET Dynamic Web Page Using MS SQL Server 2008 Database (GridView Display)
(Page 1 of 4 )
Dynamic pages (pages that pull, insert, update and delete data or content from a database) are extremely useful in modern websites. They provide a high level of user interactivity that improves user experience. This article will show you how to create such pages in ASP.NET that use a Microsoft SQL Server 2008 database.
For example, the dynamic table/web page in the screen shot below was created using ASP.NET 3.5 in a MS SQL Server 2008 database:
It offers two choices to users. First, they can edit the row data; second, they can delete records. Bear in mind that any update made to the web pages using a browser will automatically be reflected in the database.
This type of application sees lots of implementation on the Internet. You can see it in action on forums, e-commerce websites, administration panels, guest books, etc. If you are beginner in ASP.NET website development, this tutorial is an important introduction to creating database-driven web pages or websites.
This tutorial assumes that you have fully learned the fundamentals of creating ASP.NET web pages. You may wish to read the following articles for a review of its technology and its tools (such as Visual Web Developer Express 2008):
http://www.aspfree.com/c/a/ASP.NET/Develop-Your-First-ASPNET-Website-with-Visual-Web-Developer-Express/
http://www.aspfree.com/c/a/ASP.NET/Building-a-Static-ASPNET-Website-in-a-Basic-Hosting-Environment/
http://www.aspfree.com/c/a/ASP.NET/Adding-Content-to-a-Static-ASPNET-Website/
The objective of this tutorial is to let you:
- Create your own database using MS SQL Server 2008 for containing important data.
- Create your own ASP.NET dynamic web page that shows the database- driven content to the browsers.
- Display the data in grid view (table layout) like the one shown in the screen shot above.
- Let users update data by editing or deleting records.
Next: Step 1: Creating a database >>
More ASP.NET Articles
More By Codex-M
