Click here to Skip to main content
15,889,553 members
Home / Discussions / C#
   

C#

 
JokeRe: Praffic System Project Pin
Smithers-Jones6-Feb-09 1:04
Smithers-Jones6-Feb-09 1:04 
GeneralRe: Praffic System Project Pin
Member 39168569-Feb-09 4:01
Member 39168569-Feb-09 4:01 
AnswerRe: Praffic System Project Pin
carbon_golem5-Feb-09 8:29
carbon_golem5-Feb-09 8:29 
GeneralRe: Praffic System Project Pin
Pete O'Hanlon5-Feb-09 11:09
mvePete O'Hanlon5-Feb-09 11:09 
GeneralRe: Praffic System Project Pin
Member 39168569-Feb-09 4:04
Member 39168569-Feb-09 4:04 
AnswerRe: Praffic System Project Pin
harold aptroot5-Feb-09 10:49
harold aptroot5-Feb-09 10:49 
GeneralRe: Praffic System Project Pin
Member 39168569-Feb-09 4:05
Member 39168569-Feb-09 4:05 
QuestionFast data retrieval method? Pin
Gareth H5-Feb-09 5:45
Gareth H5-Feb-09 5:45 
The project I am currently working on retrieves a tree structure from the DB, keeping it in a data set. I am trying to find a faster way of getting rows back, as if the tree has 100k relationships, this takes some time (around the 4min mark).

I currently use dataSet.Tables[0].Select("[Parent] = " + parent);. I read on the web that Rows.Find(key); is faster, however, since I am building a tree, I need to retrieve the parents, which isn't a key.

So the question is, does anyone know of a better method to retrieve data from a data table?, or any other suggestions, I could look into not using a data table.

Cheers.

Regards,
Gareth.

(FKA gareth111)

AnswerRe: Fast data retrieval method? Pin
musefan5-Feb-09 6:11
musefan5-Feb-09 6:11 
AnswerRe: Fast data retrieval method? Pin
Wendelius5-Feb-09 6:30
mentorWendelius5-Feb-09 6:30 
GeneralRe: Fast data retrieval method? [modified] Pin
Gareth H5-Feb-09 22:26
Gareth H5-Feb-09 22:26 
AnswerRe: Fast data retrieval method? Pin
PIEBALDconsult5-Feb-09 6:31
mvePIEBALDconsult5-Feb-09 6:31 
AnswerRe: Fast data retrieval method? Pin
Pete O'Hanlon5-Feb-09 11:44
mvePete O'Hanlon5-Feb-09 11:44 
GeneralRe: Fast data retrieval method? Pin
Gareth H5-Feb-09 22:42
Gareth H5-Feb-09 22:42 
AnswerRe: Fast data retrieval method? Pin
Mark Churchill5-Feb-09 14:22
Mark Churchill5-Feb-09 14:22 
QuestionSend data from textbox to datagridview in a diferent form Pin
ZRF695-Feb-09 5:24
ZRF695-Feb-09 5:24 
AnswerRe: Send data from textbox to datagridview in a diferent form Pin
musefan5-Feb-09 6:09
musefan5-Feb-09 6:09 
GeneralRe: Send data from textbox to datagridview in a diferent form Pin
EliottA5-Feb-09 6:14
EliottA5-Feb-09 6:14 
GeneralRe: Send data from textbox to datagridview in a diferent form Pin
musefan5-Feb-09 6:21
musefan5-Feb-09 6:21 
Questionconnecting to a unix data base Pin
tasumisra5-Feb-09 5:09
tasumisra5-Feb-09 5:09 
AnswerRe: connecting to a unix data base [modified] Pin
Luc Pattyn5-Feb-09 5:14
sitebuilderLuc Pattyn5-Feb-09 5:14 
AnswerRe: connecting to a unix data base Pin
SeMartens5-Feb-09 5:15
SeMartens5-Feb-09 5:15 
GeneralRe: connecting to a unix data base Pin
tasumisra5-Feb-09 5:20
tasumisra5-Feb-09 5:20 
GeneralRe: connecting to a unix data base Pin
SeMartens5-Feb-09 5:27
SeMartens5-Feb-09 5:27 
GeneralRe: connecting to a unix data base Pin
tasumisra5-Feb-09 5:30
tasumisra5-Feb-09 5: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.