Alex,

one more thing to be aware of...

(as per readme in site generator). all code created by the generator will be overwritten by subsequent 'saves' into the same folder. so be careful if you've editted certain aspects (thinking mainly of aspx files -re filtering in particular) but need to re-run the generator to pickup new entities etc..)

jimi

http://www.originaltalent.com

alex, alas this propery only informs the gridview that it should 'present' a pager at the bottom of the gridview, you must provide the logic (whic tbh does) to calculate the number of pages via the pagesize and count attributes in the sqlclient methods.

jimi

http://www.originaltalent.com

Alex,

finally, before i slink off to bed - let me know if you both 'get' the genericPaged stuff to work AND understand how the paging works. it's important to appreciate that it isn't an 'out of the box' feature and actually requires a lot of thought and at times compromises to make it all work (i.e. any sortable column really does require an index created on the table. this isn't obvious with small datasets but will quickly become apparent as you scale up). the moral being really, only index (and provide sorting) on columns which actually are application 'essential'

jimi

http://www.originaltalent.com

Alex,

just about to sign off now, but here's my 'default' set of templates that my entire site has some heritage from:

http://www.originaltalent.com/downloads/Templates1.zip

hope this clarifies the paging stuff (if you look at the files in DAL\SQLClient)

catch you later

jimi

http://www.originaltalent.com

hi:

any progress on this...

"take any table (or set of tables) and based on PK&FK's, generate the parent child collections (LIST <T>..."

thanks

yes, i've redone a version of the site generator data.dll plus templates that does this. it still needs a tiny bit of tweaking, but is 99% stable and effective. i've put a copy of the dll and the new templates up for you to try. they come with no warrenty as i use them for my own purposes but let me know how you get on.

http://www.originaltalent.com/downlo...atesAndDLL.zip

jimi

http://www.originaltalent.com

well that was quick. many thanks. i'll give those a try.
quick question: what is the significance of grouping tables under one provider? should i be using one provider for any group of related tables?
thanks

forumuser - each provider acts as a functional 'holder' for related tables. so, for example, you'd group tbh_category, tbh_articles, tbh_comment under one provider (called for example 'Articles') and similarly, tbh_department, thb_order, tbh_orderitem, tbh_orderstatus, tbh_product and tbh_shippingmethod under a different provider (called for example 'Store'). this way you get very tight logical groupings of your source code which makes it easier to extract little bits of functionality from if required.

you may want to download that zip file again as i've included a small help file. but basically to summerise. what i said in the help file was the fact that for any table that has a foreignkey setup on it, you will NEED to setup an index for that field as well, as setting up a foreignkey doesn't actually create an index on the FK field, merely an association. if you have an FK setup and no matching index, you'll get errors in the generated code. to fix this, merely add the appropriate index. the help file gives a few examples.

good luck...

jimi

http://www.originaltalent.com

thanks jimi. further....supposing i have a table which is related to two tables which in themselves are unrelated. eg

emplyees related to departments

and

employees related to assessments

is there a rule for this or do i make a decision based on likely useage or do they all in fact come under the one provider in this case?
many thanks again for your help

forumuser - i think it's a judgement call in that case. at the end of the day, no matter which provider you group them under, they'll still be 'found' by the application. it's more an organisational benefit, rather than a functional definiton as such.

jimi

http://www.originaltalent.com