public static bool MembershipIDExist(string strMembershipID) { ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider(); TblMember sqlMember = new TblMember(); try { sqlMember.MainConnectionProvider = connProvider; connProvider.OpenConnection(); return sqlMember.MembershipIDExists(strMembershipID); } finally { if (connProvider.DBConnection != null) { if (connProvider.DBConnection.State == ConnectionState.Open) connProvider.DBConnection.Close(); connProvider.DBConnection.Dispose(); } sqlMember.Dispose(); } }