title: Showing data from related tables in single datagridview
body: <p>I have some tables in the db:</p>
  
  <pre><code>Items             Manufacturers       Categories      Cities      Regions
  ==============    ================    ============    ========    ==========
  ItemId            ManufacturerId      CategoryId      CityId      RegionId
  ManufacturerId    CityId              NameCategory    RegionId    NameRegion
  CategoryId        NameManufacturer                    NameCity
  NameItem
  Weight
  </code></pre>
  
  <p>I am displaying the list of the items in <code>DataGridView</code> using this code:</p>
  
  <pre><code>DataSet ds = new DataSet();
  SqlDataAdapter da = new SqlDataAdapter("select * from Items", connectionString);
  
  SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);
  da.Fill(ds, "Items");
  dataGridView1.DataSource = ds.Tables[0];
  </code></pre>
  
  <p>I also have  button that save the changes in the <code>DataGridView</code> with this code:</p>
  
  <pre><code>da.Update(ds, "Items");
  </code></pre>
  
  <p>I want to replace two columns in datagridview - <code>ManufacturerId</code> and <code>CategoryId</code> with the <code>NameManufacturer</code> and <code>NameCategory</code> from related tables. So those two columns should be ComboBox with all possible names from related tables - to be able to change the <code>Category</code> or <code>Manufacturer</code> to other and save it using da.Update().</p>
  
  <p>I also need to add three combobox filters for the datagridview:
  <code>Category</code>, <code>City</code> and <code>Region</code>, that will filter the displayed items in the datagridview by selected values in those filters.</p>
  
  <p>I can't use wizard creator, I have to do it all in the code.
  If you could give me some ideas related to any part of this, will be great.</p>