?
Solved

vb.net Store hashtable in SQL Database Field

Posted on 2010-08-30
2
Medium Priority
?
911 Views
Last Modified: 2012-05-10
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
Comment
Question by:Sitewizard
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 33568732
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
 

Author Comment

by:Sitewizard
ID: 33569215
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question