Dear Advance,
I used one stored procedure to retrive 3 different result set. and in the codebehind i seperate it. means from the dataset i seperate three different datatable and then show my data as my need.
but the main problem is ... after retriving the datafrom the database i have to user foreach loop to bind the coulmns data to my different custom class.
example:
foreach (DataRow oDrow in MyDataTable.Rows) {
oClass=new Class();
oClass.Name1=oDrow["Name1"] .toString();
oClass.Name2=oDrow["Name2"] .toString();
...
}
1. so my first question is there any optimization possible ?
2. my result set is too loong ... so should keep just one hit to database or hit more than one time
Currently i am optimizing my web application. in the previous version 1 have to hit the database 3/4 times for different purposes. but now it hits only one time... but it takes time in the codebehind to perform different operation.
Any Suggestion
Starting point: Asynchronous SQL
SqlCommand.BeginExecuteReader()
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref4/html/O_T_System_Data_SqlClient_SqlCommand_BeginExecuteReader.htm
