hi guys , i have a problem with my loading/refresh record in my form.
i have only almost 500 record and take so long before refreshing/display the data. i have a user input form where user enter their record and while saving(direct to the database) and refreshing data i just call only my function getrec ().
pls give me some idea to fix this problem.
pls take a look
Dim ActiveTable As New DataTable Private Sub frmRef_Userlist_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load getrec End Sub Private Sub dtBind(ByVal dt As DataTable) 'slow start here bs.DataSource = ActiveTable 'binding 'slow end here bs.MoveFirst() bn.BindingSource = bs dgv1.DataSource = bs 'listview CloseMainCon() 'closing connection End Sub private sub getrec SqlString = "SELECT " & Tbl_Fields & " FROM " & Tbl_Name & " order by xcode desc" ActiveTable = OpenRSTable(SqlString) dtBind(ActiveTable) end sub