Determine number of columns in oledbdatareader...

[lidds]

Determine number of rows in oledbdatareader...

I need to find out how many rows are in my datareader.

The code is as follows:

                Dim myReader As OleDb.OleDbDataReader = Nothing
                Dim myCmd As New OleDb.OleDbCommand("spQryIssue")
                myCmd.CommandType = CommandType.StoredProcedure
                myReader = myDB.RunMyDataQuery(myCmd)

Is there something like

myReader.rows.count()

I know you can do

Do While myReader.Read

but I physically need the number

Thanks

Simon

 

[Mister E]

I have not tried this, so you will have to give it a shot:

OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "spQryIssue";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Connection = // some OleDbConnection

OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;

DataSet ds = new DataSet();
da.Fill(ds);

foreach (DataTable dt in ds.Tables)
{
    Console.Write("ROW COUNT: " + dt.Rows.Count);
}

Basically you want to use a OleDbDataAdapter to fill a DataSet. Then access the individual DataTable objects in the DataSet.

 

[lidds]

Thanks, did not expect it to be that much hassle

Just out of interest there is probably only going to be no more than 10 rows in the dataReader, would it be quicker to loop through and count them rather than to do the DataSet route????

Thanks for your help

Simon

 

[Mister E]

Well, coding that is going to probably be a bigger hassle than what I posted. Plus, getting your results into a DataSet is a lot more useful throughout .NET.

 

[PlausiblyDamp]

What does your SQL look like? You could always use an output parameter in your stored proc to return @@rowcount or similar.

 

[HJB417]

The only problem with using datareaders is, I believe the values of the parameters arent set until the datareader is closed.

 

[lidds]

my sql is now

SELECT * FROM myTable
SELECT @@ROWCOUNT AS rowNum

But how do I get the rowcount value?? I have tried the following but does not seem to work.

MsgBox(myReader.Item("rowNum").ToString())

Thanks for all your help guys

Simon