C# Subfile - iSeries data in a C# Grid -2 no coding (with Video)

Well almost no coding.

If you look at my previous post where I showed how to code a grid in C# using data from the iSeries we manually coded the grid, the data set and the connection. This example accomplishes the same result except you'll be done in under 5 minutes!  It uses the IDE to build the grid, data set, adapter, connection and SQL command.

The video also shows how to add in the iSeries .net data components to your Visual Studio toolbox.
This post easier shown than discussed - so check out the following video.

Steps

1. Create a windows form application project
2. Add in the IBM dll to your references
3. Add in the IBM data tools to your toolbox using Tools, Choose Toolbox items and filter 'idb2'
4. Add a basic grid to your form
5. Drag the iDB2Connection, IDB2Command, iDB2DataAdapter and a data set to your form
6. Configure each by right clicking and selecting properties
7. Double click outside the grid to bring up the code for the Load method of the form.
8. Add in the following code
   iDB2DataAdapter1.Fill(dataSet1);
   dataGrid1.DataMember = dataSet1.Tables[0].TableName;
9. Run the program!