Sum a dataset column

[orb353]

I want to sum a dataset column and insert that total in a text box.How can I get this done?

Orb353

 

[dalchri]

Dim txt As TextBox
Dim tbl As DataTable

txt.Text = tbl.Compute("SUM(MyColumn)", "").ToString()

More info here:

http://msdn.microsoft.com/library/d...frlrfsystemdatadatatableclasscomputetopic.asp