How Can I Store an Object in SQL Server?

[Smeat]

Hi

I have a object variable in my DALC which could contain a string, int, class, image or any other datatype.

What I need to do is store this object in SQL Server. I am using an Image data type in SQL Server to store this data but have no idea how to convert my object into a format that can be sent into my stored procedure which expects an Image data type.

Can anyone tell me how to do this.

TIA

Smeat

 

[VBakias]

I think that you should use serialization.

 

[Smeat]

Hi VBakias

I understand how to use serialization but I have no idea how to convert my object into a format that can be used to send into my stored procedure which expects an Image data type.

Any help appreciated

Smeat

 

[VBakias]

What image data type ?

 

[Smeat]

SQL Server Image data type.

 

[shifar]

// create a byte[] for the image file that is uploaded
int imagelen = Upload.PostedFile.ContentLength;
byte[] picbyte = new byte[imagelen];
Upload.PostedFile.InputStream.Read (picbyte, 0, imagelen);
// Insert the image and image id into the database
SqlConnection conn = new SqlConnection
// (" connection string ...");
try
{
conn.Open ();
SqlCommand cmd = new SqlCommand ("insert into ImageTable " + "(ImageField, ImageID) values (@pic, @imageid)", conn);
cmd.Parameters.Add ("@pic", picbyte);
cmd.Parameters.Add ("@imageid", "image text");
cmd.ExecuteNonQuery ();
}
finally
{
conn.Close ();
}