how to connect to a dataset

[vailen]

hi

i'm a newbie at vb.net and i'm working on a management system(windows application) with visual studio 2008. My problem comes with the type of database to use and how to connect to it. I was told to use datasets but i'm having trouble connecting to my dataset and when i do insert data in it do i have to transfer it to another database or can i leave it as it is?

 

[Robert_Zenz]

A Dataset is nothing more then a layer (which holds/stores data) between your program and the real database.

You'll need to set up a real database (like MySQL, Firebird or PostGreSQL). Connecting to a database works in many different ways, the VS Wizard, ADODB, ODBC...

Bobby

 

[cjard]

hi

i'm a newbie at vb.net and i'm working on a management system(windows application) with visual studio 2008. My problem comes with the type of database to use and how to connect to it. I was told to use datasets but i'm having trouble connecting to my dataset and when i do insert data in it do i have to transfer it to another database or can i leave it as it is?

A data set is a collection of datatables that are basically 2d arrays of data. It is for client side data cache.. you dont "connect" to it as though it were a database.

For more info on how to use dataset etc read the DW2 link in my signature, section Creating a Simple Data App