Need help retrieving a byte array from SQL 2000 and converting it to a string

[jenniamia]

I need to make the string "myFile" into a byte[] and then put it in the database as a file/image, where later it needs to be pulled out and back into a string from the byte[]. I'm really having trouble gettting it back into a string afterwards, but I don't even know if the data is being put in the database with correct values. Any suggestions or pointers would be much appreciated. Thanks!

(I posted the main section I'm having trouble with, but I can post more or something different if it's needed.)

 
                FileStream fStream = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.ReadWrite);
                BinaryWriter bw = new BinaryWriter(fStream);
                bw.Write(myFile);
 
                //Create byte[] from string "myFile"
                int length = myFile.Length;
                byte[] xmlDataArray = new byte[length];
                fStream.Read(xmlDataArray, 0, length);
 
                //Upload byte[] xmlDataArray to database
                conn.Open();
                SqlCommand cmd = new SqlCommand("INSERT INTO FileList (SetID, XMLFile) VALUES (@SetID, @XMLFile)", conn);
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("SetID", _SetID).SqlDbType = SqlDbType.Int;
                cmd.Parameters.AddWithValue("XMLFile", xmlDataArray).SqlDbType = SqlDbType.Image;
                cmd.ExecuteNonQuery();
 
                //----------------------------------------------------------------------------------
                //Retrieve stored xmlDataArray from database
                SqlCommand cmmd = new SqlCommand("SELECT XMLFile FROM FileList WHERE SetID=@SetID", conn);
                cmmd.Parameters.Clear();
                cmmd.Parameters.AddWithValue("SetID", _SetID).SqlDbType = SqlDbType.Int;
                byte[] xmlDataArrayOut = (byte[])cmmd.ExecuteScalar();
 
                //Convert byte[] back to string
                ASCIIEncoding encoding = new ASCIIEncoding();
                string constructedString = encoding.GetString(xmlDataArrayOut);
 

[debasisdas]

As you have posted a question in the Article section it is being moved to SQL Server Forum

MODERATOR

[jenniamia]

Just in case anyone else made this mistake, I used encoding to get it into a byte array and later used encoding to get it out. Anyway, seems like that should've been obvious before, but this was what worked for me.

FileStream fileStream = new FileStream(toolFile, FileMode.OpenOrCreate, FileAccess.ReadWrite);
StreamReader streamReader = new StreamReader(fileStream);
myFile = streamReader.ReadToEnd();
 
//Create byte[] from string "myFile"
int length = myFile.Length;
byte[] xmlDataArray = new byte[length];
 
System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();
xmlDataArray = encoding.GetBytes(myFile);
 
//Upload byte[] xmlDataArray to database
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO FileList (SetID, XMLFile) VALUES (@SetID, @XMLFile)", conn);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("SetID", _SetID).SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("XMLFile", xmlDataArray).SqlDbType = SqlDbType.Image;
cmd.ExecuteNonQuery();
 
//----------------------------------------------------------------------------------
//Retrieve stored xmlDataArray from database
SqlCommand cmmd = new SqlCommand("SELECT XMLFile FROM FileList WHERE SetID=@SetID", conn);
cmmd.Parameters.Clear();
cmmd.Parameters.AddWithValue("SetID", _SetID).SqlDbType = SqlDbType.Int;
byte[] xmlDataArrayOut = (byte[])cmmd.ExecuteScalar();
 
//Convert byte[] back to string
ASCIIEncoding encoding = new ASCIIEncoding();
string constructedString = encoding.GetString(xmlDataArrayOut);