result = DirectCast(parameters[0], Integer);>
/// <summary> /// Find Person Id from the Name /// </summary> /// <param name="Name">Person Name Last, First Middle</param> /// <param name="DOB">DOB</param> /// <param name="SiteID">SiteID</param> /// <returns>ID</returns> public static int? FindPersonID(string Name, DateTime DOB, int? SiteID) { int? result; SqlParameter[] parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("PersonID", SqlDbType.Int); parameters[0].Direction = ParameterDirection.Output; parameters[1] = new SqlParameter("FullName", SqlDbType.VarChar, 65); parameters[1].Value = Name.Trim(); parameters[2] = new SqlParameter("SiteID", SqlDbType.Int); parameters[2].IsNullable = true; parameters[2].Value = SiteID; parameters[3] = new SqlParameter("DOB", SqlDbType.DateTime); parameters[3].IsNullable = true; parameters[3].Value = DOB; Util.RunStoredProc("FindPersonByName", parameters); result = (int?)parameters[0].Value; return result; } /// <summary> /// /// </summary> /// <param name="Name"></param> /// <param name="SiteID"></param> /// <returns>ID</returns> public static int? FindPersonID(string Name, int? SiteID) { return FindPersonID(Name, DateTime.Now.AddYears(50) , SiteID); }Now I just have to add a check for that invalid DOB and pass null to my SP in this case.