Which control to use?

[Estuardo]

G'd evening to all!!!

I'm new to Vb.Net and i would like to know if you can recommend a control to emulate a subform (Like in MS Access) to build the clasic Order-Items to add/edit rows with calculated columns.

i started with a dbGrid but i'm not sure if this is the right one.

All help is very welcome if you also can point me out for more infomation regarding the control to use will be so much appreciated.

 

Regards

Estuardo

[Robby]

Using a couple of datagrids on a form is one way to go, have a look at the following samples.

 

Here's for a web page ... http://www.dotnetjunkies.com/Tutorial/47792CB0-0990-4BD8-BF84-B6063C4C9BBC.dcik

 

 

WinForm ... http://support.microsoft.com/?kbid=308484

[Estuardo]

Robby:

Thanks again for your help. I saw the link you kindly supplied for win forms, unfortunately the sample is (in C#?) addresed to display one to many relationship and not to add/edit/delete rows that is what i acutally need :( and i couldn't find a single example!!. I have installed the samples and tutorials included in the sdk as well as 101 vb .net samples donwloaded from ms with no luck, all samples i'd found are for display.

Please if you don't mind giving me further assistence i'll deeply appreciate it.

Best regards

Estuardo

[Robby]

Hmm, I thoought the 101 would have such a sample. I'll see if I can find one.

[Estuardo]

Thanks again

 

Robby:

First of all my apoligizes for throwing out all my frustration here and specially to you, but this is really frustrating :( , i don't know if is my ignorance if is the lack of information, if is my programming background or all together!! i was able to learn by myself VB6/VBA/SQL/TSQL/ADO with no problems at all. My methodology is: buy books, read all i can, come to boards like this, read trheads and then try to put in practice all the theory... PLEASE tell me what am i doing wrong? i feel desperate... In Vb .net i can't even find a simple way to count records in a dataset... can't count rows displayed in a db grid, can't find the right control to work with, and a long long etc. The worst part is that i can'f find the information i need :( . When i come here to ask for help is no because i want others to solve my problems without try is totally the oposite.

One more time i'm sorry to use this board to expose my desception about .Net.

Thank you for all the help and assistence you kindly had gave me and my aploigizes if i made a wrong use of this space.

 

Regards

Estuardo

[Joe Mamma]

There is a bit of confusion coming from ADODB to ADO.Net.

 

Read the help to get an idea on the differences.

 

Look at setting up relationships in multi table datasets.

 

Remember a dataset in ADO.Net can have multiple datatables contained within with a relationship configured to keep the 'master' and 'detail' tables in sync.

Then setting a pair of grids datasources to thier respective master and detail will give you editing capabilities.

 

Too much to go into here but a good book on ADO.Net is highly recommended.

I might recommend a pair from o'reilly:

ADO.Net in a Nutshell

and

the ADO.Cookbook

 

Once you get the hang of it, you will find ADO.Net very intuitive

[Estuardo]

Joe:

Thank you for advice, i have a some general VB .net books, and i think that you're right i need more specialized books that has to be with my current developing area, ADO .Net will be my best bet.

 

Regards

Estuardo

 

 

P.D.

In Robby's website i found a very nice dbGrid demo (among others). I think it will be a good start. Thanks Robby