DataGridView in ASP.NET

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

Hi Akhil,

We have been resolving issue where we display data using GridView and SqlDataSource. You can check the conversation on the following link: http://www.codeasp.net/forums/asp-net-topics/data-access/715/how-to-add-modify-data-for-2-or-3-tables-at-the-same-time-plz-help/1#2448%29 - there you will see how to implement the thing you want, the same procedure applies for you.

Moreover, you can check the following links too:

• http://www.asp.net/web-forms
• http://msdn.microsoft.com/en-us/library/tw738475.aspx - this is step by step wallthrough for the same thing you need
• http://msdn.microsoft.com/en-us/library/c4245bb4.aspx - this will help you understand how editing and modifying data in ASP.NET WebForms with GridView works

Of course, there are many more article available on internet, make a search ;).

Hope this helps,
Hajan

Hi.

You can check out this link.It will be really helpful.

http://geekswithblogs.net/dotNETvinz/archive/2009/02/22/gridview-insert-edit-update-and-delete--the-ado.net-way.aspx

Thank you.