December 8, 2011 at 3:31 am
Hello frnds,
I am struck in designing a table.pls help me out.
I have a fixed database schema and in my UI users can add certain fields dynamically(label,textbox). My question is what is the best approach to capture the values of newly added controls (as table design in fixed..there is no table mapping for those fields)...Let me know how to design such a table?
Thanks,
December 8, 2011 at 5:18 am
UI shouldn't do it. It's very BAD practice. If at all required to add something in table at runtime, use XML data type or add a table to store additional columns as rows (Key - Value Pair).
If you provide more information on your requirements we would be able to help you better. Also, if you are new in Data Modelling I would recommend you to hire a professional. Database Designing issues can’t be taken lightly.
December 8, 2011 at 5:35 am
What you need to do is set up a design where the tables define the screen. That's going to be hard to build and hard to program. No way around it.
In general, what you do is define basic storage as a name/value pair. Then, you have to define a set table for the names that lets you list the names associated with a particular user. You also have to have a name table that lets the users define what names they want to have.
I can't give you the full design (unless we're talking part time contracting, which I'm not available until at least March). But post your ideas here and people can help out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply