"PeteZ" <peteZ@aol.com> wrote in message
news:eLmEGz0bDHA.2672@tk2msftngp13.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.FieldCount (which I
> expect but whenever I try and reference the data in the row
> (oSQLDR.GetInt32(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.Connection = m_oSqlConnection; // A valid connection Object
> is here
> oSqlCmd.CommandText = "getEvents";
> oSqlCmd.CommandType = CommandType.StoredProcedure;
>
> SqlDataReader oSQLDR = oSqlCmd.ExecuteReader();
> int iRows = oSQLDR.FieldCount;
> iRowsAffected = oSQLDR.RecordsAffected;
>
> int iID = oSQLDR.GetInt32(0);
>
> <snip>
>
> - peteZ
>
>

"PeteZ" <peteZ@aol.com> wrote in message
news:eLmEGz0bDHA.2672@tk2msftngp13.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.FieldCount (which I
> expect but whenever I try and reference the data in the row
> (oSQLDR.GetInt32(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.Connection = m_oSqlConnection; // A valid connection Object
> is here
> oSqlCmd.CommandText = "getEvents";
> oSqlCmd.CommandType = CommandType.StoredProcedure;
>
> SqlDataReader oSQLDR = oSqlCmd.ExecuteReader();
> int iRows = oSQLDR.FieldCount;
> iRowsAffected = oSQLDR.RecordsAffected;
>
> int iID = oSQLDR.GetInt32(0);
>
> <snip>
>
> - peteZ
>
>

"Wim Hollebrandse" <wimATwimdows.com> wrote in message
news:%23Rv72e1bDHA.1492@TK2MSFTNGP12.phx.gbl...
> In addition to my last post. If you only want the first record:
>
> if (SQLDR.Read())
> {
> Console.WriteLine("My value: {0}",SQLDR.GetInt32(0));
> }
> else
> {
> Console.WriteLine("No records found.");
> }
>
> Cheers,
> Wim Hollebrandse
> http://www.wimdows.com
> http://www.wimdows.net
>
> "PeteZ" <peteZ@aol.com> wrote in message
> news:eLmEGz0bDHA.2672@tk2msftngp13.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.FieldCount (which I
> > expect but whenever I try and reference the data in the row
> > (oSQLDR.GetInt32(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.Connection = m_oSqlConnection; // A valid connection
Object
> > is here
> > oSqlCmd.CommandText = "getEvents";
> > oSqlCmd.CommandType = CommandType.StoredProcedure;
> >
> > SqlDataReader oSQLDR = oSqlCmd.ExecuteReader();
> > int iRows = oSQLDR.FieldCount;
> > iRowsAffected = oSQLDR.RecordsAffected;
> >
> > int iID = oSQLDR.GetInt32(0);
> >
> > <snip>
> >
> > - peteZ
> >
> >
>
>