Introducing ASP.NET 2.0 with Visual Studio 2005 - Working with Tables and the New “Grid View” Control
(Page 3 of 4 )
Creating a Table:
- Open the “Table” group of the same connection in “Server Explorer,” right click on it and click “Add New Table.” The table designer gets opened, allowing us to add the required columns with their respective data types, nulls, relationships, and so on.
- Add details as shown in figure 4 and save it with the table name “EmployeeDetails.”
- Select the “EmployeeDetails” table, right click on it and click “Show Table Data.” Provide data to as shown in figure 5. Every modified cell gets marked with a Red icon (shown in the figure) unless you save it (or move to the next row).
Similarly, create one more table by name “DepartmentDetails” and insert relevant data as shown in the figure below.
Accessing Data: The new control “Grid view” (of ASP.NET), considered to be the most powerful and beautiful control of Visual Studio 2005, has been introduced with much more powerful features than the data grid. It fulfills almost all the requirements of the developer, to simply play with all the properties and tasks such as paging, sorting, editing, deleting, selecting and so on without writing a single line of code! By directly dragging the database table from the Server Explorer Window onto the design pane, it displays table information in the form of a grid (which is not supported in previous versions of VS.NET).
Now we will go through each and every step, by utilizing this powerful control:
- Select the “EmployeeDetails” table (in server explorer) and drag it onto the “default.aspx” pane. Your screen should look something like in Fig 6.
- On top of the grid view, carefully observe a small arrow button. It gives you plenty of options to play with. You can even produce perfect sorted, formatted data for the grid right from the same button. Apart from all of this, you will be able to update data within the grid itself, just by selecting a few options.
Using the above approach, we can create, modify or delete data from within the “grid view” control (which directly affects the database). Try to experiment with all of those options by executing the solution.
Next: Creating Data Diagrams and Views using the Visual Studio 2005 “Server Explorer” Window >>
More ASP.NET Articles
More By Jagadish Chaterjee
/ 68 
