I am facing huge performance issues when i load drop down list to datagrid. The dropdown have 600 records. I am showing 10 records at one time in the grid. If i comment out this code, it takes 4 secs to load the page, other wise it takes 20 sec. please help me,
This is what i do
Protected dsAccount As New DataSet()
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim objAccount As New tblAccount()
dsAccount = objAccount.ListAccounts("", "N")
end sub
Protected Sub dgWOLabor_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgWOLabor.ItemDataBound
If e.Item.ItemType = ListItemType.Alterna ...
Go to the complete details ...