I want to add the 2-dimentional array in the sql server 2000 using c#. But the problem is that there is not array data type in sql. Kindly help me that how can I add the 2-dimentional array in sql server. Thanx for viewing my question...
Add a comment
|
4 Answers
A 2-D array is, essentially, a table. So you need to add a table to your database to hold this array. If you need to hold multiple array instance than add an additional column to store a key that will be common to individual arrays.
Comments
You don't need to create an additional column for each dimension as the currently accepted answer says. It's all about serialization.
- In SQL Server create a column of type Image to store the n-dimensional array. If you are using SQL server 2005 or superior, use VARBINARY(MAX) instead of Image.
- In C#, serialize your n-dimensional array so you can handle it as a 1-dimensional array (byte[])
- Save the serialized data into the Image field.
Of course, when you need to fetch the information from the database, you will get a byte array. Then you will need to deserialize that to your orginal type (the n-dimensional array).
Need an example?
Look at this similar question where I posted an example for doing it with a varbinary field. It should be very similar in SQL 2000.
Comments
Database fields are used for storing single items of data. Any data structures must be mapped to columns and tables in the database - not added to individual database fields.
What sort of data are you storing? If you want to do any kind of indexing or searching of the individiual items of the array then you'd be far better coming up with a database design to reflect the data you're modelling (so an array of cartesian coordinates mgiht map to a table containing x,y and z columns).
If this is to simply store some data for later retrieval then you can add it as a BLOB field and just serialize and deserialize to and from it.
Comments
Don't know what you are trying to accomplish since you are not giving any details but take a look at Arrays and Lists in SQL Server 2005 or Arrays and Lists in SQL Server (SQL 2000 and Earlier)
