I have the following code: SqlCommand cmd2 = new SqlCommand("SELECT ClaimId FROM tblPayment WHERE PaymentId = " + PaymentID.ToString(), mvarDBConn); SqlDataReader reader = cmd2.ExecuteReader(); reader.Read(); Int32 ClaimId = reader.GetInt32(0); reader.Close(); If I run the SELECT statement in SQL it returns the number fine, but when I use ExecuteReader all it returns is 0. I've tried multiple methods including ExecuteScalar, ExecuteNonQuery, reader.GetString then casting that to an int, etc. What am I missing? Thanks.