How to update a dataset with a datagrid

[Porsche944]

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.

[Porsche944]

Anybody? Any Hints? Tips? Jokes or Comments

[Porsche944]

bump

[dee-u]

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....

[Porsche944]

How would I convert a datagrid to a table?

[Hack]

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.

[Porsche944]

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

[Hack]

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

[Porsche944]

A custom collection of custom objects I created =)