performing query on datatable
-
Hi all, i am using asp.net , c# in vs2005. i am facing problem of slowness of page(becuase heavy event called for data that is i have four to five dropdownlist control and each dropdownlist is filled based on its precedor value and every seletedindex_changed event call datatbase and fetch the data). what i am now trying is to fetch all the in datatable on page load and from these datatable i would like to fetch data depend on the condition. i am not getting good link to perform the same . please guide me also suggest what i am approaching would inhance speed of flow or not. Thank you
regards imran khan
-
Hi all, i am using asp.net , c# in vs2005. i am facing problem of slowness of page(becuase heavy event called for data that is i have four to five dropdownlist control and each dropdownlist is filled based on its precedor value and every seletedindex_changed event call datatbase and fetch the data). what i am now trying is to fetch all the in datatable on page load and from these datatable i would like to fetch data depend on the condition. i am not getting good link to perform the same . please guide me also suggest what i am approaching would inhance speed of flow or not. Thank you
regards imran khan
We can't help you. We have no idea what data you're loading, what depends on other data, or any other way that we could comment on ways to optimise the load process. We also cannot see the SQL you're using, so we can't comment on how to optimise it. In short, you have given us nothing to help you with.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )