invalid attempt to read when no data is present

Aligahk06 -

4y1.5k.NET

Dear All,

Following error encountered while attempting to read dropdown to correspond text box.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Source Error:

Line 52:
Line 53: dr1.Read();
Line 54: txtRegRoomNo.Text = dr1["roomno"].ToString();
Line 55: txtRegRate.Text = dr1["rate"].ToString();
Line 56:

Source File: e:\LiveProject\AdminDreamPanel_HMS\Admin\index.aspx.cs Line: 54

Please your valuable guidance and help.

Rgds,

aligahk06

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki4y ago
Hi, First you need to check data is present or not and then only assign the value to the textbox.
+1

Rijwan Ansari4y ago

You can check values then do read

example

dr1.Read();
if (dr1.HasRows) {  
    txtRegRoomNo.Text = drl["roomno"].ToString();  
    txtRegRate.Text = drl["rate"].ToString();  
}

Sachin Singh4y ago
Modify your code as
While(dr1.Read())
{
txtRegRoomNo.Text = dr1["roomno"].ToString();
xtRegRate.Text = dr1["rate"].ToString();
}
if you have data then above code should work.
+3
Nitin Sontakke4y ago
Hello,

Just as the exception states, there is no data available to read.

Meaning, your data reader dr1 has no rows to read from.

dr1.Read() method does return True if data is found or False if it doesn't.

Before going on to row number 54 to read the data, you should ideally be checking that value.

Boolean hasData = dr1.Read();
if(hasData)
{
// Your code goes here....
}

Hope it helps!
+1