|
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!
|
|
|
|
|
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... "
|
|
|
|
|
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 ?
|
|
|
|
|
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
Lady Programmers are a rare breed!
|
|
|
|
|
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 ?
|
|
|
|
|
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!
|
|
|
|
|
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);
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
use this...
Page.Request.Url.ToString()
Koushik
|
|
|
|
|
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.
|
|
|
|
|
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... "
|
|
|
|
|
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.
|
|
|
|
|
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... "
|
|
|
|
|
mr.mohsen wrote: it is "Request.UrlReferrer.AbsolutePath"
Yes it is. But this might generate an "Object reference" exception when there is no referer. So always check it is null before doing
if ( Request.UrlReferrer != null )
|
|
|
|
|
I want to print the page in C#/ASP.NET 2.0, but the problem is when i use following javascript code, it prints the whole page.
function printMe()
{
window.print();
document.getElementById("printed").value = "YES";
How to print specified contents in .NET 2.0?
document.getElementById("form1").submit();
}
I don't want to print the complete page but i just want to print the contents of the page only.
Do anybody have any idea?
Thanks in advance
|
|
|
|
|
hello,
for this u just need to use css media.
u have to create a new print css and have to include in ur aspx page.
like this..
div#header
{
display:none;
}
may help u this.
Amit Agarwal
|
|
|
|
|
can u please explain this in bit detail?
|
|
|
|
|
Put the content that you want to print in Div tag and put class="Printable"
Now in javascript get all div tag and check for their class if it is preintable get its content then open a new Window put all conetent in that window and prin t that window
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... "
|
|
|
|
|
What I want to do is, I have an index.aspx page, where all banners, images, links, contents are there.There are about 50 aspx pages, so should i have to put all the page's contents in div tag?
|
|
|
|
|
No i think you have to print only index page right,
place the things that you want to print in different/ same div tag
are you dislaying 50 pages in index page ? No i think
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... "
|
|
|
|
|
This is the code that i m writing, but error comes
Error: Object doesn't support this property or method.
at content.print();
line............
function printMe()
{
var content = document.getElementById ("divData");
content.print();
}
|
|
|
|
|
do one thing give the class name as printable to that div and use the below method i know its not right but you don't know javascript properly
<br />
<script type="text/javascript"><br />
function Print()<br />
{<br />
var copy = document.documentElement.cloneNode(true);<br />
var headContent = copy.getElementsByTagName("head");<br />
var divs = copy.getElementsByTagName("div");<br />
var content = ""; <br />
<br />
<br />
content = '<html>';<br />
content += '<head>' + headContent[0].innerHTML + '</head>';<br />
content += '<body >';<br />
for(i=0; i < divs.length; i++) <br />
{ <br />
var div = divs[i];<br />
if(div.className == "Printable")<br />
{content += div.innerHTML;}<br />
else if(div.className == "NotPrintable" && div.innerHTML.length > 0)<br />
{content = content.replace(div.innerHTML,'');}<br />
}<br />
content += '\n</body></html>';<br />
var pWin = window.open('', 'Print','directories=0,height=480,width=578,location=no,menubar=no,resizable=yes,scrollbars=yes,status=no,toolbar=yes');<br />
pWin.document.open();<br />
pWin.document.write(content);<br />
pWin.document.close();<br />
pWin.print();<br />
}<br />
</script><br />
<br />
Check this one<br />
<br />
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... "
|
|
|
|
|
bhavna816 wrote: I don't want to print the complete page but i just want to print the contents of the page only.
This is not possible. What you can do is put the content that needs to be printed on a new page, and that page should not contain any images/banners etc. When print option is initiated, redirect user to this page and open print dialog.
Hope this helps
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
