Can anyone see why this would be instering twice on each loop?
Dim dt As New DataTable
Dim dr As DataRow
Try
'*** Column ***'
dt.Columns.Add("FIRST_NAME")
dt.Columns.Add("MIDDLE_NAME")
dt.Columns.Add("LAST_NAME")
dt.Columns.Add("ADDRESS1")
dt.Columns.Add("ADDRESS2")
dt.Columns.Add("CITY")
dt.Columns.Add("STATE")
dt.Columns.Add("ZIP")
Dim StrWer As StreamReader
Dim strLine As String
StrWer = File.OpenText(Server.MapPath("~/Process_File/" & ddCSVFiles.SelectedValue))
Do Until StrWer.EndOfStream
strLine = StrWer.ReadLine()
If Trim(strLine) <> "" Then
'*** Rows ***'
dr = dt.NewRow
Dim rowData As String() = strLine.Split(","c)
...
Go to the complete details ...