Question Adding and retrieving data’s from two different tables.

[shajilt]

Hi,

I am just a beginner with VB.NET,

I have two tables in my database, one made as a master table and that we can call as ‘tbl_Master’ , the other one has got a grocery list in it and that we can call ‘tbl_groceries’.

For example,
A shopping cart program,.

Person A wants to buy some groceries, and I want create a record for Person A that he is buying groceries, like in the first column ‘Persons’ and second ‘Items’. So in first column will be adding Person A, and in the second one will be adding the ID’s of items for the other list tbl_groceries.

The same thing I want to retrieve to a DataGrid as well.

So this is my concept, please can I have some hint how to make it happen,

Thank you,

 

[jmcilhinney]

You've asked a very broad question there. If you want to learn how to work with data in applications then you might start by following the Data Walkthroughs link in my signature. That will show you, amongst other things, how to connect the UI of an application with a database and flow data between them.