1. Open IBConsole (if you don't have IBConsole installed, get it here: http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=19220
2. Select Local Server in the left pane
3. Right-click and select Login
4. Enter the appropriate password (by default-that is, until and if you change them-the InterBase username is SYSDBA and the password is masterkey)
5. Select Database | Create Database

Now, we need to populate the tables with data. We could write a quick-and-dirty GUI app (in C#Builder, Delphi, or some other tool) to do this, but with the (low) volume of data we're working with, it's just as easy-nay, easier-to simply enter the data directly into IBConsole. You can either enter the following data, or download the tables from CodeCentral (http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=20304).

1. 2-click TEAMB_MEMBERS in IBConsole
2. Select the Data tab
3. Enter the values from http://info.borland.com/newsgroups/teamb/teambbyname.html Add an integer ID value starting at 1 for each member, proceeding in last-name alpha order (1 for Yorai Aminov, 2 for Jim Bailey, etc.)
4. 2-click TEAMB_TOOLS
5. Select the Data tab
6. Enter the following values:

TOOL_ID	TOOL_NAME
1	Delphi
2	Interbase
3	C++Builder
4	JBuilder
5	C#Builder

Note: As of the time of writing, there are no C#Builder TeamB members, as it is a new product and no C#Builder gurus have asserted themselves (so to speak) yet. Maybe you, dear reader, will end up being one of these august elect few.

7. 2-click TEAMB_MEMBERS_AND_TOOLS
8. Select the Data tab
9. Enter the following values:

1. Start up C#Builder if you haven't already done so, and select File | New | C# Application or click the New on the Welcome Page. In the New Items dialog, the C# Project folder should be selected (if not, select it). Select Application in the right pane and then select the OK button.
2. In the New Application dialog, change the Name of the project from its default value to TeamB.
3. Select the ellipsis button to the right of the Location edit, and save the project wherever you want (or allow it to save to the default location). For the sake of simplicity, you might want to save your source code in the same directory as the TeamB database.
4. Select the OK button.
5. Change the Text property of the form (found beneath the Appearance category) to "TeamB-o-rama" or something equally suave and debonair.
6. Select the Data Explorer tab, which is by located by default in the Northeast corner of the IDE.
7. Right-click the InterBase Provider node and select Add New Connection.
8. Enter TeamB in the Connection Name edit:



9. Select the OK button.
10. Expand the InterBase Provider. You should have two InterBase aliases set up: IBConn1 (created by default when you installed C#Builder), and the new TeamB alias.
11. Select the new TeamB alias, right-click and select Modify Connection.
12. Beneath the Connection category, click the ellipsis buttons for the Database property, and navigate to the location of TeamB.gdb
13. The Connections Editor dialog should now look something like this:



14. Select the Test button to verify that it responds with a "Connection Successful" message.
15. If you expand the TeamB connection, and then Tables, and then each of the three tables, you will see this:

1. Drag the TEAMB_MEMBERS table from the Data Explorer to the form. This will cause two non-visual components to be placed in a logical receptacle below the form (out of the way of the form, which is another nice feature of the new IDE). These two components are bdpConnection1 and bdpDataAdapter1.
2. Click the bdpConnection component to highlight it.
3. Right-click the bdpConnection component and select Connection Editor from the context menu (or select the hot label at the bottom of the Object Inspector) and verify that the Connection it is set to is indeed TeamB.
4. Click the bdpDataAdapter component and either right-click and select Configure Data Adapter from the context menu, or select the Configure Data Adapter hot label beneath the Object Inspector.
5. Verify that New Data Set is selected on the Data tab and select the OK button. This will create DataSet1 and add it to your menagerie of non-visual components at the bottom of the form.
6. Set the bdpDataAdapter's Active property (beneath the LiveData property category) to True.
7. Type "co" into the search edit beneath the Tool Palette. Drag a ComboBox component from the Windows Forms category onto the form, and place it at the upper left of the form.
8. Type "bu" into the search edit beneath the Tool Palette. Drag a Button from the Windows Forms category onto the form, to the right of the combo box.
9. Change the button's Appearance.Text property to "Filter".
10. Type "da" into the search edit beneath the Tool Palette. Drag a DataGrid from the Data Controls component category onto the form.
11. Size the data grid to take up most of the remainder of the form.
12. Select the Data Grid component, and beneath the Data category, set Data Source to DataSet1, and Data Member to Table1. You will now see the contents of the TEAMB_MEMBERS table in the grid.
13. Select the ComboBox, and select the ellipsis button to the right of the Items property (Data category). The String Collection Editor displays.
14. After entering the following values, select the OK button:

Delphi
Interbase
Jbuilder
C++Builder
C#Builder

15. Change the combo boxes Appearance.Text property to an empty string. The form now looks something like this:



16. With the bdpDataAdapter component highlighted, select the Configure Data Adapter component editor context menu item or hot label again.
17. In the Data Adapter's component editor, deselect the Insert, Update, and Delete SQL commands.
18. Enter the following in the SQL pane for the Select statement:

SELECT DISTINCT M.FIRST_NAME, M.LAST_NAME 
FROM TEAMB_MEMBERS M, 
TEAMB_MEMBERS_AND_TOOLS A
WHERE M.TEAMB_ID = A.TEAMB_ID
AND A.TOOL_ID = ?
ORDER BY M.LAST_NAME

The "?" mark in the query above is C#Builder's way of denoting a parameter in the query (in Delphi, a colon is used for parameterized queries; a question mark actually makes more sense, though).

19. Select the dbpDataAdapter component and then click the ellipsis button in the Object Inspector to the right of the Fill.SelectCommand.Parameters property.
20. In the bdpParameter Collection Editor dialog, select the Add button.
21. From the Data.dbType dropdown, select the Int32 data type.
22. Enter "ToolID" in the Misc.ParameterName edit and select the OK button.
23. You might want to select the component editor's Preview Data to perform a "sanity check" on your SQL statement. To do so, though, first change the "?" in your SQL statement temporarily to any value between 1 and 4 (inclusive) to see which TeamB members are assigned to the various tools. Select the Refresh button to display the data. After convincing yourself of your SQL code's validity, change the TOOL_ID value in the SQL statement back to "?".
24. Select the OK button to close the component editor.

private void button1_Click(object sender, System.EventArgs e)
{
  bdpSelectCommand1.Close();
  bdpDataAdapter1.Active = false;
  bdpSelectCommand1.Parameters["ToolID"].Value =
    this.comboBox1.Items.IndexOf(this.comboBox1.Text)+1;
  bdpDataAdapter1.Active = true;
}

Clay Shannon is a Borland and PDA-certified Delphi developer and the author of "Tomes of Delphi: Developer's Guide to Troubleshooting" (Wordware, 2001) as well as the novel he claims is the strangest one ever written, "the Wacky Misadventures of Warble McGorkle" (see Wacky Warble, etc. for more information on the 4 Novels application, which contains this and three other novels he has penned).

You can find out more about Clay at: http://hometown.aol.com/bclayshannon/myhomepage/index.html
You can look into Clay's shareware and determine his current availability at: http://hometown.aol.com/bclayshannon/myhomepage/business.html
You can contact him at: BClayShannon@aol.com