[Vb.net] bind multi table to datagridview

See more:

VB

SQL-Server

I currently work on a project. My project is to manage the inventory of a small business. I currently have a database with SQL server 2014. My database contains several tables including 5 table that is : "Inventory", "Product", "Location", Department", "Provider".

I am currently using the offline method ado.net. (I can't use linq :( )

So yeah, I need to select certain field of 5 tables listed above and bind to a datagridview.

For example, i want to take code,description,tax,price from product. Quantity, company from inventory. Description from location. DepartmentCode from department. providerCode from provider and bind all that field into 1 datagridview.

Im currently using a "strongly typed dataset" that contain my entire database.


If you need more information, just ask it !

Thanks guys!

ps: currently new with the database so be nice! ;)

pps: Sorry for my english, this is not my first language!

What I have tried:

I did several research before ask a question here, some people say to take all the information and deposit in a datatable. Is it the good way? Is he a better method to do? Maybe i can use stored procedure?