I want to insert data from
DatagridView1 to my Access (mdb) database on my Visual Basic Project. I have a large amount of data (approximately 12,000 lines) on
Datagridview1. So I use a
For loop to insert.
Here is my code:
for i = 0 to Datagridview1.Rows.Count - 1 a = Datagridview1.Rows(i).Cells(0).Value b = Datagridview1.Rows(i).Cells(1).Value c = Datagridview1.Rows(i).Cells(2).Value d = Datagridview1.Rows(i).Cells(3).Value If studentsTableAdapter.CountStudent(a, b)=0 Then studentsTableAdapter.Insert(a, b, "-", "New", c, 1) End If infoTxt.Text = "Saving " & i & "/" & Total infoTxt.Refresh() Next i
It works as expected, but sometimes it stops to insert and an error occurs like:
System.Data.OleDb.OleDbException (0x80004005): Unrecognized database format
This error occurs on different steps of for loops. (some times it does not occur).
Is there any reliable way to insert large amount of data from
Datagridview1 to mdb database?
User contributions licensed under CC BY-SA 3.0