da.Fill(dsOrders, "orders")

            dgCustomers.DataSource = dsOrders
            dgCustomers.DataMember = "orders"

            dgCustomers.Columns("Price").DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
            dgCustomers.Columns("Tax").DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
            dgCustomers.Columns("TotalSale").DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight

		'---format as currency (has $)
            dgCustomers.Columns("Price").DefaultCellStyle.Format = "c"   
            dgCustomers.Columns("Tax").DefaultCellStyle.Format = "c"
            dgCustomers.Columns("TotalSale").DefaultCellStyle.Format = "c"




  '---to show the $ sign, use c or c2 instead of n2. The n2 means format as number with 2 decimals & no $ sign
            dgCustomers.Columns("Price").DefaultCellStyle.Format = "n2"
            dgCustomers.Columns("Tax").DefaultCellStyle.Format = "n2"
            dgCustomers.Columns("TotalSale").DefaultCellStyle.Format = "n2"