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?