Data access from vb.net

  • Thread starter Thread starter Duncan James
  • Start date Start date
D

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
 
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
 
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
 
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
 
Back
Top