Two vb.net questions

[Jmar]

Having spent many years working with VB 4.0 I've recently purchased
VB.net. At this early point I have two questions.

1) How can I QUICKLY view the code associated with a specific control?
If I right-click on the control, let's say a combo box, and select "View
Code" it seems to take me back to the last code I was viewing. I
would like to go directlly to the combo box event code. This is slowing me way
down!

2) I have data in an ACCESS 2003 database. I have a form that has
several combo boxes and text boxes. Each of these has an associated
field in the database. I want to write code so that each time the user
selects something in any of the combo boxes, a search is done of the
database to find the associated record. If found, the text boxes are
filled with data from that record. It is also possible that there
will not be a matching record so then the user must manually input the
text boxes. What is the easiest way to do this with code. In VB 4.0
I opened a table a did a SQL query to pull up that record. I then set
each text box to the associated field. Im sure there is something
similar in .NET but I'm having difficulty grasping it. Please provide
a code example.

Thank you in advance for help on either question.

John

[Cor Ligthert]

"Jmar

See inline

1) How can I QUICKLY view the code associated with a specific control?
If I right-click on the control, let's say a combo box, and select "View
Code" it seems to take me back to the last code I was viewing. I
would like to go directlly to the combo box event code. This is slowing me way down! In top of your IDE are 2 comboboxen in the left one you select the control
and in the right than the event.

Than by selecting the event it shows where that starts.

2) I have data in an ACCESS 2003 database. I have a form that has
several combo boxes and text boxes. Each of these has an associated
field in the database. I want to write code so that each time the user
selects something in any of the combo boxes, a search is done of the
database to find the associated record. If found, the text boxes are
filled with data from that record. It is also possible that there
will not be a matching record so then the user must manually input the
text boxes. What is the easiest way to do this with code. In VB 4.0
I opened a table a did a SQL query to pull up that record. I then set
each text box to the associated field. Im sure there is something
similar in .NET but I'm having difficulty grasping it. Please provide
a code example.

John that is no easy question to answer because it needs a lot of telling
about the database, about the dataset, about binding and about the combobox.
(Keep in mind that the text part of the combobox in dotNet is not the nicest
control to work with it has a lot of often unexpected behaviour)

Have a look in this resource kit and than at the section dataaccess first
for that I think that that can help you as well.

VB.net Resource kit
http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing the resource kit
http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

Another resource for learning is the Quick Starts
http://samples.gotdotnet.com/quickstart/

Know that a good resource for VB.net questions is this very active newsgroup

microsoft.public.dotnet.languages.vb

I hope this helps a little bit?

Cor