Aravind Ranganathan
asked on
Invalid Attempt to read when no data is present.
I am trying to run a sql query store it in a sqldatareader and then retrieve those values and want to store into a session to be used by another webform.
the datareader says it hasrows but the error says no data is present its kind of a strange behavior.
the datareader says it hasrows but the error says no data is present its kind of a strange behavior.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks mate
ASKER
while(myrdr.Read())
{
UserRole = myrdr["Role"].ToString();
UserPlant = myrdr["Plant"].ToString();
}