About DataGrid and SUM

  • Thread starter Thread starter Alberto
  • Start date Start date
A

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.
 
Only the "f1" field. And I want to see the "f1" and "ft" fields....
 
SO is there only one column with f1 or are there two columns and one is
blank?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bind datatable to a datagrid 3
XML into datagrid 3
Updating Data from a dataGrid 2
Datagrid column size 1
Datagrid - recognizing changes made 2
Re-Sorting a filtered Datagrid 1
I want to simple example about Data Grid.. 1
DataGrid Scrollbar problem 1

Back
Top