Hi

I am quite new to the ASP.NET framework and I am trying to design a datagridview table that does the following:

1. Retrive data from an existing database using a connection string
2. Displays that data
3. Allows user to edit and make changes to every row in the datagridview.
4. Allows to user to insert data (at the footer) into the dataset through the datagridview table using textboxes and dropdownlists
5. The dropdownlist contains elements from another database retrieved through another connection string.

lets say for example that my dataset contained the following columns:
1. ID Number
2. First Name
3. Last Name

Thank You in advance