473,326 Members | 2,104 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Opinion on best data access method

My name is Glenn, I am an experienced VB5.0/6.0 programmer who is starting a
new project using VB.NET.

The project is simple but will be using a .mdb file for storing of data.
Only one person will be accessing the database at one time and the database
will be stored on a mapped shared folder.

I have been reading on ADO.NET and am getting a little confused and
wondering if I am am doing the right thing. The use of Data Adapters and
Data Sets just seems to be quite complicated for a small use of data access.

I am posting this to ask for an opinion on the best method to access this
database in this app. I am very happy to research the suggestions, I just
dont want to waste time researching something that wont suit/work.

If there are any further information you require please aks anything you can.

Thank you.

Glenn.
Jul 21 '05 #1
6 1634
Tippy,

I had when I started with it the same opinion as you, however AdoNet is
basicly very easy to use (In a multiuser environment it becomes more
complex, however that is as well with AdoDB in my opinion).

Have a look at the resource kit.

VB.net Resource kit
http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing the resource kit
http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

Newsgroups for VBNet and for AdoNet are

microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.framework.adonet

And please do not multipost, when you have a question where you do not know
where to place it crosspost it, that is no problem at all in dotNet
newsgroups. (Crossposting sending one message to more newsgroups).

I hope this helps?

Cor

Jul 21 '05 #2
<"=?Utf-8?B?VGlwcHkgRw==?=" <Tippy G@discussions.microsoft.com>>
wrote:
I have been reading on ADO.NET and am getting a little confused and
wondering if I am am doing the right thing. The use of Data Adapters and
Data Sets just seems to be quite complicated for a small use of data access.


One thing to bear in mind is that you don't have to use DataSets
themselves - they're just collections of DataTables. You can ignore
DataSets and go straight for DataTables to use with DataAdapters.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Jul 21 '05 #3
Jon,

One thing to bear in mind is that you don't have to use DataSets
themselves - they're just collections of DataTables. You can ignore
DataSets and go straight for DataTables to use with DataAdapters.


I would not give that advice, using datatables gives problems when you want
to save it as a file, serialize it for web use and things like that.

I saw a lot of messages from people who takes that datatable approach and
become a little bit in trouble.

Of course is a datatable almost a disconnected lookalike from a recordset.

Just my 2 cents

Cor


Jul 21 '05 #4
Cor Ligthert <no**********@planet.nl> wrote:
One thing to bear in mind is that you don't have to use DataSets
themselves - they're just collections of DataTables. You can ignore
DataSets and go straight for DataTables to use with DataAdapters.
I would not give that advice, using datatables gives problems when
you want to save it as a file, serialize it for web use and things
like that.


You can always put a DataTable into a DataSet if you need to, later on.

Furthermore, bear in mind that the OP specifically said it was for a
simple project - I very much doubt that it will incur any of the
problems above. When the problem's simple, I recommend using a simple
solution :)
I saw a lot of messages from people who takes that datatable approach
and become a little bit in trouble.


That doesn't necessarily mean that using DataTables was the problem, of
course...

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Jul 21 '05 #5
Jon,
You can always put a DataTable into a DataSet if you need to, later on.

No you cannot put a datatable into a dataset.

A dataset is an object that holds references to datatables. You can create a
new dataset and add references in the tableproperty from that too datatables
using the tables.add method

A dataset is not a container that holds values in a very classic way.
Furthermore, bear in mind that the OP specifically said it was for a
simple project - I very much doubt that it will incur any of the
problems above. When the problem's simple, I recommend using a simple
solution :)


Therefore I would not point on alternatives with Newbies, take the approach
as it is the most written on MSDN, and that is using the dataset.
I saw a lot of messages from people who takes that datatable approach
and become a little bit in trouble.


That doesn't necessarily mean that using DataTables was the problem, of
course...


If you say so, can you give me an example what it could have been?

Cor
Jul 21 '05 #6
Cor Ligthert <no**********@planet.nl> wrote:
You can always put a DataTable into a DataSet if you need to, later on.
No you cannot put a datatable into a dataset.


Um, yes you can, in exactly the way that you then describe...
A dataset is an object that holds references to datatables. You can create a
new dataset and add references in the tableproperty from that too datatables
using the tables.add method
In what way is that not putting a DataTable into a DataSet? The result
is exactly the same as if you created the DataSet and populated it
automatically, then retrieved the DataTable.
A dataset is not a container that holds values in a very classic way.


It's a container in the same way that (say) an ArrayList is.
Furthermore, bear in mind that the OP specifically said it was for a
simple project - I very much doubt that it will incur any of the
problems above. When the problem's simple, I recommend using a simple
solution :)


Therefore I would not point on alternatives with Newbies, take the approach
as it is the most written on MSDN, and that is using the dataset.


But that involves more complexity than just using DataTables.
I saw a lot of messages from people who takes that datatable approach
and become a little bit in trouble.


That doesn't necessarily mean that using DataTables was the problem, of
course...


If you say so, can you give me an example what it could have been?


If you could give me an example of the problem, certainly :)

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Jul 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: great_googley_moogley | last post by:
Greetings, I am in the process of installing a SQL database at a customer location. I have determined that there are 3 ways to do this, and I wanted to know which is the best of the 3. 1...
2
by: Joe Bloggs | last post by:
I have a general question on best practice regarding data access. I have the code below, a static method defined in a class that I use in a data layer dll. The method takes a string as its...
14
by: LP | last post by:
Hi, I will be taking on a new project developing a web-based "reporting system". The first requirement I got from BI group is "we just want to look at the data". Basically, there is a huge...
0
by: Anonieko Ramos | last post by:
ASP.NET Forms Authentication Best Practices Dr. Dobb's Journal February 2004 Protecting user information is critical By Douglas Reilly Douglas is the author of Designing Microsoft ASP.NET...
6
by: Tippy G | last post by:
My name is Glenn, I am an experienced VB5.0/6.0 programmer who is starting a new project using VB.NET. The project is simple but will be using a .mdb file for storing of data. Only one person...
20
by: C# Beginner | last post by:
I'm currently creating a database class, which contains a member called Open(). With this method users can open different databases. When a user tries to open a database which happens to be secured...
15
by: =?Utf-8?B?TWljaGVsIFBvc3NldGggW01DUF0=?= | last post by:
In my opinion rethrowing exceptions without providing anny extra information is a totall waste Examples : in my opinion wrong : A: Public sub DoSomeStuff() Try do it
1
by: CProgrammer80 | last post by:
I am compiling 4 different programs, each using a lot of the same core functions and files. One of the programs requires access to a large third party library, the others do not. I have created...
4
by: timmg | last post by:
I have an application were users evaluate records and based on the amount of money involved answer between 17 and a 120 questions on one of three response forms. I have a master list of question...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.