Click here to Skip to main content
15,921,697 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionWeb Development Pin
Afroz Ali26-Nov-08 0:21
Afroz Ali26-Nov-08 0:21 
AnswerRe: Web Development Pin
Christian Graus26-Nov-08 7:42
protectorChristian Graus26-Nov-08 7:42 
GeneralDynamic Views in MVC Pin
Brady Kelly26-Nov-08 0:14
Brady Kelly26-Nov-08 0:14 
QuestionMerging Dataset Pin
NinaWilliam26-Nov-08 0:06
NinaWilliam26-Nov-08 0:06 
Hi there,

ASP.NET 1.1 / VB.NET / SQL 2000

I am generation report using crystal reports 10... the report is working fine but the problem that it is taking too long to load and display the data.

what I am doing is: I have two tables (one to many). I am getting all records from the first table and storing it in a table in my dataset... then I am getting all records from the second table depending on the ID from the first table. then storing it in another table in the dataset.

after that, I merge both tables in dataset by doing for each loop to merge each record to its related id.

Finally, bind it to the report

The merging process takes 2 minutes!!

What can I do? is there a better way to do the same thing?
can I control the range of records in my SQL statement?

Please help me
AnswerRe: Merging Dataset Pin
Shyam Bharath26-Nov-08 0:13
Shyam Bharath26-Nov-08 0:13 
QuestionAbout image Processing Pin
sanjay3025-Nov-08 22:37
sanjay3025-Nov-08 22:37 
AnswerRe: About image Processing Pin
Christian Graus25-Nov-08 23:06
protectorChristian Graus25-Nov-08 23:06 
GeneralRe: About image Processing Pin
sanjay3026-Nov-08 1:31
sanjay3026-Nov-08 1:31 
GeneralRe: About image Processing Pin
Christian Graus26-Nov-08 10:07
protectorChristian Graus26-Nov-08 10:07 
GeneralRe: About image Processing Pin
sanjay3027-Nov-08 23:50
sanjay3027-Nov-08 23:50 
GeneralRe: About image Processing Pin
sanjay3030-Nov-08 20:15
sanjay3030-Nov-08 20:15 
QuestionInputbox in Asp.net Using Visual Basic Language Pin
Ryno Engelbrecht25-Nov-08 22:22
Ryno Engelbrecht25-Nov-08 22:22 
AnswerRe: Inputbox in Asp.net Using Visual Basic Language Pin
Christian Graus25-Nov-08 23:09
protectorChristian Graus25-Nov-08 23:09 
GeneralRe: Inputbox in Asp.net Using Visual Basic Language Pin
Ryno Engelbrecht25-Nov-08 23:23
Ryno Engelbrecht25-Nov-08 23:23 
GeneralRe: Inputbox in Asp.net Using Visual Basic Language Pin
Christian Graus25-Nov-08 23:28
protectorChristian Graus25-Nov-08 23:28 
QuestionTool for analyse contents of Viewstate Pin
anderslundsgard25-Nov-08 22:08
anderslundsgard25-Nov-08 22:08 
AnswerRe: Tool for analyse contents of Viewstate Pin
Paddy Boyd26-Nov-08 2:16
Paddy Boyd26-Nov-08 2:16 
GeneralRe: Tool for analyse contents of Viewstate Pin
anderslundsgard26-Nov-08 6:49
anderslundsgard26-Nov-08 6:49 
QuestionUse variable from the code behind Pin
Kefaleas Stavros25-Nov-08 21:55
Kefaleas Stavros25-Nov-08 21:55 
AnswerRe: Use variable from the code behind Pin
John Gathogo25-Nov-08 22:12
John Gathogo25-Nov-08 22:12 
GeneralRe: Use variable from the code behind Pin
Kefaleas Stavros25-Nov-08 22:16
Kefaleas Stavros25-Nov-08 22:16 
AnswerRe: Use variable from the code behind Pin
Christian Graus25-Nov-08 23:13
protectorChristian Graus25-Nov-08 23:13 
GeneralRe: Use variable from the code behind Pin
Kefaleas Stavros25-Nov-08 23:17
Kefaleas Stavros25-Nov-08 23:17 
GeneralRe: Use variable from the code behind Pin
Christian Graus25-Nov-08 23:22
protectorChristian Graus25-Nov-08 23:22 
GeneralRe: Use variable from the code behind Pin
Kefaleas Stavros25-Nov-08 23:30
Kefaleas Stavros25-Nov-08 23:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.