Foreign Key Autocomplete

Question

User-1733504089 posted

Split off from http://forums.asp.net/t/1666394.aspx/1?Foreign+Key+Autocomplete#

sjnaughton, Is possible to use your Foreign key autocomplete in Dynamic data of VS 2008? I can not upgrade to DD 4.0 now. Thanks

Answer 1

User-330204900 posted

yes it is I think my first build was for DD .net 3.5 SP1 let me see... yes I found it here: Dynamic Data and Field Templates - An Advanced FieldTemplate

Answer 2

User-1733504089 posted

Steve, thank for your reply. I saw that before and follow your post today, I found it does not work when the column is foreign key, it try to query the current table instead of the table it links to. Also On the list page, the foreign key column does not show any data; when click edit, the link table name is shown up in the column. Have you experienced that before? How to fix those? Thanks 

Answer 3

User-330204900 posted

Sorry about that, I'm not sure what is wrong with that as it was originally set to work with FK as it was converted from a filter.

Answer 4

User3866881 posted

Hello Ronwang：）

Since naughton's solution has a nice sample of that……I guess you can try to download his sample and try to do some modifications based on your db or something else。Have a try with that to see what's happening。

Reguards！

Answer 5

User-1733504089 posted

Steve, where can I find the source code for this? So I can try to figure it out. Thanks

Answer 6

User-1733504089 posted

Steve, in http://csharpbits.notaclue.net/2008/07/dynamic-data-and-field-templates_28.html

Is this still valid? You said you have changed it to work with foreign key in your early reply.

Note: This does NOT work with foreign key fields it’s a text field only thing

Answer 7

User3866881 posted

Steve, in http://csharpbits.notaclue.net/2008/07/dynamic-data-and-field-templates_28.html

Is this still valid? You said you have changed it to work with foreign key in your early reply.

Note: This does NOT work with foreign key fields it’s a text field only thing

No。MVP has offered you a download link（have you seen the https://skydrive.live.com/?cid=96845e7b0fac1eed&id=96845E7B0FAC1EED%21319）DD_FieldAutoComplete sample。

Answer 8

User-330204900 posted

I have I just don't seem to have published it anywhere, I do however have the source up on codeplex you can get it here http://ddextensions.codeplex.com/ you will need to mess around a little to get it working but all the bits ar there.

My Project on Codeplex will be up an running soon with everythigh working. simple installs from NuGet and a Project Template.