Chapter 20 Creating Web Sites and Web Pages by Using Visual Web Developer and ASP .NET 515
Through your actions here, you are creating an SQL SELECT statement that configures
a dataset representing a portion of the Faculty2010 .accdb database. You can see the
SELECT statement at the bottom of this dialog box.- Click Next to see the Test Query screen.
- Click the Test Query button to see a preview of your data.
You’ll see a preview of actual Last Name and Business Phone fields from the database.
This data looks as expected, although if we were preparing this Web site for wider
distribution, we would take the extra step of formatting the Business Phone column
so that it contains standard spacing and phone number formatting.- Click Finish.
Visual Web Developer closes the wizard and adjusts the number of columns and
column headers in the grid view object to match the selections that you have made.
However, it continues to display placeholder information (“abc”) in the grid view cells.- With the GridView Tasks list still open, click the Auto Format command.
- Click the Professional scheme.
The AutoFormat dialog box looks like this:The ability to format, adjust, and preview formatting options quickly is a great feature
of the GridView control.- Click OK, and then close the GridView Tasks list.
The FacultyLoanLeads .aspx Web page is complete now, and looks like the screen
shot on the following page. (My GridView control is within a <div> tag, but yours
might be within a <p> tag .)