Cell with multiple values?

  • Thread starter Thread starter Holy Samosa
  • Start date Start date
H

Holy Samosa

I've only worked with very simple DataSets and database tables in the
past, so please forgive me if this is newbie question.

I'm trying to create a DataSet for items that can be associated with
any number of keyword tags (e.g. URL's tagged with keywords on
del.ico.us). Since a cell can't contain multiple values, what's the
proper way to represent the 1..n keywords for each row of the data?
Should the keywords be stored in a separate DataTable for each row?

I'm also very interested in using LINQ, if that would impact the
viable solutions.

Thanks!!
 
I've only worked with very simple DataSets and database tables in the
past, so please forgive me if this is newbie question.

I'm trying to create a DataSet for items that can be associated with
any number of keyword tags (e.g. URL's tagged with keywords on
del.ico.us).  Since a cell can't contain multiple values, what's the
proper way to represent the 1..n keywords for each row of the data?
Should the keywords be stored in a separate DataTable for each row?

I'm also very interested in using LINQ, if that would impact the
viable solutions.

Thanks!!
Click to expand...

A few additional hours of research and I've worked this out.

I've opted to go with multiple tables related by a foreign key.

Check out http://www.whatspop.com/blog/2006/01/setting-up-database-for-tagging.cfm
for a nice discussion on database table design for a del.ico.us-style
tagging application.
 
Back
Top