Click here to Skip to main content
15,867,594 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: How to load *.pcx files in html Pin
Member 462021626-Nov-08 2:24
Member 462021626-Nov-08 2:24 
Questiondata converting Pin
Afroz Ali26-Nov-08 0:25
Afroz Ali26-Nov-08 0:25 
AnswerRe: data converting Pin
Ashfield26-Nov-08 1:21
Ashfield26-Nov-08 1:21 
AnswerRe: data converting Pin
Christian Graus26-Nov-08 10:06
protectorChristian Graus26-Nov-08 10:06 
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 

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.