datatable question

[Chuck Hecht]

Hello,
OK I understand that I can filter a datatable using either a dataview which
returns a bindable resultset or use the select method of the datatable whick
returns a array of found rows.

BUT how to I get from a datatable specific columns. Something like "SELECT
Item_num, Lot_num from sLineitems WHERE pronumber = 12345"

 

[Simon Hart]

Lookup the DataAdapter.Fill() method. This is the final bit of populating a
DataSet.

Simon.

 

[Ilya Tumanov [MS]]

Data in the DataTable is directly accessible. Simply Find() or Select()
row(s) matching your criteria (e.g. pronumber = 12345) and access fields in
this row as needed:




--
Best regards,



Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).