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