When i used to upload the excel file, i inserts the records but it used to skip the insertion, like my file has 9000 records it insert 8890 or 8800 sometimes 8950, plz suggest what would be the possible reason.
Dim conexcel As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("upload/" & FileUpload1.FileName) & "; Extended Properties=Excel 8.0")
Dim cmd As New OleDbCommand("select \* from \[Sheet1$\]", conexcel)
Try
If ConnectionState.Open Then
conexcel.Close()
End If
conexcel.Open()
Dim dr As OleDbDataReader
dr = cmd.ExecuteReader()
Dim act, cnt, ds, cf, co, distt, dtype As String
act = ddl\_Activity.SelectedItem.Text.ToString()
cnt = ddl\_Center.SelectedItem.Text.ToString()
ds = ddl\_DataSource.SelectedItem.Text.ToString()
distt = ddl\_Distt.SelectedItem.Text.ToString()
bcode = UCase(bcode) & "/" & distt & "/" & act & "/" & bno.ToString()
dtype = ddl\_DataType.SelectedItem.Text.ToString()
Try
Dim name, cnt1, cnt2 As String
name = ""
cnt1 = ""
cnt2 = ""
cf = ""
co = ""
Dim m, p As Int64
m = 1
While (dr.Read())
name = Trim(dr(0).ToString())
cnt1 = Trim(dr(1).ToString())
cnt2 = Trim(dr(2).ToString())
cf = Trim(dr(3).ToString())
co = Trim(dr(4).ToString())
Dim str As String
If cnt1 <> "" Or name <> "" Then
str = "insert into tbl\_edu\_dt(full\_name,contact1,contact2,Activity,Center,DistName,DataSource,Collected\_From,Collected\_On,batch\_code,batch\_id,imp\_date,imp\_time,Data\_Type) values ('" & name & "','" & cnt1 & "','" & cnt2 & "','" & act & "','" & cnt & "','" & distt & "','" & ds & "','" & cf & "' , '" & co & "','" & bcode & "','" & m & "','