Ok this makes no sense. Solved Somewhat

[BOUND4DOOM]

I posted all the code for the database transaction, maybe I have just been looking at it way too long but what the heck is going on. look at that page count variable especially. Simply add 1 to it. or so I think, for some reason no matter what I do it adds 2. I can;t figure this out, This is in a constructor for a class. that is just supposed to be indexing a counter and getting some data. I have tried everything I can think of but it keeps advancing 2. Anyone have any idea why. even if imediately right after that line I write out the result it is 2 more than what it was before, it is like the code is running twice but why? No I am not newing it up 2 times or anything in fact it is the only line of code on the web page, this is behind the scenes in an assembly

string SQLSelect = "Select PagePath,PageTitle,PageClass,HitCount,SecurePage,Maintenance From PageData Where PagePath = '" + RelativeURL + "'";
System.Data.SqlClient.SqlCommand CMD = new System.Data.SqlClient.SqlCommand(SQLSelect,DataBaseConnection);
System.Data.SqlClient.SqlDataReader RS = CMD.ExecuteReader();

if (RS.HasRows)
{
     RS.Read();
     pageTitle = RS.GetString(1);
     pageClass = RS.GetString(2);
     PageCount = RS.GetInt32(3) + 1; //this line here is the pain
     PageSecureDB = RS.GetString(4);
     PageMaintDB = RS.GetString(5);
     if (PageSecureDB.ToLower() != "yes")
     {
          pageSecure = false;
     }
     if (PageMaintDB.ToLower() != "yes")
     {
          pageMaintenance = false;
     }
     RS.Close();
     SQLSelect = "UPDATE PageData Set HitCount = " + PageCount.ToString() + " Where PagePath = '" + RelativeURL + "'";
     CMD = new System.Data.SqlClient.SqlCommand(SQLSelect,DataBaseConnection);
     CMD.ExecuteNonQuery();
}
else
{	
     RS.Close();
     SQLSelect = "INSERT INTO PageData (PagePath,PageTitle,PageClass,HitCount,SecurePage,Maintenance) VALUES ('" + RelativeURL + "','" + pageTitle + "','" + pageClass + "'," + PageCount.ToString() + ",'yes','yes')";
     CMD = new System.Data.SqlClient.SqlCommand(SQLSelect,DataBaseConnection);
     CMD.ExecuteNonQuery();
}