How to query the table in a dataset?

[Cylix]

I am using vs2003,
How can I do the job like
select studentID from student where studentName='Jay'
Do I need to iterate the datatable of the dataset row by row?
Or I can query it?

[Cor Ligthert [MVP]]

Cylix,

This is the most simple AdoNet there is.

There are probably hundreds of solution for this, therefore can you tell
something more.

Basicly you can use a DataReader, a DataAdapter(which uses a datareader) or
a TableAdapter (which is an inherited datadapter), those standard in the
tasts for Oracle, for SQLClient or for OleDB.

So can you write something more what is the goal from this select?

Cor

"Cylix" <cy*******@gmail.comschreef in bericht
news:11**********************@74g2000cwt.googlegro ups.com...

>I am using vs2003,
How can I do the job like
select studentID from student where studentName='Jay'
Do I need to iterate the datatable of the dataset row by row?
Or I can query it?

[Ken Tucker [MVP]]

Hi,

You can use datatable.select to find a record with its primary key.
Dataview.find will return the row number on a sorted column.

http://msdn2.microsoft.com/en-us/library/h71xaeh0.aspx

http://msdn2.microsoft.com/en-us/library/18kktzs4.aspx

Ken
------------------------
"Cylix" <cy*******@gmail.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...

>I am using vs2003,
How can I do the job like
select studentID from student where studentName='Jay'
Do I need to iterate the datatable of the dataset row by row?
Or I can query it?

[Brian Tkatch]

Cylix wrote:

I am using vs2003,
How can I do the job like
select studentID from student where studentName='Jay'
Do I need to iterate the datatable of the dataset row by row?
Or I can query it?

In 2005 (not sure about 2003) results can be filtered via
DataTable.Select().

B.

[Cor Ligthert [MVP]]

Cylix,

I see that I have misread your question.

In my idea is the simplest answer on your question.

Datatable.defaultview.rowfilter = "studentName = Jay"

Both a select and this one returns a table however the dataview (what is
this above) is about the original table.

You can access this table now by
Datatable.defaultview

I hope this helps,

Cor
"Cor Ligthert [MVP]" <no************@planet.nlschreef in bericht
news:Od**************@TK2MSFTNGP06.phx.gbl...

Cylix,

This is the most simple AdoNet there is.

There are probably hundreds of solution for this, therefore can you tell
something more.

Basicly you can use a DataReader, a DataAdapter(which uses a datareader)
or a TableAdapter (which is an inherited datadapter), those standard in
the tasts for Oracle, for SQLClient or for OleDB.

So can you write something more what is the goal from this select?

Cor

"Cylix" <cy*******@gmail.comschreef in bericht
news:11**********************@74g2000cwt.googlegro ups.com...

>>I am using vs2003,
How can I do the job like
select studentID from student where studentName='Jay'
Do I need to iterate the datatable of the dataset row by row?
Or I can query it?