This sql statement
SELECT customer, value
FROM orders
ORDER BY customer
COMPUTE SUM(value)by customer
returns multiple results in Query Analyzer.
Can I get all these results into one datagridview.
I am doing
cmd.CommandText = sqlstatement
cmd.Connection = DataConnection
Dim r As SqlDataReader = cmd.ExecuteReader()
Dim myDataTable As New DataTable
myDataTable.Load(r)
r.Close()
grid1.DataSource = myDataTable
but only get results for the first customer with no total.
If not, how do you get a grid with control-break total lines,
TIA
SELECT customer, value
FROM orders
ORDER BY customer
COMPUTE SUM(value)by customer
returns multiple results in Query Analyzer.
Can I get all these results into one datagridview.
I am doing
cmd.CommandText = sqlstatement
cmd.Connection = DataConnection
Dim r As SqlDataReader = cmd.ExecuteReader()
Dim myDataTable As New DataTable
myDataTable.Load(r)
r.Close()
grid1.DataSource = myDataTable
but only get results for the first customer with no total.
If not, how do you get a grid with control-break total lines,
TIA
