Author: Kshitish | Posted on: 2/4/2010 6:17:09 PM | Views : 340

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 ...