hi everybody :)
i take datatable from excel page then insert oracle database in visual studio
when rows more then 5000 then then it gets very slowly
i changed my insert command with
"INSERT ALL "& INSERT_SATTMSIP &" Select * FROM dual
but for this command i must combine lines in datatable into one string
how can i do this fastly
i used for next in datatable but very slowly
What I have tried:
"INSERT ALL "& INSERT_SATTMSIP &" Select * FROM dual
Dim INSERT_SATTMSIP As String
Dim SUTUN = "HAKEDISDONEMI,ONGORULENODEMETARIHI,DURUM,ODEMETARIHI,VADETARIHI,KAYITTARIHI,KAYITNO,KAYITTIPI,KAYITTURU,KAYITSINIFI,
SIPARISNO,SIPARISTARIHI,URUNNO,URUNADI,URUNADEDI,BIRIMSATISFIYATI,SATISTUTARI,PARABIRIMI,VADESURESI,PAKETNO"
'dt2 as datatable from excel
For r = 0 To DT2.Rows.Count - 1
INSERT_SATTMSIP = INSERT_SATTMSIP & vbLf & " INTO " & M_YIL & ".HB_EKSTREGIDER (" & SUTUN & ") " &
"VALUES ('" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "',
'" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "',
'" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "',
'" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "',
'" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "','" & DT2.Rows(r).Item(0) & "') "
Next
MessageBox.Show(INSERT_SATTMSIP)