Dump entire datset into Access DB.

[chuckca]

Hello,

I have an Access XP db that I can successfully connect to and view records in a datagrid - no problem. I also can connect dynamically to a text file, format it appropriately, and add that data to a 2nd dataset - no problem.

/*** The Problem ***/

I can't figure out how to get the 2nd ds into the Access DB. I'm not sure if the two ds's should be one or what? I don't know where I'm messing up. I've tried merging, I've looked at commandbuilders, etc, etc, etc, til I'm pretty much getting overwhelmed with data. Does anyone know of a fairly simple way to dump an entire ds into an Access db?

I will greatly appreciate the help.

Chuck

 

[dmc1980]

Hi
If you are using a datagrid for updating a dataset from a database, try databinding. If you bind the datagrid to your database, any changes you make can be recognised and saved on the click of a button.

 

[chuckca]

dmc1980,

Thank you for replying, I figured it out. I was making it harder than it was.

Chuck