In a message dated 23/10/2006 03:02:54 GMT Standard Time,
srussell (AT) lotmate (DOT) com writes:
Bring back a table at a time instead of a huge DS. Use those tables to
repopulate your local DS.
Stephen Russell
DBA / .Net Developer
Thanks Steve,
Would you mind elaborating on "Use those tables to repopulate your local DS.
My case where here is that the form needs many datatables to populate
several datagrids when the form is requested to be opened? I hope you don't mind
expanding on this a bit please?
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*To visit your group on the web, go to:
<*Your email settings:
Individual Email | Traditional
<*To change settings online go to:
(Yahoo! ID required)
<*To change settings via email:
mailto:CSharpNET-digest (AT) yahoogroups (DOT) com
mailto:CSharpNET-fullfeatured (AT) yahoogroups (DOT) com
<*To unsubscribe from this group, send an email to:
CSharpNET-unsubscribe (AT) yahoogroups (DOT) com
<*Your use of Yahoo! Groups is subject to:

>
In a message dated 23/10/2006 03:02:54 GMT Standard Time,
srussell (AT) lotmate (DOT) com writes:

Bring back a table at a time instead of a huge DS. Use those tables to
repopulate your local DS.

Sure, you have to fetch all the data, that is a given. This is a web app,
so you have a timeout issue, where if it takes to long to get a reply the
app craps out. :(

So you need 10 tables of data for your app. Do you really need every
transaction for every table, or can you FETCH as needed along the way?

Get customers, get inventory, get bla bla bla.

page_load
DataSet ds = new DataSet()
// Now pass that ds and a reference to the data to a filler class or
function that deals with getting your data.
FillData(ds,'Cust')
FillData(ds,'Inv')
FillData(ds,'Bla')
FillData(ds,'Bla Bla')

Does this make sense?

Stephen Russell
DBA / .Net Developer
--
Thanks Steve,

Would you mind elaborating on "Use those tables to repopulate your local
DS.

My case where here is that the form needs many datatables to populate
several datagrids when the form is requested to be opened? I hope you
don't mind
expanding on this a bit please?
--
[Non-text portions of this message have been removed]
>
>
>

Yahoo! Groups Links

<*To visit your group on the web, go to:

<*Your email settings:
Individual Email | Traditional

<*To change settings online go to:

(Yahoo! ID required)

<*To change settings via email:
mailto:CSharpNET-digest (AT) yahoogroups (DOT) com
mailto:CSharpNET-fullfeatured (AT) yahoogroups (DOT) com

<*To unsubscribe from this group, send an email to:
CSharpNET-unsubscribe (AT) yahoogroups (DOT) com

<*Your use of Yahoo! Groups is subject to: