For the user you are trying to get have you checked that the SQL returns non NULL values and values that can be converted to the types you are converting to? I.e. run the SQL in Management Studio and check that...

• <div mce_keep="true">Column UserID can be converted to Type Int and is not Null</div>
• <div mce_keep="true">Colum TextMiles can be converted to type int and is not Null</div>
• <div mce_keep="true">etc..
  </div>