Converting XML and Hex..

Here is the code, basically it opens up the xml file, finds some text, and changes the text.  Then converts it to Hex and inserts it into the database (the xml files are stored as blobs in a database)

if (rdr.HasRows)
                {
                    rdr.Read();
                    xmlText = System.Text.Encoding.ASCII.GetString((byte[])rdr[0]);
                    string[] separators = { "<my:Status>", "</my:Status>" };

                    // result contains the status text
                    string[] result = xmlText.Split(separators, StringSplitOptions.RemoveEmptyEntries);
                    statusTxt = result[1];
                    // replace the status text with closed
                    xmlTextClosed = xmlText.Replace(statusTxt, "Closed");

                 
                    // next insert the xml back into db
                    //open conn
                    //SqlConnection connS2 = new SqlConnection(connectionInfo);

                    connS2.Open();
                 
                    Encoding encoding = Encoding.GetEncoding("IBM437");

                    byte[] bytestxt = encoding.GetBytes(xmlTextClosed);


                    //convert to Hex
                    string bytesStr = "0x" + BitConverter.ToString(bytestxt).Replace("-", string.Empty);

                    string sqlInsert = "UPDATE TABLE SET FIELD =  " + bytesStr + " WHERE FIELDNAME ='ECR" + ecrFilename + ".xml'";
                    SqlCommand insCmd = null;
                    insCmd = new SqlCommand(sqlInsert, connS2);
                   

                    insCmd.ExecuteNonQuery();
                   

                }


But the last 6 characters are missing from the XML file.  Is it anything to do with my array size?  I would post some XML but the xml file is huge.

The XML ends like this:  </my:Fields>
But for some the xml looks like this at the end: </my:Fi
i.e. the "ields>"  is missing from the end of the xml file.

Hoep this makes sense

Any help on this?

Thanks

I don't get why you are messing with Hex and bytes at all.  

If you want to read XML, then update the database with that value, just use System.Xml.XPath.  You can use an XPathNavigator to find the Name that equals the element you want, and then get its value as a string.  You can then manipulate that string however you want, then you update the database with a CommandText on a SqlCommand object that goes something like sqlCmdText = new SqlCommand("UPDATE myDatabase SET VALUES myValue=" + myXmlValue); and sqlCmdText.ExecuteNonQuery(); .  Not sure if that helps, but a lot easier than bytes and encoding and all.