title: There is already an open DataReader associated with this Command which must be closed first.Why?
body: <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      MultiView1.ActiveViewIndex=0;
          string str = "SELECT t1.UsrFLname from Registration t1 JOIN IMSLogin t2 on t1.RegId = t2.RegId and t2.Uname =  '" + Login1.UserName + "'";
          con.Open();
          SqlCommand cmdr = new SqlCommand(str, con);
          SqlDataReader dr = cmdr.ExecuteReader(); 
  
          if (cmdr.ExecuteReader().HasRows)//here showing the error as the title i gave.
          {
              Session["userName"] = Login1.UserName.Trim();
              string myStringVariable = "Welcome! ";
              ClientScript.RegisterStartupScript(this.GetType(), "myAlert", "alert('" + myStringVariable + Login1.UserName + "');", true);
              //dr.Dispose();
          }
          else
          {
              string myStringVariable = " No Username Found";
              ClientScript.RegisterStartupScript(this.GetType(), "myAlert", "alert('" + myStringVariable + "');", true);           
          }
  
          con.Close();
   }
  </code></pre>
  
  <p>I used datareader object dr in the same page in other events too...
  Plz help....</p>