SqlDataReader question

[PeteZ]

I'm having a problem where I exec a stored procedure (which SELECTs all rows
from a table, which has 100 rows) - each row has 8 columns.

When I exec the code (see below) I get 8 in oSQLDR.FieldCou nt (which I
expect but whenever I try and reference the data in the row
(oSQLDR.GetInt3 2(0);) I get an exception "invalid attempt to read when no
data is present". If I exec the SP in an ISQL window using: EXEC getEvents,
I get 100 rows returned.

What am I missing here ?
<snip>

oSqlCmd = new SqlCommand();
oSqlCmd.Connect ion = m_oSqlConnectio n; // A valid connection Object
is here
oSqlCmd.Command Text = "getEvents" ;
oSqlCmd.Command Type = CommandType.Sto redProcedure;

SqlDataReader oSQLDR = oSqlCmd.Execute Reader();
int iRows = oSQLDR.FieldCou nt;
iRowsAffected = oSQLDR.RecordsA ffected;

int iID = oSQLDR.GetInt32 (0);

<snip>

- peteZ

[Wim Hollebrandse]

You need to call the Read() method first on your SqlDataReader object, to
advance to the first row in your result set. Likewise for subsequent
records.

Use a loop to read through all the rows returned, like so:

while (SQLDR.Read())
{
// do something and access SQLDR.GetInt32( 0)...
}

Hope that helps.

Cheers,
Wim Hollebrandse
http://www.wimdows.com
http://www.wimdows.net

"PeteZ" <pe***@aol.co m> wrote in message
news:eL******** ******@tk2msftn gp13.phx.gbl...

I'm having a problem where I exec a stored procedure (which SELECTs all rows from a table, which has 100 rows) - each row has 8 columns.

When I exec the code (see below) I get 8 in oSQLDR.FieldCou nt (which I
expect but whenever I try and reference the data in the row
(oSQLDR.GetInt3 2(0);) I get an exception "invalid attempt to read when no
data is present". If I exec the SP in an ISQL window using: EXEC getEvents, I get 100 rows returned.

What am I missing here ?
<snip>

oSqlCmd = new SqlCommand();
oSqlCmd.Connect ion = m_oSqlConnectio n; // A valid connection Object
is here
oSqlCmd.Command Text = "getEvents" ;
oSqlCmd.Command Type = CommandType.Sto redProcedure;

SqlDataReader oSQLDR = oSqlCmd.Execute Reader();
int iRows = oSQLDR.FieldCou nt;
iRowsAffected = oSQLDR.RecordsA ffected;

int iID = oSQLDR.GetInt32 (0);

<snip>

- peteZ

[Wim Hollebrandse]

In addition to my last post. If you only want the first record:

if (SQLDR.Read())
{
Console.WriteLi ne("My value: {0}",SQLDR.GetI nt32(0));
}
else
{
Console.WriteLi ne("No records found.");
}

Cheers,
Wim Hollebrandse
http://www.wimdows.com
http://www.wimdows.net

"PeteZ" <pe***@aol.co m> wrote in message
news:eL******** ******@tk2msftn gp13.phx.gbl...

I'm having a problem where I exec a stored procedure (which SELECTs all rows from a table, which has 100 rows) - each row has 8 columns.

When I exec the code (see below) I get 8 in oSQLDR.FieldCou nt (which I
expect but whenever I try and reference the data in the row
(oSQLDR.GetInt3 2(0);) I get an exception "invalid attempt to read when no
data is present". If I exec the SP in an ISQL window using: EXEC getEvents, I get 100 rows returned.

What am I missing here ?
<snip>

oSqlCmd = new SqlCommand();
oSqlCmd.Connect ion = m_oSqlConnectio n; // A valid connection Object
is here
oSqlCmd.Command Text = "getEvents" ;
oSqlCmd.Command Type = CommandType.Sto redProcedure;

SqlDataReader oSQLDR = oSqlCmd.Execute Reader();
int iRows = oSQLDR.FieldCou nt;
iRowsAffected = oSQLDR.RecordsA ffected;

int iID = oSQLDR.GetInt32 (0);

<snip>

- peteZ

[PeteZ]

wim

thanks mate

peteZ

"Wim Hollebrandse" <wimATwimdows.c om> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

In addition to my last post. If you only want the first record:

if (SQLDR.Read())
{
Console.WriteLi ne("My value: {0}",SQLDR.GetI nt32(0));
}
else
{
Console.WriteLi ne("No records found.");
}

Cheers,
Wim Hollebrandse
http://www.wimdows.com
http://www.wimdows.net

"PeteZ" <pe***@aol.co m> wrote in message
news:eL******** ******@tk2msftn gp13.phx.gbl...

I'm having a problem where I exec a stored procedure (which SELECTs all

rows

from a table, which has 100 rows) - each row has 8 columns.

When I exec the code (see below) I get 8 in oSQLDR.FieldCou nt (which I
expect but whenever I try and reference the data in the row
(oSQLDR.GetInt3 2(0);) I get an exception "invalid attempt to read when no data is present". If I exec the SP in an ISQL window using: EXEC

getEvents,

I get 100 rows returned.

What am I missing here ?
<snip>

oSqlCmd = new SqlCommand();
oSqlCmd.Connect ion = m_oSqlConnectio n; // A valid connection Object is here
oSqlCmd.Command Text = "getEvents" ;
oSqlCmd.Command Type = CommandType.Sto redProcedure;

SqlDataReader oSQLDR = oSqlCmd.Execute Reader();
int iRows = oSQLDR.FieldCou nt;
iRowsAffected = oSQLDR.RecordsA ffected;

int iID = oSQLDR.GetInt32 (0);

<snip>

- peteZ