Click here to Skip to main content
16,012,107 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Dear Sir/Madam,
I am trying to make an office automation system and in one of the pages I need to fill an additional information.
Here I have to add the fields like hobbies by myself and another field to enter the hobbies, now when, i add it, it will go to the admin for authorization.
If the admin authorizes it, it will be added to a table in the database, and now it will be a permanent field in the data table. Now another user enters he will get hobbies field already there in the additional information and another field as empty, where he can enter the hobbies.
Now if another user does the same like enter a new field, it will follow the same procedure and a new field is created permanently, and an empty field wherein they can enter information regarding the first field and then it will be saved in the table on admin authorization.
Please help me out as I need the code urgently.
Posted
Comments
Richard MacCutchan 28-Feb-13 7:31am    
No one is going to write this code for you, that is your job. However if you are having specific problems then modify your question with the details and people will try to help you. And please don't tell us it's urgent, we have our own priority lists.

1 solution

It's not really clear ; if I understand you correctly you want to add columns (not fields) in your table dynamically according to users inputs ?

It seems like a design-issue to me : rather than adding a column to the table, have a second table with its own primary key, a reference to your first table, and a column to store user's input.

This way, your problem would be changed from : adding a column to a table from user input to : adding a row to the second table from user input.

But it's just a guess, as the informations you gave are way too insufficient.

Good luck anyway.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900