Fast Loading Of Typed DataSet ...
Posted on 2004-08-08
i have a typed dataset that contains 15 tables as one object
i'm trying to fill the whole object at one time only,
i mean to do like :
the way i'm doing is to do a loop for each table in my object
,get table name and Fill it
that means i'm going to the Db 15 times and thus making
slowness in loading the object.
the select sts are stored procedures for each table, those
contains alot of inner joins .
is there a way i can fill my dataset tables at one time,by going to the Db only once ..so it well be fast
How To Make DataSet Filling Fast other that taking out constraints and notifications...