How Do I Change The Sign Of Number Before Showing It In Gridview

See more:

VB

DataGridView

Hello.

I am fetching a Number from sql database to a grid view. And the number is showing. But I want that even in case of a negative number, only the number without sign is showing.

following is the code i am using for each row of datagrid:

DataGridView1.Columns(0).DataPropertyName = "FAAMOB"


Pls help.
I have tried to use a function for changing the sign but not able to provide it with the number.

Dim DA As SqlDataAdapter = New SqlDataAdapter

DA.SelectCommand = New SqlCommand("Select FAAMOB from FAAM " , connection)


       Dim datatable As New DataTable
       DA.Fill(datatable)

       DataGridView1.AutoGenerateColumns = False
       DataGridView1.DataSource = datatable

       For Each row As DataGridViewRow In DataGridView1.Rows

               DataGridView1.Columns(0).DataPropertyName = "FAAMOB"
   Next