How to update a dataset with a datagrid

Hey everyone,
I have been searching google for a few days now trying to fix an example how to do this.

My program collections information and stores it inside a datagrid. That part works fine. I am having trouble figuring out how to take that datagrid and create a new dataset from it with all the information the datagrid contains. I will then use that dataset with a OLEdBDataAdpater to update a Microsoft Access Database.

How can I do this? All the code I have found online is for taking a table from a database , storing it in a dataset and then setting the datasource of the datagrid to the dataset.

I know this is possible and it's probably really easy.

Anybody? Any Hints? Tips? Jokes or Comments :sick:

bump

You could take that datagrid into a table then take that table storing it in a dataset and then setting the datasource of the datagrid to the dataset....

How would I convert a datagrid to a table?

Can you create a recordset out of your collections information?

If so, you could easily dump that recordset into a DB table using INSERT INTO.

I don't have a collection of information. I just have a datagrid that is filled with information dynamiclly.

Ok...from what source does the datagrid get populated?

A custom collection of custom objects I created =)