title: Datatable to Gridview
body: <p>I am working on a project where i have to populate  the grid view using data table 
  so far i have  fill the data table from the query and i have displayed the result on data grid view using <code>datagridview.datasource = dt</code></p>
  
  <p>but now i want to to show the specific columns and its data to grid view   here is my sample form<a href="https://i.stack.imgur.com/qlfmW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qlfmW.png" alt="enter image description here"></a>
  in this form i have  fill the grid view  with the data source of data table  but  now i want to display the result in the other grid with specific column  like  if im_qty > 0 then it show as purchase Qty  other wise sale qty, also im rate to the rate column  how do i achieve that  please guide me .. </p>