I am trying to create a Datagrid to import and edit from text and csv files. If I was to import into Excel and use the Text to Columns feature they would have 34 columns. With this in mind I need a Datagrid that has 34 columns. I am just now learning how to create datagrids. This is what I have so far:

Private Sub FormatGrid()
        Dim Tbl As New DataTable
        Dim Col1 As New DataColumn

        Col1.DataType = System.Type.GetType("System.Int32")
        Col1.ColumnName = "Date"
        Col1.AutoIncrement = True
        Col1.Caption = "Date"
        Col1.ReadOnly = True
        Tbl.Columns.Add(Col1)

        datagridOutput.DataSource = Tbl
end sub

I'm not sure if this is the best way to create a datagrid but it was the first way I learned how. As you can see the problem I have is that I will have to declare 34 variables for each column and then go through the process of defining each column like I have done. Is there a way that I can declare the columns in an array as well as the heading names in an array and then create a loop that will run 34 times to create the datagrid with 34 columns with their heading names? Maybe someone could give me a code snippet that would show how to accomplish this.

Thanks.

Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

__________________
Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

I may have asked a little prematurely. I've seem to at least create all the headings although it is a bit slow. Any ideas as to how to speed up the execution??? Below is the code I came up with.

Private Sub FormatGrid()
        Dim Tbl As New DataTable
        Dim I As Integer
        Dim Col(31) As DataColumn
        Dim HeadingName() As String = New String(31) {"Date", ...."Last Heading"}

        ' Define columns, specify the column data type, name is to identify the column,
        ' enable automatically increment the data, value to be displayed in the header
        ' of the column, make this column read only, Since it is autoincrement,
        ' add column to the datatable
        For I = 0 To 31
            Col(I) = New DataColumn
            Col(I).DataType = System.Type.GetType("System.Int32")
            Col(I).ColumnName = HeadingName(I)
            Col(I).AutoIncrement = True
            Col(I).Caption = HeadingName(I)
            Col(I).ReadOnly = True
            Tbl.Columns.Add(Col(I))
        Next

        ' BIND THE DATATABLE TO THE DATAGRID
        datagridOutput.DataSource = Tbl
    End Sub

Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

If the data you're trying to import from the CSV will always have the same columns, you'd be best off creating a strongly-typed dataset. To do this, in the solution explorer right click and choose to add a new item, then select dataset.

You'd be best off doing a ado.net tutorial; try a search on google, or http://visualbasic.about.com/od/lear...cvbsbs2001.htm

Once you're happy with datasets, you can populate one from a csv file through using the streamreader classes in the System.IO namespace