T
theneogen
Guest
Ever since the last Windows 10 update, the following code:
Dim conn1 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & txtFileLocDB.Text & ";Persist Security Info=True")
Dim strDGVOld_Resub As String = "SELECT * FROM [OLD_RESUB_PARCELS]"
Dim dsDGVOld_Resub As New DataSet()
Dim adDGVOld_Resub As New System.Data.OleDb.OleDbDataAdapter(strDGVOld_Resub, conn1)
Dim rowid2 As Integer = 0
Dim rowpos As Integer = 0
conn1.Open()
adDGVOld_Resub.Fill(dsDGVOld_Resub, "OLD_RESUB_PARCELS")
TextBox1.Text = dsDGVOld_Resub.Tables("OLD_RESUB_PARCELS").Rows.Count.ToString
dgvOld_Resub.DataSource = dsDGVOld_Resub.Tables("OLD_RESUB_PARCELS")
conn1.Close()
dgvOld_Resub.Refresh()
Where dgvOld_Resub is the datagridview on my form.
I now get the error:
The dataset is populated by the database table verified by textbox1 showing there are 322 records. The datagridview shows the 1st record and then throws the above error. It runs all of the code before this just fine. Very frustrating since I've been using this app for years now and all of a sudden it just stops working. I've been trying to figure this out for 3 days now. What am I missing? Any help is greatly appreciated.
Continue reading...
Dim conn1 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & txtFileLocDB.Text & ";Persist Security Info=True")
Dim strDGVOld_Resub As String = "SELECT * FROM [OLD_RESUB_PARCELS]"
Dim dsDGVOld_Resub As New DataSet()
Dim adDGVOld_Resub As New System.Data.OleDb.OleDbDataAdapter(strDGVOld_Resub, conn1)
Dim rowid2 As Integer = 0
Dim rowpos As Integer = 0
conn1.Open()
adDGVOld_Resub.Fill(dsDGVOld_Resub, "OLD_RESUB_PARCELS")
TextBox1.Text = dsDGVOld_Resub.Tables("OLD_RESUB_PARCELS").Rows.Count.ToString
dgvOld_Resub.DataSource = dsDGVOld_Resub.Tables("OLD_RESUB_PARCELS")
conn1.Close()
dgvOld_Resub.Refresh()
Where dgvOld_Resub is the datagridview on my form.
I now get the error:
The dataset is populated by the database table verified by textbox1 showing there are 322 records. The datagridview shows the 1st record and then throws the above error. It runs all of the code before this just fine. Very frustrating since I've been using this app for years now and all of a sudden it just stops working. I've been trying to figure this out for 3 days now. What am I missing? Any help is greatly appreciated.
Continue reading...