Basic questions on VB.Net

  • Thread starter Thread starter Fay Yocum
  • Start date Start date
F

Fay Yocum

BEWARE beginner questions!!

I have some experience in Access but never as much as I want or need. I have
decided to get in on VB.Net. I would only
rate myself in Access as a Beginner/Intermediate VBA programmer. I have
decided to go at learning VB.Net in a
more organized manner. I have some questions where answers are not becoming
clear with VB.Net. So here goes.

1 All of the books I have accessed do basic one-two form examples utilizing
one or two basic tables. I have used
Dobson's book and created two datagrids on the same form using the
Relationship wizard. What I can't see and
I am wondering about is what code uses the Primary/Foreign key and ties the
two datagrids together. I have a major Access database that combines
multiple tables that have relationships. But I probably will be using
combinations of individual textboxes and datagrid to display the data on one
or more forms. I need to know how to keep all data synched.

2. I am assuming that a data connector and data adapter is needed for each
table or query that is used on the form. Correct?

3. What is the standard for program development in relationship to
resolution? Are most people developing for 800 x 600 or 1024 x 764 when the
ultimate end-user is unknown?

4. One thing I have never figured out is how to size/auto resize a form. How
do I work with the answer to #3 and allow the form still be displayed
properly in the other resolution?

Thank you for any and all answers.

Fay
 
"Hi Fay

Programming is not like access filling in a table and do what someone has
decided for you.

You can do it mostly anyway you want, therefore most of your questions are a
little bit subjective for a programmer, and I gues you get a lot of
different answers. Not because they are wrong in contrary they will be
mostly right.
1 All of the books I have accessed do basic one-two form examples utilizing
one or two basic tables. I have used
Dobson's book and created two datagrids on the same form using the
Relationship wizard. What I can't see and
I am wondering about is what code uses the Primary/Foreign key and ties the
two datagrids together. I have a major Access database that combines
multiple tables that have relationships. But I probably will be using
combinations of individual textboxes and datagrid to display the data on one
or more forms. I need to know how to keep all data synched.
Click to expand...

Have a look at databinding, datasource and currencymanager
2. I am assuming that a data connector and data adapter is needed for each
table or query that is used on the form. Correct?
Click to expand...

I think that when you talking about the data adapter you are talking about
the drag and drop dataAdapter. It is very simple to use, but soon you will
see the disadvantages of it.
After a while you while probably do it in code and after a while than again
you will also see that it is much easier, have a look in code for (Oleddb or
SQL everytime before it) Connection, Command, Adapter, Commandbuilder.
3. What is the standard for program development in relationship to
resolution? Are most people developing for 800 x 600 or 1024 x 764 when the
ultimate end-user is unknown?
Click to expand...

This will of course be important where you live. I asume that in the rich
countries larger screens are used than in the other ones.
4. One thing I have never figured out is how to size/auto resize a form. How
do I work with the answer to #3 and allow the form still be displayed
properly in the other resolution?
Click to expand...

Have a look for that at "dock" and "Anchor"

I hope this helps something?

Cor
 
Yes Cor this does help. Thank you.

Fay

Cor said:
"Hi Fay

Programming is not like access filling in a table and do what someone has
decided for you.

You can do it mostly anyway you want, therefore most of your questions are a
little bit subjective for a programmer, and I gues you get a lot of
different answers. Not because they are wrong in contrary they will be
mostly right.


Have a look at databinding, datasource and currencymanager


I think that when you talking about the data adapter you are talking about
the drag and drop dataAdapter. It is very simple to use, but soon you will
see the disadvantages of it.
After a while you while probably do it in code and after a while than again
you will also see that it is much easier, have a look in code for (Oleddb or
SQL everytime before it) Connection, Command, Adapter, Commandbuilder.


This will of course be important where you live. I asume that in the rich
countries larger screens are used than in the other ones.


Have a look for that at "dock" and "Anchor"

I hope this helps something?

Cor
Click to expand...
 
Back
Top