Visual Basic

dim dt as new datatable("a name")
dt.columns.add(new datacolumn("column1",getttype(string)))
dt.columns.add(new datacolumn("column2",getttype(string)))
dt.columns.add(new datacolumn("column3",getttype(string)))
dt.columns.add(new datacolumn("column4",getttype(string)))
...

'now that you have your datatable
'read your textfile line by line
do while not reader.eof 
     dim dr as datarow = dt.newrow
     dr.item("column1")= "your value for that column here"
     dr.item("column2")= "your value for that column here"
     dr.item("column3")= "your value for that column here"
     dr.item("column4")= "your value for that column here"
     ...
     dt.rows.add(dr)
loop
'now you have your entire textfile in a datatable
'you can do all your actions on that datatable now and then overwrite your textfile with a new one

dim dt as new datatable("tablename")

dt.columns.add(new datacolumn("column1",gettype(string)))

dim dr as datarow = dt.newrow

dr.item("column1")= "value goes here"

for each dr as datarow in dt.rows
if (some check)=true then
'do something here
...
else
'do something else here
...
end if
next

vijay2482 wrote:

Do While Not sa.ReadToEnd