C#

public void buildRounds(int fields, int times, int eventId)
{
	OleDbConnection oConn;
	OleDbCommand oComm;

	OleDbDataAdapter adapter;
	DataSet data = new DataSet();
	string sSql;
	int totalTeams;
	int foo;			
	int currentField = 1;
	int currentRound = 1;
	Random random = new Random();

	oConn = new OleDbConnection(connectionString);

	try
	{
		oConn.Open();

		for(int rounds=1;rounds<=times;rounds++)
		{
			//gets number of teams in event
			sSql = "SELECT count(*) from eventDtl where eventID = " + eventId;

			oComm = new OleDbCommand(sSql, oConn);

			totalTeams = Convert.ToInt32(oComm.ExecuteScalar());

			//selects all teams in event to load into array
			sSql = "SELECT teamID from eventDtl where eventID = " + eventId;

			oComm = new OleDbCommand(sSql, oConn);
			adapter = new OleDbDataAdapter(oComm);
			data = new DataSet();

			adapter.Fill(data);
		
			ArrayList array = new ArrayList(); //holds individual teams
			ArrayList teamBuffer = new ArrayList(); //team buffer for checking back to back games
			ArrayList rawMatches = new ArrayList(); //holds raw matches

			//populates the array with the team list...
			foreach(DataTable myTable in data.Tables)
			{
				foreach(DataRow myRow in myTable.Rows)
				{
					array.Add(myRow["teamID"]);
				}
			}

			foo = array.Count;

			for(int i = 0;i<foo;i++)
			//creates raw matches and loads into array
			{	
				for(int j=i+1;j<foo;j++)
				{
					rawMatches.Add(array[i] + " " + array[j]);
				}
			}

			foo = rawMatches.Count;
			
			while(foo>0)
			{
				if(teamBuffer.Count > 4)
				//buffer to check teams playing back to back.  pops oldest 2 entires if stack is over 4
				{
					teamBuffer.RemoveAt(0);
					teamBuffer.RemoveAt(0);}

					int myIndex = 0;
					int team1;
					int team2;
					int match;
					int counter = 1;
					do
					//generates random match from list and looks through the buffer to see if teams have played recently.  
					//if teams played recently, it pulls another match.
					{
						match = random.Next(0,foo);

						if(currentField>fields)
						{
							currentField=1;
							currentRound++;
						}

						string [] teams = rawMatches[match].ToString().Split(' ');
					
						team1 = Convert.ToInt32(teams[0]);
						team2 = Convert.ToInt32(teams[1]);
					
						if(counter > foo){
							myIndex = 0;
							break;}
						if(foo>4)
						//skips repeat match check for last 4 teams
						{
							foreach(Object bar in teamBuffer)
							//looks through buffer array
							{							
								if(Convert.ToInt32(bar) == team1 || Convert.ToInt32(bar) == team2)
								{
									myIndex=1;
									break;}
								else
									myIndex=0;
							}
						}
						counter++;
					}while(myIndex==1);

					//if finally get a good round, add teams to buffer
					teamBuffer.Add(team1);
					teamBuffer.Add(team2);

					//insert round into dbase
					sSql = "insert into rounds (eventID, roundNum, field, team1ID, team2ID) values ("
						+  eventId + ", " + currentRound + ", " + currentField + ", " + team1 + ", " + team2 + ")";

					oComm= new OleDbCommand(sSql, oConn);
					oComm.ExecuteNonQuery();
					
					//advance current field
					currentField++;				

					//pop match from raw list
					rawMatches.RemoveAt(match);
					//update raw matches left counter
					foo = rawMatches.Count;
				}
			}
			oConn.Close();
		}
		catch(Exception ex)
		{
			oConn.Close();
			throw new Exception("Database error. " + ex.Message);
		}
	}
}

<br />
OleDbConnection dbConnection = new OleDbConnection();  <br />
OleDbCommand tableCommand = null;<br />
OleDbDataReader reader = null;<br />
dbConnection.ConnectionString = sConnString;<br />
dbConnection.Open();<br />
tableCommand = dbConnection.CreateCommand();<br />
tableCommand.CommandText = sSQL;<br />
<br />
DataSet ds = new DataSet(); <br />
OracleDataAdapter adapter = new OracleDataAdapter(); <br />
adapter.SelectCommand = tableCommand;<br />
adapter.Fill(ds, "AllPatients"); <br />
dataGridPatients.SetDataBinding(ds, "AllPatients");