numrows with OleDbCommand

[Lemon]

Hi,

 

for example i have a query like this:

 

MyCommand = New OleDbCommand("SELECT id FROM games", MyConnection)

 

Now i need to know how i can get the number of rows that is selected, so an integer number.

 

 

And my second question is. A structual problem :)

If i have multible rows that are selected then i do

while MyCommand.read

..

End While

 

Now what is the best way to get the values if i only SELECT 1 row?

[betrl8thanever]

Hi,

 

for example i have a query like this:

 

MyCommand = New OleDbCommand("SELECT id FROM games", MyConnection)

 

Now i need to know how i can get the number of rows that is selected, so an integer number.

 

 

And my second question is. A structual problem :)

If i have multible rows that are selected then i do

while MyCommand.read

..

End While

 

Now what is the best way to get the values if i only SELECT 1 row?

 

 

MyCommand = New OleDbCommand("SELECT Count(*) FROM games", MyConnection)

[Robby]

Lemon are you talking about 'selected' items in a Datagrid?

[amir100]

To Lemon:

 

How 'bout inserting the result from executing the "MyCommand = ..." into a dataset, then you can get the number of rows using:

 

Dim num as Integer = MyDataSet.rows.Count;

 

~kindOfForgotTheMethodToUse :)

[Lemon]

Do you have a small tutorial how to use datasets?

[Robby]

http://samples.gotdotnet.com/QuickStart/winforms/default.aspx?url=/quickstart/winforms/doc/DataAccessPlaceHolder.aspx