In my SQL I get a value from calculating two fields. I want to place this value in my datagrid. I'm having trouble mapping it in my dg-stylesheet.

VB Code:
  1. Dim cmdView As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("select check_no, purchase_date, vendor_payee, check_amt, " & _
  2.         [B]"(check_amt-returned_amt) as purchase_amt[/B], returned_amt, approver_id, " & _
  3.         "from pccr.pccr_check_header, pccr.pccr", objCon)
  4.  
  5. Dim grdColStyle5 As New DataGridTextBoxColumn()
  6.         With grdColStyle5
  7.             .HeaderText = "Purchase Amt"
  8.             .MappingName = "purchase_amt"
  9.             .Format = "$#.##"
  10.             .Width = 77
  11.             .Alignment = HorizontalAlignment.Center