sql server - what is the best way to manage application user options in C# and sql? -


my application has dozens of comboboxes filled lists of values.

i wonder best way store these values in db since user can add/remove :

  1. store in xml in sql server ?
  2. store in text file on server ?
  3. any best practice ?

thanks john

i keep track of them in table on sql server. if user can define each field, need table field name, value, , userid. can extrapolate of there.

of course, want use key of kind linked table defines each type of field possible, if needed.

one row per key/value (combobox) should trick.


Comments