C#

using (SqlCommand mySqlCommand = new SqlCommand("SELECT * FROM MyTable", mySqlConnection))
{
    using (SqlDataReader mySqlDataReader = sqlCommand.ExecuteReader())
    {
        DataSet myDataSet = new DataSet();
        DataTable myDataTable = new DataTable();
        myDataSet.Tables.Add(myDataTable);
        myDataSet.Load(mySqlDataReader, LoadOption.PreserveChanges, myDataSet.Tables[0]);
        myDataGridView.DataSource = myDataSet.Tables[0];
    }
}

myDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
foreach(DataGridViewRow myRow in myDataGridView.Rows)
    // Do something with some of the values in the row

myDataGridView.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(myDataGridView_DataBindingComplete);

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