|
i am trying to write around 70,000 sql table data to XML in ASP.Net, but i am not able to get more than 4500 record in XML. What could be the problem, is there any solution for this problem ??????? 
|
|
|
|
|
What are you using to create the XML? If you are using the XmlDocument type you probably run out of memory.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
I have some XML tags stored in a string. This data is obtained through remoting.
I want the same to be displayed on an HTML page by using a Respose.Write. When I do a Response.write of the string then it loses its XML format and just displays as string alone.
Could I know how to display the same in XML format itself.
I tried using REsponse.ContenType = "text/xml", But this is giving me an error
|
|
|
|
|
anufabian wrote: But this is giving me an error
What error?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
It gives me the following error ::::
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
Cannot have a DOCTYPE declaration outside of a prolog. Error processing resource 'http://localhost/WebApplication10/WebForm...
----------^
|
|
|
|
|
Try calling the Clear method before writing the XML string to make sure the HTTP response contains nothing else.
Response.ContenType = "text/xml";
Response.Clear();
Response.Write(xmlString);
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
I am still getting the same error.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
Cannot have a DOCTYPE declaration outside of a prolog. Error processing resource 'http://localhost/WebApplication10/WebForm...
----------^
I assume that the line DOCTYPE HTML... is the firsy line written on an aspx page . Is this causing the problem. I tried to save the xml in a file , it works fine. However my requirement is to display the XML on an aspx page , along with the look and feel of XML .
|
|
|
|
|
anufabian wrote: However my requirement is to display the XML on an aspx page
Ah, I thought you want to send back the pure XML. My fault.
Take a look at the System.Web.UI.WebControls.Xml control and the continuative links in its documentation. I think they should help you to achieve what you want.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
The above technique did not help me. However I was able to solve the issue by using something like this.
Response.Write("<xmp>" + outputstring + "/xmp>");
This i got it from some one else. However I still dont understand what is the use of <xmp> tag.
If possible could you throw some light on this.
|
|
|
|
|
"The XMP tag displays a sequence of literal characters in the browser's default fixed-width font. The XMP element displays all white space and line breaks exactly as they appear inside the <xmp> and tags." (HTML Tag Reference[^])
Another resource (SelfHTML[^]) said that the xmp tag is no longer a part of the HTML standard. Though they are still supported by current browsers, one should not count on this. The resource suggests of instead using the pre tag. Since the pre element interprets HTML tags, you must use special symbols for any character that has a meaning in HTML that you wish to be displayed rather than interpreted. For example, use &< for the < symbol, and use &> for the > symbol.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
 Please help me to write code to establish the connection to SQL Server 2005 database in C#.net(VS 2005) windows application. Also I need to write select statements to retrieve data from the databse which is XML type.
