dimanche 1 mars 2015

How to save list of team members in asp.net to sql server database table?

I am designing a Follow up report form in asp.net for employees to enter data in it and save the data to the database table. The form looks as below,


enter image description here


I know to save data until team members as they are either one selection or textbox value but I don’t know what to do about Team members. There may be up to 16 members in a team. How shall I save it in the database? Shall I create 16 different varchar fields like teammember1, teammember2, … teammember16 but that will be too much. Which asp.net control to use for this team members values? Shall I use separate textboxes for each member in team? I am really confused what to do about team members in the above form. Could anyone help me and let me know how to do it correctly.


Aucun commentaire:

Enregistrer un commentaire