Hi,
Is there any way a particular field can be accessed with a TableAdapter.
I mean like a TableAdapter returns a TataTable can we not access one partilucar field and use it as a parameter in some other query.

------------------------------------------------------------------------------------------------------------
Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic

__________________
------------------------------------------------------------------------------------------------------------
<b><i>Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic </i></b>

I'm no expert but, after you have created your dataTable with all the fields you want you can access the data in each field.

For example, if you run a query on your dataTable to find the first record and you have field called ID then libraryRow.ID will hold the ID of that first record.

Where "libraryDS" is the name of your dataTable

Dim LibraryAdapter As New libraryDSTableAdapters.LibraryTableAdapter
Dim libraryTable As libraryDS.LibraryDataTable
Dim libraryRow As libraryDS.LibraryRow

dear not expert friend
plz look at the date of question before answer

__________________
Always,
Hovik Melkomian.