StrataFrame Forum

Group data from datatable

http://forum.strataframe.net/Topic6926.aspx

By Chan - 2/18/2007

Hi,
How could I retrieve datarow as sql below from datatable which its data still in datatable but not yet saved in database?

SELECT location from myDataTable GROUP BY location
By StrataFrame Team - 2/19/2007

You can use the MyBO.CurrentDataTable.Select() method.  It returns an array of DataRow objects that match whatever criteria you specify.  However, if you just want one field, you'll have to just iterate through the rows of the DataTable and get the values.