Application implementations level Add/Removing Controls
-
I saw in many CRM products allowing there customers to add Fields at implementation level Example: Customer of CRM Product can add “Phone2 “ as an extra field in to Registration form Can any buddy tell me how this type of Architecture design will work?
-
I saw in many CRM products allowing there customers to add Fields at implementation level Example: Customer of CRM Product can add “Phone2 “ as an extra field in to Registration form Can any buddy tell me how this type of Architecture design will work?
Yes. Read me article at http://www.garyshort.org/?p=734[^] Also see http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sdshs[^] and http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sepdat[^] and http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sdss[^]
-- Cheers, Gary http://www.garyshort.org
-
Yes. Read me article at http://www.garyshort.org/?p=734[^] Also see http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sdshs[^] and http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sepdat[^] and http://msdn2.microsoft.com/en-us/library/Aa479086.aspx#mlttntda_sdss[^]
-- Cheers, Gary http://www.garyshort.org
Thank you Gary But my question was many CRM Applications giving functionality to client to add controls/fields to product without knowledge of vendor like Outlook forms you can add your own fields -- Regards Pritesh
-
Thank you Gary But my question was many CRM Applications giving functionality to client to add controls/fields to product without knowledge of vendor like Outlook forms you can add your own fields -- Regards Pritesh
Yes. The articles I pointed to in my previous answer show you how to allow customers to store their specifically required information. You can then query the database and generate fields (at runtime) to supply the required information.
-- Cheers, Gary http://www.garyshort.org
-
Yes. The articles I pointed to in my previous answer show you how to allow customers to store their specifically required information. You can then query the database and generate fields (at runtime) to supply the required information.
-- Cheers, Gary http://www.garyshort.org
but how we will query those fields without our knowledge mean to say we do not know which fields they created. -- regards Pritesh
-
but how we will query those fields without our knowledge mean to say we do not know which fields they created. -- regards Pritesh
The following T-Sql code will return the names of all the columns and their data types for a given table (in this example the table is titles from the pubs database). You can then use this to add controls at run time. SELECT c.name, t.name AS [Data Type] FROM sysobjects o INNER join syscolumns c ON c.id = o.id INNER join systypes t ON t.usertype = c.usertype WHERE o.name = 'titles' ORDER BY c.name
-- Cheers, Gary http://www.garyshort.org