I crated a datagrid view that gets the data from the database. Now i need to get data from 2 tables which have a relationship
Item and Item Type
because i want to show the items grouoped by the item type.. Is it possible?
And you would like to get which columns, and show them in dgv? Use can fill DataTable with SELECT query, and bind dataTable to the dgv: [CODE] DataTable table = new DataTable(); //use sqlConnection and SqlCommand to create the command with this query: sting query = @"SELECT tblItem.Id, tblItem.Name, tblItem.Price, … Read More
Edited by Mitja Bonca: n/a