mfahmy2008 0 Newbie Poster

I have a text file contains non delimited data

(Each row consists from 16 fields and has a 131 byte)

I used this code to load it's data into datagrid(I have visual basic 2005)

The program work fine

Now I want load this datagrid into access database

I try to define a table adaptor define at the same dataset contains the access table with the same definition of the column of the datagrid of the textfile

and I try to bind the data loading from text file to this new datatable but my problem this file never show to me anydata

Can anybody help me please?

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



    DataGridView1.AutoGenerateColumns = True

    Dim TextFieldParse As New FileIO.TextFieldParser("C:\txtFilesFolder\tsticd9.txt")         tfp.TextFieldType = FileIO.FieldType.FixedWidth

    tfp.FieldWidths = New Integer() {6, 7, 29, 1, 10, 6, 7, 9, 9, 13, 15, 3, 4, 9, 2, -1}  

   TextFieldParser.HasFieldsEnclosedInQuotes = False 



    While Not TextFieldParse.EndOfData



        Dim valstring() As String = TextFieldParse.ReadFields

        Dim datarow1 As DataSet1.DataTable1Row 

        datarow1 = DataSet11.DataTable1.NewDataTable1Row                 
          For i As Integer = 0 To valstring.Length - 1

            If valstring (i).Trim.Length > 0 Then

                dr.Item(i) = valstring (i)

            End If



        Next

        DataSet11.DataTable1.AddDataTable1Row(dr)

        End While



    BindingSource1.DataSource = DataSet11

    BindingSource1.DataMember = "DataTable1"



End Sub

End Class