C#

public string[] CreateNewTransaction(int UserID) // note the use of string[] as the method return type
        {
            // create an array to hold method results
            string[] returnArray = new string[2];

            string selectSql = "SELECT Count(*) FROM AccountTransactions WHERE UserID = @UserID";

            // new SqlConnection
            connect = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename='C:\\Users\\Ed\\Documents\\Visual Studio 2010\\Projects\\School Projects\\Accounts\\Accounts\\Accounts.mdf';Integrated Security=True;User Instance=True");

            // initialize SqlDataAdapter
            dataAdapter = new SqlDataAdapter();

            SqlCommand cmd = new SqlCommand(selectSql, connect);

            dataAdapter.SelectCommand = cmd;

            // parameters for cmd
            cmd.Parameters.AddWithValue("@UserID", UserID);

            // create a new DataSet
            dataSet = new DataSet();
                        
            dataAdapter.Fill(dataSet, "AccountTransactions");

            // create variable equal to the count of rows in the database and set the DataRow to that row number
            int lastRow = dataSet.Tables["AccountTransactions"].Rows.Count-1;
            DataRow dRow = dataSet.Tables["AccountTransactions"].Rows[lastRow];
                        
            returnArray[0] = Convert.ToString(dataSet.Tables["AccountTransactions"].Rows[lastRow]["Balance"]);
            returnArray[1] = Convert.ToString(dataSet.Tables["AccountTransactions"].Rows[lastRow]["TransactionNo"]);

            connect.Dispose();

            return returnArray;
        }

client = new TcpClient(host, port);
setClient(client);