New to VB.Net.....Questions, Questions

[Dave McKie]

Hi all,

I'm somewhat new the DotNet platform....I've used VB6 as well as VBA.

I have a couple of basic questions:

What are the majority of programmers using?

Data components such as DataAdapters or connection string?
SqlDataAdapters or OleDbDataAdapters?

Is binding data to forms the norm or using code to create, edit,
delete data?

what are advantages?

I've tried a little of each of these methods and am not sure what
direction to take.

Thanks
Dave McKie
10/04/2004

 

[W.G. Ryan eMVP]

Hi Dave:

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com

Hi all,

I'm somewhat new the DotNet platform....I've used VB6 as well as VBA.

I have a couple of basic questions:

What are the majority of programmers using?

Data components such as DataAdapters or connection string?
SqlDataAdapters or OleDbDataAdapters?

You can only use SqlDataAdapters with Sql Server so it depends on the DB
you're using. If you are running SQL Server, I'd highly recommend using
SqlClient.

I'm not sure what you mean about dataAdapters or Connection Strings. You
need a connection object for your command objects which dataadapters need.

Is binding data to forms the norm or using code to create, edit,
delete data?

It depends on if you're using Typed DataSets or not. If you are then using
the Visual tools is certianly easier - at least to develop up front. It
really doesn't matter though, you get to the exact same plac.e

what are advantages?

Visual Tools are a little easier but you can change databindings at any time
so they aren't mutually exclusive.

 

[Cor Ligthert]

Dave,

In my opinion have all your questions to do with your learning curve.

For using data in VBNet you need at least a
Connection which has a connection string
Commands
DataAdapters (in the which can automaticly be used a Commands)

Those are for different databases. When you cannot get a specialized on as
SQLClient you can use almost forever OleDb however that has some extra
overheiad and therefore they are slower than the specialized ones. (When
that was not the case the specialized where of course never used).

Databinding makes life much easier when you know how to do, however at the
start you become completly confused. By instance; you will be not the first
one who thinks that currency has to do with money and not with the current
state of a datatable.

So start with a simple application, and when it than becomes with a lot of
textboxes or other controls, start looking to databinding.

For some controls, you can use only (when you want to use them complete)
databinding, you recognise them because they have a "datasource".

I hope this helps?

Cor