Grid with Search and Detail view parts:

Today I will be building a grid with search and detail view parts.  For this I am using a table in my MySQL backend named Vendor.

The fields are
id integer primary key auto increment
name varchar 30
address1 varchar 30
address2 varchar 30
city varchar 30
state char 2
zipcode char 5
phone varchar 20
contact varchar 30
contact_phone varchar 20
contact_email varchar 50
contact_sms varchar 30
purchase_today decimal 9,2
purchase_ptd decimal 9,2
purchase_ytd decimal 9,2
purchase_total decimal 9,2
account_number varchar 20

the connection string is the same we used earlier.  You can refer back to connection string post to refresh your memory.
The grid is built to show main information.
The search is built to search on name only.
The detail view is built to show all the fields in two columns.

The items I do not like are removed but it is not necessary for the function of the grid.
Here are the videos showing the construction of the grid.

Finished grid & the table information in MySql
http://screencast.com/t/LruHacH14Z

Building the grid and search part
http://screencast.com/t/th7qWZiv

Building and customizing detail view
 - Part1
http://screencast.com/t/1vaK0ZU4Pgl2

 - Part2
http://screencast.com/t/vEjEKsYgTb

 - Part3 the finished product
http://screencast.com/t/VACWnyRWnY