About DataGrid and SUM

[Alberto]

Hi,

I have this code to fill a DataGrid:


Dim dt As New DataTable

SQL = "SELECT f1, SUM(f2) AS ft FROM table GROUP BY f1"

Dim adp As New System.Data.SqlServerCe.SqlCeDataAdapter(SQL, sqlConn)

dt.Clear()
adp.Fill(dt)
Grid.Visible = False
Grid.DataSource = dt
Grid.Visible = True

But this not display the "ft" field in my Grid. Wy??

Tx in advance.

 

[William Ryan eMVP]

Alberto:

What is appearing in the grid?

 

[Alberto]

Only the "f1" field. And I want to see the "f1" and "ft" fields....

 

[William Ryan eMVP]

SO is there only one column with f1 or are there two columns and one is
blank?

 

[Alberto]

only one column with f1 field correctly displayed