VOS.VirtInformixVisualStudioDataGridFormsApp

Visual Studio Windows DataGrid Form Application

This article details the steps required to create a simple Visual Studio 2008 Windows Form application, with associated DataGridView control for displaying data in selected tables from the target database.

Launch the Visual Studio 2008 SP1 IDE.
Create a Web Application project by going to the File menu in Visual Studio and choosing New Project.
When the New Project window appears, choose either Visual Basic or Visual C# as your programming language.
Within the language category, click on Windows and select Windows Form Application from the right-hand panel.
Choose a name for the project, for example VirtWindowsFormApplication, and click OK.
In the Toolbox, expand Data Controls and drag the DataGridView control onto the form.
Click on the little arrow in the top right of the DataGridView control. This loads the DataGridView Task menu.
Click on the Choose Data Source list box.
Click on the Add Project Data Source link to connect to a data source.
In the Data Source Configuration Wizard dialog Choose Data Source Type page, select the Database data source type and click Next.
In the Data Source Configuration Wizard dialog Choose your Data Connection page,select the New Connection button.
In the Choose Data Source dialog, select the OpenLink Virtuoso Data Source from the list and click Continue.
In the Connection Properties dialog, specify the hostname, portno, username and password for the target Virtuoso Server and check the Save Password check box.
Select the Select Database From List radio button and choose stores_demo from the drop down list.
Press the Test Connection dialog to verify that the database is accessible.
Leave the default connect string name--stores_demoConnectionString--and click Next.
From the list of available tables returned for the stores_demo database, select the msgs table to be associated with the DataGridView control.
The columns names of the select table will be displayed in the the DataGridView.
Resize the Form and DataGridView to allow all columns to be visible, if possible.
To test the application, simply hit Ctrl+F5 within Visual Studio or select Start Debugging from the Debug menu.
The data from the msgs table will be displayed in the DataGrid.
To make the DataGridView updateable, you will need to manually add some code to the project along with a suitable control to invoke the code.

Drag a Button control onto the form.
Right click on the Button and select Properties.
In the Properties view, edit the button's Text property to read Save Changes and its (Name) property to read saveChanges.
The button will now update to reflect these changes.

NOTE: You will need to resize the button to make the new text visible.
Double click the new button to generate the required event handler. It should take you directly to the area of code that will execute when the button is clicked.

Edit the saveChanges_Click event handler code to include the following line.



private void saveChanges_Click(object sender, EventArgs e)
{
  this.msgsTableAdapter.Update(this.stores_demoDataSet.msgs);
}

Now test the application again by hitting Ctrl+F5.

Scroll to the empty row at the bottom and enter data for a new row. Then, select Save Changes which will write the new row back to the database.

Updates and deletes can be performed similarly.
You can use Interactive ISQL to test that the changes that have been written. Interactive ISQL Interface is detailed in the Linking Informix tables into OpenLink Virtuoso section.

The task is now complete.