willbdman
asked on
Developing database application
I am looking at developing a datbase app.
Is it best to use a connection everytime the user performs an action (i think this is best) or use dataset with datadapters?
There is a lot of data so i believe the first option is more viable - just looking for further opinions.
Will
Is it best to use a connection everytime the user performs an action (i think this is best) or use dataset with datadapters?
There is a lot of data so i believe the first option is more viable - just looking for further opinions.
Will
You cannot use dataset and dataadapters without open connection. You need to create a connection (in any case) and then use dataadapter to populate your dataset.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know you always need a connection, the difference is the datareader performs the actions directly, the data adapter grabs the required data allows you to modify it then send it back later.
I will be pulling data but only a record at a time.
E.G. list of say outlets clicking on one brings up the outlet in more detail.
What are crystal reports?
Is there anyway of producing reports for printing using VB.NET?
I will be pulling data but only a record at a time.
E.G. list of say outlets clicking on one brings up the outlet in more detail.
What are crystal reports?
Is there anyway of producing reports for printing using VB.NET?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.