ADO.NET using VB

[ericzaj]

I am creating a simple two form data access application. The first form
displays my main table that shows orders in an orders table. I have a command
button that opens a second form that show a related table that contains all
of the order details. I know there is a simple code that I can put in the
form load that will link the order detail form to the orders form based on
the orderid.
Any help is greatly appreciated.
Thank you,
ericzaj

[Cor Ligthert [MVP]]

Eric,

This is a general newsgroup. A nice newsgroup to start your questions and to
help you to find better ones

*Next* time you can place these questions like this better crossposted (if
your newsreader is able to do that) based on relevancy in the newsgroups

microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.framework.adonet

On this website you find in more ways answer on your question. I give you
one example because I don't even know what database you use.

http://www.windowsformsdatagridhelp....7-7bc3068aca2c

There are more samples on our website of this, by instance using textboxes,
SQL server instead of Access etc.

I hope this helps,

Cor

[ericzaj]

It is an Access database. I have all the bindings and dataadapters set
properly. All I need now is to be able to link a related form that gives
details about an order . If on the main form I am looking at orderid 123456,
I want the form that displays the details of all orders to open based on the
record of 123456.
Thank you,
ericzaj

"Cor Ligthert [MVP]" wrote:

Eric,

This is a general newsgroup. A nice newsgroup to start your questions and to
help you to find better ones

*Next* time you can place these questions like this better crossposted (if
your newsreader is able to do that) based on relevancy in the newsgroups

microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.framework.adonet

On this website you find in more ways answer on your question. I give you
one example because I don't even know what database you use.

http://www.windowsformsdatagridhelp....7-7bc3068aca2c

There are more samples on our website of this, by instance using textboxes,
SQL server instead of Access etc.

I hope this helps,

Cor

[Ralph]

Try relating the two tables, it is, as I see it, the order details table and
the order table must be related thru the order code. If you relate this two
tables, the datagrid will allow the user to "expand" the order and navigate
to the order detail table without having to open a new window or datagrid.

"ericzaj" wrote:

I am creating a simple two form data access application. The first form
displays my main table that shows orders in an orders table. I have a command
button that opens a second form that show a related table that contains all
of the order details. I know there is a simple code that I can put in the
form load that will link the order detail form to the orders form based on
the orderid.
Any help is greatly appreciated.
Thank you,
ericzaj