title: Is there any possible way to show all the material name in datagridview, even though the other column is empty?
body: <p>In my inventory program there was 3 tables in my database.
  1. Input
     Column(id,Material,Quantity)
  2. Output 
     Column(id,Material,Quantity)
  3. MaterialList (Table) Where I can input the names of materials
     Column(id,Material)</p>
  
  <p>In my remaining Stocks form I want to show the Remaining Stocks of all MaterialList including the material that has no stocks.</p>
  
  <p>For example:
  From MaterialList       From Input and Output Quantity
  Material list           Remaining Stocks
  item1                         150
  item2<br>
  item3<br>
  item4                         200</p>
  
  <p>I tried this but there's no hope.</p>
  
  <pre><code>   conn.Open()
          conn = New MySqlConnection
          conn.ConnectionString = "server=localhost;userid=root;password=SOUTHEAST;database=reportingsystem"
          Dim searchquery As String = "select reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials, reportingsystem.rawmaterialswarehouseandrawmaterials.safetystocks, (Sum(reportingsystem.rawmaterialsinput.Quantity) - sum(reportingsystem.rawmaterialsoutput.Quantity)) as 'Remaining Stocks' from reportingsystem.rawmaterialsinput, reportingsystem.rawmaterialsoutput, reportingsystem.rawmaterialswarehouseandrawmaterials where reportingsystem.rawmaterialsinput.RawMaterial = reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials" ' JOIN reportingsystem.rawmaterialsinput.RawMaterial ON reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials = reportingsystem.rawmaterialsinput.RawMaterial ORDER BY reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials"
          'Select rawmaterialsinput.DeliveryDate as 'Delivery Date', rawmaterialswarehouseandrawmaterials.Rawmaterials, (sum(rawmaterialsinput.Quantity) - sum(rawmaterialsoutput.Quantity)) as 'Quantity' , rawmaterialswarehouseandrawmaterials.safetystocks from reportingsystem.rawmaterialsinput, reportingsystem.rawmaterialsoutput, reportingsystem.rawmaterialswarehouseandrawmaterials where rawmaterialsinput.RawMaterial = rawmaterialsoutput.RawMaterial
          '"Select rawmaterialswarehouseandrawmaterials.Rawmaterials as 'Raw Materials', rawmaterialswarehouseandrawmaterials.safetystocks as 'Safety Stock', (sum(rawmaterialsinput.Quantity) - sum(rawmaterialsoutput.Quantity)) as 'Remaining Stocks' where rawmaterialsinput.RawMaterial = rawmaterialswarehouseandrawmaterials.Rawmaterials FROM reportingsystem.rawmaterialswarehouseandrawmaterials, reportingsystem.rawmaterialsinput, reportingsystem.rawmaterialsoutput"
          'Select rawmaterialswarehouseandmaterials.Rawmaterials, (sum(rawmaterialsinput.Quantity) - sum(rawmaterialsoutput.Quantity)) as 'Remaining Stocks', rawmaterialswarehouseandrawmaterials.safetystocks FROM reportingsystem.rawmaterialswarehouseandrawmaterials, reportingsystem.rawmaterialsinput, reportingsystem.rawmaterialsoutput JOIN input ON rawmaterialsinput.RawMaterial = rawmaterialswarehouseandrawmaterials.Rawmaterials
          Dim commander As New MySqlCommand(searchquery, conn)
          Dim adapter As New MySqlDataAdapter(commander)
  
          monitoringdata.Clear()
  
          adapter.Fill(monitoringdata)
  
          MonitoringDGV.DataSource = monitoringdata
  
          For Each row As DataGridViewRow In MonitoringDGV.Rows
              Dim quantity As Integer = Val(row.Cells(1).Value)
              Dim safetystocks As Integer = Val(row.Cells(2).Value)
              If safetystocks &lt; quantity Then
                  row.DefaultCellStyle.BackColor = Color.Red
  
              ElseIf safetystocks &lt; (quantity * 1.2) Then
  
                  row.DefaultCellStyle.BackColor = Color.Green
  
  
              ElseIf safetystocks &gt; (quantity * 1.2) Then
                  row.DefaultCellStyle.BackColor = Color.Green
  
              End If
          Next
          conn.Close()   
  </code></pre>
  
  <p>What I really need is show all of the Material Name in column 1 and show the remaining stocks in column 2.</p>
  
  <p>Example:</p>
  
  <p>Material        Remaining Stocks
  Item1                   1
  Item2                   4
  Item3<br>
  Item4
  Item5                   18
  Item6                   30
  Item7</p>