468,769 Members | 2,252 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,769 developers. It's quick & easy.

Data access from vb.net

Hi

Where to begin? Well, we have been using index
sequential files in cobol and would like to move away
from them to relational databases. Where is the best
place to start? We want to be able to read single and
multiple records, write, delete and update records. We
want to be able to read the data into entry boxes on
forms so it can then be viewed and amended.

There seems to be so many different ways of doing things
so wonder if anyone can offer any advice.

Many Thanks,

Duncan
Nov 20 '05 #1
3 1550
try to work with the following objects

dataset, datatable, dataview, dataadapter..
for database operations: executenonquery, executereader, connection to
database...
databinding with datagrid, combobox, textbox, ...

this will help you to start your work

Rajesh Patel
"Duncan James" <an*******@discussions.microsoft.com> wrote in message
news:0b****************************@phx.gbl...
Hi

Where to begin? Well, we have been using index
sequential files in cobol and would like to move away
from them to relational databases. Where is the best
place to start? We want to be able to read single and
multiple records, write, delete and update records. We
want to be able to read the data into entry boxes on
forms so it can then be viewed and amended.

There seems to be so many different ways of doing things
so wonder if anyone can offer any advice.

Many Thanks,

Duncan

Nov 20 '05 #2
Cor
Hi Duncan,

That is a long road to go.

But basicly a relational database is nothing more than a lot of index
sequential files named tables (and sometimes they even do not have an
index).

You can in vb.net access that in a sequential way (streaming way) or in a
way that you Select conditional a whole set of records or relational records
(a dataset) in one time using the dataadapter.

To do that, just take a look at de resource kit. There are a lot of
examples.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And have than special first a look at Data Access.

I hope this helps you on the route?

And for this is a very good and active newsgroup.

microsoft.public.dotnet.framework.adonet

Cor
Where to begin? Well, we have been using index
sequential files in cobol and would like to move away
from them to relational databases. Where is the best
place to start? We want to be able to read single and
multiple records, write, delete and update records. We
want to be able to read the data into entry boxes on
forms so it can then be viewed and amended.

There seems to be so many different ways of doing things
so wonder if anyone can offer any advice.

Nov 20 '05 #3
Hi Cor

Thank you very much for your help. I'll download the
resource kit and hopefully that should get me started.

Kind Regards

Duncan

-----Original Message-----
Hi Duncan,

That is a long road to go.

But basicly a relational database is nothing more than a lot of indexsequential files named tables (and sometimes they even do not have anindex).

You can in vb.net access that in a sequential way (streaming way) or in away that you Select conditional a whole set of records or relational records(a dataset) in one time using the dataadapter.

To do that, just take a look at de resource kit. There are a lot ofexamples.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And have than special first a look at Data Access.

I hope this helps you on the route?

And for this is a very good and active newsgroup.

microsoft.public.dotnet.framework.adonet

Cor
Where to begin? Well, we have been using index
sequential files in cobol and would like to move away
from them to relational databases. Where is the best
place to start? We want to be able to read single and
multiple records, write, delete and update records. We
want to be able to read the data into entry boxes on
forms so it can then be viewed and amended.

There seems to be so many different ways of doing things so wonder if anyone can offer any advice.

.

Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Neil Ginsberg | last post: by
1 post views Thread by Andrew Arace | last post: by
9 posts views Thread by Tony Lee | last post: by
3 posts views Thread by Lyle Fairfield | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.