"Invalid attempt to read when no data is present"

[MarkusR]

If I run the stored proc in the Query Analyzer this works and I get the
expected result set back. However when I run it in my application I get
a results set of one row but when I try to access the values I get
"Invalid attempt to read when no data is present".

private void GetLotIDPriorit yFromLot(string aLotDesc, out int aLotID,
out DateTime aPriorityDate)
{
SqlConnection Conn;
SqlDataReader reader = null;

aLotID = 0;
aPriorityDate = DateTime.Today;

Conn = new SqlConnection(" user id=myuserid;"
+"password=mypw d;"
+"server=myserv er;"
+"database=myda tabase;"
+"connection timeout=30");
Conn.Open();
try
{
SqlCommand cmd =
new SqlCommand("sp_ GetLotIDPriorit yFromLot",
Conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ lot", aLotDesc));
reader = cmd.ExecuteRead er();

if (reader.HasRows )
{
--- aLotID =
Convert.ToInt32 (reader[0].ToString());
aPriorityDate =
Convert.ToDateT ime(reader[1].ToString());
}
}
finally
{
if (reader != null)
reader.Close();
if (Conn != null)
Conn.Close();
}
}

Any thoughts?

-Markus_R

[Peter Bromberg [C# MVP]]

Markus_R,
It might help a lot if you put a catch block in there between the try and
the finally and output the exception Message and StackTrace properties, say,
to the output window with Debug.WriteLine .

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"MarkusR" wrote:

If I run the stored proc in the Query Analyzer this works and I get the
expected result set back. However when I run it in my application I get
a results set of one row but when I try to access the values I get
"Invalid attempt to read when no data is present".

private void GetLotIDPriorit yFromLot(string aLotDesc, out int aLotID,
out DateTime aPriorityDate)
{
SqlConnection Conn;
SqlDataReader reader = null;

aLotID = 0;
aPriorityDate = DateTime.Today;

Conn = new SqlConnection(" user id=myuserid;"
+"password=mypw d;"
+"server=myserv er;"
+"database=myda tabase;"
+"connection timeout=30");
Conn.Open();
try
{
SqlCommand cmd =
new SqlCommand("sp_ GetLotIDPriorit yFromLot",
Conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ lot", aLotDesc));
reader = cmd.ExecuteRead er();

if (reader.HasRows )
{
--- aLotID =
Convert.ToInt32 (reader[0].ToString());
aPriorityDate =
Convert.ToDateT ime(reader[1].ToString());
}
}
finally
{
if (reader != null)
reader.Close();
if (Conn != null)
Conn.Close();
}
}

Any thoughts?

-Markus_R

[MarkusR]

Hey Peter,

It looks like I need:

reader.Read();

above:
if (reader.HasRows )

I had to close/reopen VS2005 before even that would take. VS2005 must
have been in a bad mood. I even tried build/rebuild.

-Markus

Peter wrote:

Markus_R,
It might help a lot if you put a catch block in there between the try and
the finally and output the exception Message and StackTrace properties, say,
to the output window with Debug.WriteLine .

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"MarkusR" wrote:

If I run the stored proc in the Query Analyzer this works and I get the
expected result set back. However when I run it in my application I get
a results set of one row but when I try to access the values I get
"Invalid attempt to read when no data is present".

private void GetLotIDPriorit yFromLot(string aLotDesc, out int aLotID,
out DateTime aPriorityDate)
{
SqlConnection Conn;
SqlDataReader reader = null;

aLotID = 0;
aPriorityDate = DateTime.Today;

Conn = new SqlConnection(" user id=myuserid;"
+"password=mypw d;"
+"server=myserv er;"
+"database=myda tabase;"
+"connection timeout=30");
Conn.Open();
try
{
SqlCommand cmd =
new SqlCommand("sp_ GetLotIDPriorit yFromLot",
Conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ lot", aLotDesc));
reader = cmd.ExecuteRead er();

if (reader.HasRows )
{
--- aLotID =
Convert.ToInt32 (reader[0].ToString());
aPriorityDate =
Convert.ToDateT ime(reader[1].ToString());
}
}
finally
{
if (reader != null)
reader.Close();
if (Conn != null)
Conn.Close();
}
}

Any thoughts?

-Markus_R

[Otis Mukinfus]

On 31 Aug 2006 14:29:52 -0700, "MarkusR" <ma*******@gmai l.comwrote:

>Hey Peter,

It looks like I need:

reader.Read();

above:
if (reader.HasRows )

<snip>

If you put it above if(reader.HasRo ws), it will throw an error if there are no
rows. It should be like this:

If(reader.HasRo ws)
{
reader.Read();
..
..
..
}
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

[MarkusR]

thanks Otis.

-Markus_R

Otis Mukinfus wrote:

On 31 Aug 2006 14:29:52 -0700, "MarkusR" <ma*******@gmai l.comwrote:

Hey Peter,

It looks like I need:

reader.Read();

above:
if (reader.HasRows )

<snip>

If you put it above if(reader.HasRo ws), it will throw an error if there are no
rows. It should be like this:

If(reader.HasRo ws)
{
reader.Read();
.
.
.
}
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com