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(); } }