Sanjeewani
|
|
|
|
|
Select * from sometable for xml auto, elements
|
|
|
|
|
Please help me to write code to establish the connection to SQL Server 2005 database in C#.net(VS 2005) windows application. Also I need to write se lect statements to retrieve data from the databse which is XML type.
Sanjeewani
|
|
|
|
|
Hello, I'm new to attributes. Attributes seem to solve a problem I have with my data representation. However, how are attributes stored in a database?
Specifically, I'm using VS'03 to build a typed data schema, wherein I create and populate some elements. I can use the SqlDataAdapter to load/retrieve from the dB, no problem. Now, I add attributes to the schema, how do I get them into the dB and what is the representation?
Thanks.
NYC Traveler
|
|
|
|
|
Hi everybody
I'm approaching xml schema language applied to custom
data files, but using diffgram schema too; I would like
to examine this schema.
Anybody knows where can I get from the internet? I
already gave a watch to some microsoft websites but I
don't find it...
thanks for any link you can submit me 
FPT
|
|
|
|
|
Hi,
In one of my projects , i got a problem
<ExtensionInfo ><br />
<ObjectExtension><br />
<Extension Name="test123" ExtensionType="SymbolExtension" InheritedFromTagName="" / ><br />
<Extension Name="test123" ExtensionType="ScriptExtension" InheritedFromTagName="" / ><br />
</ObjectExtension><br />
<AttributeExtension / ><br />
</ExtensionInfo>
when i pass test123 ,get_nodeValue is returning SymbolExtension.
I have no clue to get ScriptExtension.
Can any one of you help me to get the ScriptExtension by using get_nodeValue .
Thanks in advance.
Appu..
"If you judge people, you have no time to love them."
|
|
|
|
|
NiceNaiduwhen i pass test123 ,get_nodeValue is returning SymbolExtension.
What exactly is get_nodeValue doing?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
|
Ok, I never used that API but as far as I can see from the docs, you have to use a method like getElementsByTagName to select the Extension elements and then do any further work on the second element in the returned list. In the MSDN topic of getElementsByTagName an example is given that selects all media nodes, iterates through the node list and display the node value of every attribute for every node in the list. IXMLDOMDocument::getElementsByTagName[^]
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
am using the xml file to imoprt data to my Page but xsl style sheet is not applying to the WEb page my code is : (using ASP.NET)
Dim xmlPath As String = Server.MapPath("XMLFile.xml")
Dim xslPath As String = Server.MapPath("XSLTFile.xsl")
Dim fs As FileStream = New FileStream(xmlPath, FileMode.Open, FileAccess.Read)
Dim reader As StreamReader = New StreamReader(fs, Encoding.UTF8)
Dim xmlReader As XmlTextReader = New XmlTextReader(reader)
'Instantiate the XPathDocument Class
Dim doc As XPathDocument = New XPathDocument(xmlReader)
'//Instantiate the XslTransform Class
Dim xslDoc As XslCompiledTransform = New XslCompiledTransform()
xslDoc.Load(xslPath)
Dim sw As StringWriter = New StringWriter()
xslDoc.Transform(doc, Nothing, sw)
' //Close Readers
reader.Close()
xmlReader.Close()
Response.Write(sw.ToString())
Feroze
|
|
|
|
|
The code looks ok to me, so I guess the error is within the stylesheet. It would be helpful to see the XML and XSLT file (or at least some exemplary parts).
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
HI,
How can i transfer sql data to the xml file plsssss give me the solution
C.P.Desai
|
|
|
|
|
You can visit this web-page. I think this helpful.
http://www.15seconds.com/issue/001102.htm
SELECT store.stor_id as Id, stor_name as Name, sale.ord_num as OrderNo,
sale.qty as Qty
FROM stores store inner join sales sale on store.stor_id = sale.stor_id
ORDER BY stor_name
FOR XML <MODE>
* RAW Mode or AUTO Mode
|
|
|
|
|
i am using the xml file to imoprt data to my Page but xsl style sheet is not applying to the WEb page my code is : (using ASP.NET)
Dim xmlPath As String = Server.MapPath("XMLFile.xml")
Dim xslPath As String = Server.MapPath("XSLTFile.xsl")
Dim fs As FileStream = New FileStream(xmlPath, FileMode.Open, FileAccess.Read)
Dim reader As StreamReader = New StreamReader(fs, Encoding.UTF8)
Dim xmlReader As XmlTextReader = New XmlTextReader(reader)
'Instantiate the XPathDocument Class
Dim doc As XPathDocument = New XPathDocument(xmlReader)
'//Instantiate the XslTransform Class
Dim xslDoc As XslCompiledTransform = New XslCompiledTransform()
xslDoc.Load(xslPath)
Dim sw As StringWriter = New StringWriter()
xslDoc.Transform(doc, Nothing, sw)
' //Close Readers
reader.Close()
xmlReader.Close()
Response.Write(sw.ToString())
please tell me about the problem!
Feroze
|
|
|
|
|
Hi all,
How can I convert all the data that is present in SQL server in to XML format. If its big, then atleast provide me some link. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
