datatable question

  • Thread starter Thread starter Chuck Hecht
  • Start date Start date
C

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"
 
Lookup the DataAdapter.Fill() method. This is the final bit of populating a
DataSet.

Simon.
 
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).
 
Back
Top