displaying Array data in a Data Grid in VB.net

[crusson]

I'm trying to get an array to display in a data grid form in vb.net

The array has been imported from a csv, such that every array item is [date,time,flag] but I can split or join as needed to change the format of the array.

I want date, time, and flag to be seperate columns and each array item to be a new row.

I don't know where to start with this problem. I have looked through the msdn website and done some googling to no avail. If someone can point me to some better resources than I've been finding, it would be much appreciated.

Cheers

[crusson]

I moved on to different parts of the program hoping that when I came back to this problem I would magically think of a way to fix it...but I'm still having the same issues.

I am unable to size my columns to the width I want in the datagrid. I am able to resize all columns together, but not as seperate entities. I want column d to be really wide, but a,b,c can all be fairly small.

I am unable to figure this out. There is no .style or DefaultCellStyl e that I can access to change individual Columns. Can anyone throw me a few hints here?

    Private Sub displayArray()
        'displays the array in the data grid form
 
        arrayMasterLen = terrarray.getDisplayArrayLen()     'the number of rows to be displayed
        ReDim arrayMaster(arrayMasterLen)                   'dim the array it's stored to
        arrayMaster = terrarray.getDisplayArray()           'store the array
 
        Dim dataTable1 As DataTable                         'new data table
        dataTable1 = New DataTable("LineLog")
        Try
            Dim colA As DataColumn = New DataColumn("Date/Time")
            colA.DataType = System.Type.GetType("System.String")
            dataTable1.Columns.Add(colA)
 
 
            Dim colB As DataColumn = New DataColumn("Flag")
            colB.DataType = System.Type.GetType("System.String")
            dataTable1.Columns.Add(colB)
            Dim colC As DataColumn = New DataColumn("Code")
            colC.DataType = System.Type.GetType("System.String")
            dataTable1.Columns.Add(colC)
            Dim colD As DataColumn = New DataColumn("Comments")
            colD.DataType = System.Type.GetType("System.String")
            dataTable1.Columns.Add(colD)
 
 
            Dim j As Integer = 0
            For j = 0 To arrayMasterLen - 1
                Dim row As DataRow
                row = dataTable1.NewRow()
                row.Item("Date/Time") = terrarray.returnDateEntry(j)
                row.Item("Flag") = terrarray.returnFlag(j)
                row.Item("Code") = terrarray.returnCode(j)
                row.Item("Comments") = terrarray.returnComment(j)
                dataTable1.Rows.Add(row)
            Next
        Catch
        End Try
 
        DataGrid1.PreferredColumnWidth() = 120
        DataGrid1.DataSource = dataTable1
        DataGrid1.RowHeadersVisible = True
        DataGrid1.Name = "LineEntries"
        DataGrid1.Refresh()
 
    End Sub

[Plater]

Hmm, while there does not seem to be any width parameter, all DataGridViewCol umns have that style element I was talking about.
(There's two, one for the header cell and one for the regular cells)

There is also the auto-size mode, which might do what you want it to do?

Hmm, this IS a windows application right and not for a webapplication?

[crusson]

Thanks for replying. I feel like kind of a moron, but I'm still unable to figure this out. This is a windows app, not a web app. I think part of my problem is that I cannot figure out how to refer to the columns of the actual data grid. I can refer to columns of the data table, but cannot do anything with them width-wise. I think it may be that I'm applying a data table to be the data source of the data grid and cannot refer to those columns once they've been added to the data grid. Is there any way to refer to these columns in the datagrid?

I am able to set the preferred width of the datagrid (which applies to all columns in the table) but cannot find the auto-size mode you speak of. Should it appear in my properties window and doesn't? Or should I need to code it after adding the data to the datagrid. If it just automatically sizes every column to its widest width, that would be perfect.

Hmm, while there does not seem to be any width parameter, all DataGridViewCol umns have that style element I was talking about.
(There's two, one for the header cell and one for the regular cells)

There is also the auto-size mode, which might do what you want it to do?

Hmm, this IS a windows application right and not for a webapplication?

[Plater]

Hmm you are using DataGrid object and not a DataGridView object then? That will be trickier then, I am unfamiliar with the vs2003 version of the object.

[crusson]

Yes, I am using a datagrid object, not a datagridview object. I've never used one of these objects before this project, so I have no real idea how they work. I know that generally they are used with databases instead of arrays. Would a database as an intermediary step be a necessary middleman?

[Plater]

If you are using a newer then VS2003, save yourself a lot of headache and switch to a DataGridView.

[crusson]

Sadly it appears that I'm using vs2001. I guess I need to try some completely different work-around...