title: how do i convert or display the color base on the color code inside the datagridview cell?
body: <p>I want to display a simple color on the background of the cells int the color column only?</p>
  
  <p><img src="https://i.stack.imgur.com/Pa0xB.png" alt="enter image description here"></p>
  
  <p><br>how do I display the color instead of the color code atleast the background color of the cell itself? btw i'm using the fullrowselect..</p>
  
  <p><br> my code for loading the database<br></p>
  
  <pre><code>SuspendLayout();
          using (MySqlConnection conn = new MySqlConnection(myConnection))
          {
              //string cell = dataGridView3.CurrentCell.Value.ToString();
              conn.Open();
              string query = "SELECT productid,description,color,quantity,unitprice FROM deqor.tblproducts where category=?cat;";
              using (MySqlCommand cmd = new MySqlCommand(query, conn))
              {
                  cmd.Parameters.AddWithValue("?cat", comboBox1.SelectedItem.ToString());
                  try
                  {
                      sda = new MySqlDataAdapter();
                      sda.SelectCommand = cmd;
                      datset = new DataTable();
                      sda.Fill(datset);
                      bsource = new BindingSource();
  
  
                      bsource.DataSource = datset;
                      dataGridView1.DataSource = bsource;
                      DataGridViewColumn column = dataGridView1.Columns[0];
                      column.HeaderText = "Code";
                      column.Width = 160;
                      DataGridViewColumn column1 = dataGridView1.Columns[1];
                      column1.HeaderText = "Brand";
                      column1.Width = 220;
                      DataGridViewColumn column2 = dataGridView1.Columns[2];
                      column2.HeaderText = "Color";
                      column2.Width = 100;
                      DataGridViewColumn column3 = dataGridView1.Columns[3];
                      column3.HeaderText = "Quantity";
                      column3.Width = 50;
                      DataGridViewColumn column4 = dataGridView1.Columns[4];
                      column4.HeaderText = "Price";
                      column4.Width = 50;
  
                      sda.Update(datset);
                      if (dataGridView1.RowCount &lt; 1)
                      {
                          datset.Clear();
  
                          string row = "NO items found";
                          datset.Rows.Add(row);
  
                      }
                  }
                  catch (Exception ex)
                  {
                      MessageBox.Show("" + ex);
                  }
              }
              conn.Close();
  
          }
          ResumeLayout();
  </code></pre>