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

[saran23]

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

Hi,
I have an idea to implement , Just try Im not sure this might be a correct solution,
here goes..
1.First create a datatable with rows and columns based on the array structure, 2.using a foreach loop, write the array items to this datatable,
3. Then bind this datatable to the gridview.

After trying this Let me know It works or not....

Thanks
Saran

[crusson]

Thanks.

My program is a notetaking program for surveying, so I'm trying to make it super robust. The array that is holding the data, reopens the text file each time it's going to do soemthing to it and restores it after every change it makes. Towards the robust attempt, I'm trying to avoid using a database for storage altogether. Perhaps if it's just an intermediary step, It's not such a big deal, but if I could go straight from an array into the data base, It would definitely save a step.

[Plater]

DataTable is an object in memory, no need for a database.

[crusson]

DataTable was the keyword. Thanks a bunch.

[crusson]

So using a DataTable will work,

In order to create a table with an unknown number of rows, I need to loop to create Row objects. How do I create objects in a loop such that each has a different name. Or am I missing something and there is a better way to create a bunch of rows?

my idea was soemthing along the lines of this...but &i doesn't work as i wished it did...

Private Sub Thisarray()
        Dim table1 As DataTable
        table1 = New DataTable("stuff")
        Try
            Dim colA As DataColumn = New DataColumn("a")
            colA.DataType = System.Type.GetType("System.String")
            table1.Columns.Add(colA)
            Dim colB As DataColumn = New DataColumn("b")
            colB.DataType = System.Type.GetType("System.String")
            table1.Columns.Add(colB)
            Dim colC As DataColumn = New DataColumn("c")
            colC.DataType = System.Type.GetType("System.String")
            table1.Columns.Add(colC)
 
 
            Dim j As Integer
            For j = 1 To 10
                Dim row&i As DataRow
                row&i = table1.NewRow()
                row&i.Item("a") = "a"
                row&i.Item("b") = "b"
                row&i.Item("c") = "c"
                table1.Rows.Add(row&i)
            Next
 
        Catch
        End Try
 
        Dim ds As New DataSet()
        ds = New DataSet()
        ds.Tables.Add(table1)
        DataGrid1.SetDataBinding(ds, "letters")
 
    End Sub
 

[saran23]

So using a DataTable will work,

In order to create a table with an unknown number of rows, I need to loop to create Row objects. How do I create objects in a loop such that each has a different name. Or am I missing something and there is a better way to create a bunch of rows?

my idea was soemthing along the lines of this...but &i doesn't work as i wished it did...

Private Sub Thisarray()
Dim table1 As DataTable
table1 = New DataTable("stuf f")
Try
Dim colA As DataColumn = New DataColumn("a")
colA.DataType = System.Type.Get Type("System.St ring")
table1.Columns. Add(colA)
Dim colB As DataColumn = New DataColumn("b")
colB.DataType = System.Type.Get Type("System.St ring")
table1.Columns. Add(colB)
Dim colC As DataColumn = New DataColumn("c")
colC.DataType = System.Type.Get Type("System.St ring")
table1.Columns. Add(colC)


Dim j As Integer
For j = 1 To 10
Dim row&i As DataRow
row&i = table1.NewRow()
row&i.Item("a") = "a"
row&i.Item("b") = "b"
row&i.Item("c") = "c"
table1.Rows.Add (row&i)
Next

Catch
End Try

Dim ds As New DataSet()
ds = New DataSet()
ds.Tables.Add(t able1)
DataGrid1.SetDa taBinding(ds, "letters")

End Sub

I suggest using the Datatable u created as the datasource for the grid.instead of using the dataset.

just try this

Datagrid.Datasource=Datatablename;

[Plater]

So using a DataTable will work,

In order to create a table with an unknown number of rows, I need to loop to create Row objects. How do I create objects in a loop such that each has a different name. Or am I missing something and there is a better way to create a bunch of rows?

my idea was soemthing along the lines of this...but &i doesn't work as i wished it did...

When it comes to that sort of thing, you don't NEED different names for them, the variable name you assign goes out of scope the next itteration through the loop.

Simply doing this should be fine:

 Dim j As Integer
            For j = 1 To 10
                Dim row As DataRow
                row = table1.NewRow()
                row.Item("a") = "a"
                row.Item("b") = "b"
                row.Item("c") = "c"
                table1.Rows.Add(row)
            Next
 

[crusson]

So I am now able to display the DataGrid with all of my data.

I want to set individual column widths, but code such as:
colB.width = 100 does not work, i think maybe because I'm running vb.net 1.0?

I can set a datagridcolumns tyle, but how do i apply this to a column?

Dim styleA As DataGridColumnStyle
            styleA.Width() = 1200
 

Private Sub displayArray()
 
        arrayMasterLen = terrarray.getDisplayArrayLen()   
 
        Dim dataTable1 As DataTable
        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.DataSource = dataTable1
        DataGrid1.Refresh()
 
    End Sub

I also want to change the select method so that when I click anywhere in a row, the whole row becomes highlighted. Is this a simple property, or do I need to code this somehow?

[Plater]

Your datagrid columns should have a .style or DefaultCellStyl e or something like that as a property already, you can change them withen there.