Already Data Reader Open

[yarrakabi]

I am trying to write an if then else statement using ASP.NET, but I get an error that there is already a data reader open, although I have clearly closed it before trying to executre the non-query. What would be the correct way to write this?<BR><BR>with myCommand2<BR>myDataReader2 = myCommand2.ExecuteReader()<BR><BR>if not (myDataReader2.Read())<BR>response.write ("BOOTS")<BR>myDataReader2.Close()<BR><BR>else<BR>myCommand.ExecuteNonQuery()<BR><BR>end if<BR>end with<BR>Try putting the myDataReader2.Close() in the Else block with the ExecuteNonQuery() command.