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

whats the url of requester?/?????

11-Oct-07 2:57

But_Im_a_Lady wrote:
Many thanks, again!

Welcome.

But_Im_a_Lady wrote:
Im sure there is a better way to do this, ie to have something in the serialize method to just omit this text,

Yes it is possible. Set the encoding type to some other type. How you are serializing XML file ? With a TextWriter object or XMLWriter object. To set different encoding, you have to choose XMLWriter object. It provides option to specify encoding

My Website | Ask smart questions

mr.mohsen11-Oct-07 1:09

mr.mohsen

11-Oct-07 1:09

hi friend's
how can i get the url of the page that request the specific of the page of my site?
thank you for your help.

nobody help you...
you have to help you yourself
and this is success way.

Spunky Coder11-Oct-07 1:13

Spunky Coder

11-Oct-07 1:13

use this...

Page.Request.Url.ToString()

Koushik

mr.mohsen11-Oct-07 1:20

mr.mohsen

11-Oct-07 1:20

no my friend's
this attribute just return the url of the requested page not requester page.
assume that a user request my page(www.MYSITE.com/001.aspx) from "www.WEBSITE.com/index.html"
i need a technique to get the second url[www.WEBSITE.com/index.html]

nobody help you...
you have to help you yourself
and this is success way.

Sandeep Akhare11-Oct-07 1:25

Sandeep Akhare

11-Oct-07 1:25

Check the Request Object might be there you would find. Not confirm but check

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... "

mr.mohsen11-Oct-07 1:33

mr.mohsen

11-Oct-07 1:33

thank you
be sure...
it is "Request.UrlReferrer.AbsolutePath"
thank you again

nobody help you...
you have to help you yourself
and this is success way.

Sandeep Akhare11-Oct-07 1:34

Sandeep Akhare

11-Oct-07 1:34

mr.mohsen wrote:
nobody help you...
you have to help you yourself
and this is success way.

:-> here is the answer

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:03