ASP.NET

11-Oct-07 1:12

Hi,

Am I sending this XML to a SP in SQL:-

<?xml version="1.0" encoding="utf-8"?><Entities xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Entity><ID>5a939ee4-37ef-416f-b658-04b5c759d065</ID><Type>OWNSITE</Type><Name>125 NAS2</Name><ImportCode>00125E</ImportCode></Entity></Entities>

Although it seem that SQL 2005 doesnt like encoding="utf-8"

I am creating this xml by running a Serialize method in my EntityCollection, by using the following code:-

public string Serialize()
{
return XMLUtil.SerializeClass(this, GetType());
}

Before a pass this XML in the DAL to the SP I am trying to replace encoding="utf-8" with string.empty, with not to much success.

Just wondering that's the best way around my problem, should I try & replace with empty string, or should I not have it there in the first place?

Either way, I'm not sure how to do this in code.

Anyone any ideas?

Many thanks
janet

Lady Programmers are a rare breed!

Sandeep Akhare11-Oct-07 1:59

Sandeep Akhare

11-Oct-07 1:59

try to change the Ecoding property to different one
i am not sure but using xmlwriter in setting you have Encoding property try to give different one

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

N a v a n e e t h11-Oct-07 2:00

11-Oct-07 2:00

But_Im_a_Lady wrote:
Am I sending this XML to a SP in SQL:-

Are you storing this XML in a table ?

But_Im_a_Lady wrote:
Although it seem that SQL 2005 doesnt like encoding="utf-8"

What error you got ?

My Website | Ask smart questions

But_Im_a_Lady11-Oct-07 2:04

11-Oct-07 2:04

no Im not storing this XML directly into a table.
I am passing two lots of XML into the SP, as 2 separate param's, where the data will be stored in various tables.

The error that I get is:-

Msg 9402, Level 16, State 1, Procedure ksspnapp_SetProperties, Line 0

XML parsing: line 1, character 38, unable to switch the encoding

Confused | :confused:

Lady Programmers are a rare breed!

N a v a n e e t h11-Oct-07 2:08

11-Oct-07 2:08

Ok , so you are trying to read the XML values from stored procedure. Right ? I am not much familiar with this method. How about reading this values from your page and transmitting only the values ?

My Website | Ask smart questions

But_Im_a_Lady11-Oct-07 2:16

11-Oct-07 2:16

Yes, I am reading the xml values and placing them into a temp table.
The SP has to be called this way, otherwise due to the amount of data that can be changed in the UI, it could mean upto 2000 updates - so rather than 2000 calls to the DB I am doing this only once.

If I manually remove the encoding="utf-8" when I execute the SP through SQL it works ok!

So all I need to do is somehow is to remove this from the XML before I pass it into the SP.

The problem I have is that the first part of the XML is :-

<?xml version="1.0" encoding="utf-8"?><

How do I remove the encoding="utf-8" by using Replace ?

Lady Programmers are a rare breed!

N a v a n e e t h11-Oct-07 2:22

11-Oct-07 2:22

But_Im_a_Lady wrote:
How do I remove the encoding="utf-8" by using Replace ?

string a = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
string Result = a.Replace("encoding=\"utf-8\"",string.Empty);

My Website | Ask smart questions

But_Im_a_Lady11-Oct-07 2:26

11-Oct-07 2:26

N a v a n e e t h wrote:
("encoding=\"utf-8\"",

Great, thats what I was struggling with.

Im sure there is a better way to do this, ie to have something in the serialize method to just omit this text, but this way will have to do for now.

Many thanks, again!

Janet

Lady Programmers are a rare breed!

N a v a n e e t h11-Oct-07 2:57