returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows() public static method

public static returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows ( string sqlQuery ) : ArrayList
sqlQuery string
return System.Collections.ArrayList
SqlServerEngine Class Documentation
Example #1
0
        public static string recalculateAllAccountsBalances()
        {
            string    result       = "";
            string    sqlQuery     = "select account_no from  fsb_accounts";
            ArrayList bankAccounts = SqlServerEngine.returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows(sqlQuery);

            foreach (object account in bankAccounts)
            {
                result += recalculateAccountBalance((string)account);
            }
            return(result);
        }
Example #2
0
        public static ArrayList GetAccountTransactions_using_AccountID(string accountID)
        {
            string sqlQuery = "select transaction_id from  fsb_transactions  where account_no = '" + accountID + "'";

            return(SqlServerEngine.returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows(sqlQuery));
        }
Example #3
0
        // WS_AccountManagement.asmx Methods
        #region AccountManagement
        public static ArrayList GetUserAccounts_using_userID(string userID)
        {
            string sqlQuery = "select account_no from  fsb_accounts where user_ID = " + userID;

            return(SqlServerEngine.returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows(sqlQuery));
        }
Example #4
0
        // WS_UserManagement.asmx Methods
        #region UserManagement
        public static ArrayList ListCurrentUsers()
        {
            string sqlQuery = "select user_name from  fsb_users";

            return(SqlServerEngine.returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows(sqlQuery));
        }