title: DataGridView - how to set the currency format for a single column ONLY
body: <p>I am trying to use the datagridview for a basket. I have got it to display the basket of the customer but I would like it to display the currency for the Price column, but i have a Quantity column as well, so if I put the default style as currency then it will change both columns to the currency format.</p>
  
  <p>What I want to be able to do is add the currency format to the Price Column but not to the quantity column. </p>
  
  <p>Here is the code that displays the basket (Form_load)</p>
  
  <pre><code>using (var con = new SqlConnection(connectionString))
          {
              SqlDataAdapter dataadapter =
            new SqlDataAdapter(
                "select p.productname 'Product Name', b.productquantity 'Quantity', c.categoryname 'Category', p.price 'Current Price' " +
                "from basket b join products p on b.productid = p.productid " +
                "join Categories c on c.categoryid = p.categoryid " +
                $"where b.customerid = {CustomerId}", con);
  
              DataSet ds = new DataSet();
              con.Open();
              dataadapter.Fill(ds);
              con.Close();
              dataGridView1.DataSource = ds.Tables[0].DefaultView;
          }
  </code></pre>
  
  <p>The CustomerId is collected from a txt file that stores the CustomerId when they log in. </p>
  
  <p>If there is any more code that you would like to see then comment and i will add it. </p>
  
  <p>This is what i get on the form with the currency added as the style.
  <a href="https://i.stack.imgur.com/wKEbf.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wKEbf.png" alt="enter image description here"></a></p>