Data access from vb.net

[Duncan James]

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

[Rajesh Patel]

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

[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.

[Duncan James]

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.

.