Role of Dataset in window forms

[khalik_ash]

hi

i have app which look and works like a windows explore and its used for file storing and retivial. now i am planing to do it in vb.net as i have mostly static data that is mostly no changes done to the database.. i.e one a file created will only be viewed. and rarly updated.. so i thought i can get the whole data in dataset in diff tables..

is this approach good...?
and how do i load the data in the dataset for the tables ..?
how do i get the changes done to the database.. i see we have some methods like dataset1.getchanges... and dataset1.tables(1).getchanges...

regards

[Pirate]

Dataset is the new revolution in ADO.NET that has two main features :
1-Connect to source .
2-Discoonect mode (datareader reads from source and fill dataset ). This is the exciting part in ADO.NET . Once you've filled it then you have exactly the same copy of the source . After you are done , then push it back the source and your database is updated.

[khalik_ash]

thanks Pirate so using dataadapter i need to load my data...
i have build my dataset in vs and do we have a sinple method by which i can load the data... by the way is it a right way of doing...

MSDN say accessing database direct is better and fast.. but my app all the times interact with database and when ever changes been made i need to get the changes... so using Dataset is good or bad..

[Pirate]

I guess it's the only choice left for you . Dataset in disconnect mode is better sometimes (depending what kind of proj you're running) . It doesn't make heavy load on the machine . Just fill the dataset by dataadapter and closes the connection . When you have the same copy of that database , delete , edit , update and then push it back to the database .It's easy job if you well understand how it works ! .

[Pirate]

Disconnected mode is designed spcifically for networked databases. So this won't make that load and eat the resources of server .

[khalik_ash]

welll thanks a lot Pirate that was of gr8 info...