Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 927
  • Last Modified:

vb.net Store hashtable in SQL Database Field

I am trying to figure out how to store a hashtable in a MS Sql Server tables field.  I do not want to create a file in the process,  I simply want to store the hashtble in a field of the sql server table.
0
Sitewizard
Asked:
Sitewizard
1 Solution
 
Ryan McCauleyData and Analytics ManagerCommented:
Are you looking to store the hashtable in a database with each pair as a row (key in one column, value in another), or in a single cell (serializing the hash table and storing it in one place)? I don't believe there's any way to store it as a set of pairs without iterating over the table and dealing with each key/value pair (maybe an ORM like NHibernate could do it, but I don't suspect it could), but to serialize it to the database, you can use the code at the following link:

http://blogs.techrepublic.com.com/howdoi/?p=143
0
 
SitewizardAuthor Commented:
I was looking to serialize the hashtable and store it in on binary field in the sql server.  i will have a look at the link you prvided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now