title: datagridview columns in VB.net
body: <p><img src="https://i.stack.imgur.com/VLMuV.jpg" alt="check this image"></p>
  
  <p>I have 7 tables of COA as shown in the picture attached. What I need is whenever opening balance goto - (negative), the type must automatically show CR sign and whenever that account goto positive +, it must change to DR automatically.</p>
  
  <p>EDIT<br>
  from comments :</p>
  
  <pre><code>/****** Script for SelectTopNRows command from SSMS ******/ 
  SELECT TOP 1000    
         [AccountID] ,
         [Account_Title] ,
         [opening_balance] ,
         [Account_group] ,
         [Group_subHead] ,
         [Accounts_categories] ,
         [type] 
   FROM [dbo_main].[dbo].[COA]
  </code></pre>