Editing an array using a DataGrid

[warlow]

I would like to edit/read/write the contents of an array using a DataGrid.

I have started with Form1 to which I have visually:

Added DataGrid1
Added DataSet1
Added Table1 and Column1 to DataSet1
Chosen DataTable1 as the DataSource for DataGrid1

I can run this program now and I get a nice grid where I can add, edit, delete, copy and even sort the text I enter - wonderful, just what I wanted.

So now what's the easiest/best/recommended way to tie this to an array so that the contents also get updated? So far I've only found DataGrid examples using Access/SQL/database stuff which I hope I can do without.

 

[warlow]

It appeared that I should be able to use the SetDataBinding method of the DataGrid to bind an array to a column.

So adding to the visually created stuff above I added a button to form1 with the following code in it's click event routine:

Dim myArray() as String = {"I", "am", "not", "sure"}
DataGrid1.SetDataBinding(myArray , "" ) '????

This nearly works except that when I run it and click the button, the table column picks up the Length of each element so I get rows with 1, 2, 3, 4, instead of the strings.

According to the DataGrid Class description, a single dimension array is a valid datasource for the SetDataBinding method of a DataGrid but what should the syntax be?