'how autoupdate in gridview in OleDbDataAdapter in vb.net
I use devexpress gridview only to view data how the connection can be autoupdate in case of an update in the source application. I used visual studio 2010. Is there the best solution or recommendation?
Dim cn = "provider=Microsoft.Jet.OLEDB.4.0; data source=" & Path & "; Extended Properties=dBase IV"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.FillGridView()
End Sub
Private Sub FillGridView()
Try
dt = New DataTable
Dim query = "select CODE,FILENAME1,FILENAME2,FILENAME3,SUBFOLDERP FROM ALPHABET"
Using adapter As New OleDbDataAdapter(query, cn.ToString)
adapter.Fill(dt)
End Using
Me.GridControl1.DataSource = dt
Catch myerror As OleDbException
MessageBox.Show("Error: " & myerror.Message)
Finally
End Try
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
