|
|
|
|
|
Visual Data Designers
Includes SQL Server 2005 Express Edition |
|
SQL Server 2005 Express Edition is a lightweight database server designed for smaller load Web sites. It is available as an optional component which can be installed during the Visual Web Developer setup. Similar to Microsoft Access, you can create and deploy databases as stand-alone files, but with the powerful features unique to SQL Server 2005. This gives you incredible database power and management capabilities for building your Web sites. For more information on SQL Server 2005 Express Edition, please visit the SQL Server 2005 Express Edition Home.
|
Query Designer |
|
view larger >
|
Creating database queries can be challenging for new developers. Not only do you need to understand the SQL query language, you also need to remember the table and column names, data types, and special operators for filtering and sorting the results. The Query Designer makes it easy to visually design your database queries. Using the query designer, you can select the specific columns, and apply filtering and sorting through an easy-to-use drag-and-drop interface. You can actually watch the query being generated based on your decisions, and easily preview the resulting data.
|
Data-enabled controls |
 |
ASP.NET controls, like the DropDownList, BulletedList, CheckBoxList, and RadioButtonList controls are just a few of the controls which make it easy for you to display dynamic data from a database. Controls which can be bound to data sources have built-in smart tags (pictured below) to make it easy to create and configure connections to databases or other data sources.
|
Data Source Configuration Wizard |
|
view larger >
|
The Data Source Configuration Wizard provides a step-by-step wizard to assist in connecting to different data stores including databases like SQL Server and Access, objects, XML data sources and more. For database data, the wizard dynamically pulls the tables and fields from the database enabling you to easily select which fields you want to display.
|
|
By selecting the Where clause, you can filter your data based on a number of conditions including User Cookies, session values, query string values, or even values from other ASP.NET controls. In the selected image, the data source will dynamically change based on what the user has selected in the DropDownList1 control.
view larger >
|
GridView |
|
view larger >
|
The GridView control is designed for dynamically displaying data in a tabular format. It offers a number of powerful features which can be performed without writing a single line of code:
 Display a set of database records.
Sort a set of database records.
Page through a set of database records.
Edit a set of database records.
|
DetailsView |
 |
Provide your Web site visitors with a more detailed look at your data. The DetailsView control is designed to let you work with individual database records. You can use the DetailsView control on its own, to display or edit a single database record, or you can also connect a DetailsView control with a GridView control to quickly build master/detail forms.
|
< previous | next >
|
|
 |
|
|
|
|
|
