By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,028 Members | 1,013 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,028 IT Pros & Developers. It's quick & easy.

Data access from vb.net

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.