Dump entire datset into Access DB.

chuckca

New member
Joined
Mar 23, 2005
Messages
4
Programming Experience
Beginner
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

Active member
Joined
Feb 7, 2005
Messages
33
Programming Experience
5-10
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.
 
Top Bottom