|
|
Dear all,
i have one table named ContactPerson in which there is one column named "PersonImg" which has a datatype - image and it stores image(.gif, .jpeg) in binary format.
Now i want to insert that table data into one XML file, but i get an error when i insert image data into XML.
Needed yr help.
Thanks in advance
Regards,
Rana k.j.
|
|
|
|
|
krish_rana16 wrote: Needed yr help.
Only because you refuse to study the subject yourself. There is an enormous amount of information available on the internet and probably even articles on this site that discuss and provide example code for doing just that. Lazy people who won't do their own work do not frequently find help here on CodeProject. In case you don't realize it, studying and reading documentation is part of a developers work. 
led mike
|
|
|
|
|
Hi everyone:
I'm having trouble exporting the follow query to XML in a valid format. For some reason it wraps in the middle of a few elements causing .NET to say the end tag is missing. I'm using SQL '05 and when I show the query results in text the same exact thing happens.
Is it possible for to "Export to File" from within Management Studio and specify the format?
<br />
SELECT DISTINCT origin_location AS location<br />
FROM famis_locations<br />
WHERE origin_location <> ''<br />
ORDER BY origin_location<br />
FOR XML AUTO, ELEMENTS<br />
Thanks!
|
|
|
|
|
nickiii wrote: I'm having trouble exporting the follow query to XML
I'm assuming you mean inserting the SQL String as text into an XML TextNode yes?
nickiii wrote: For some reason .... causing .NET to say the end tag is missing.
you can't store text in XML that contains the lessthan and/or greaterthan ('<', '>') characters since they are XML syntax characters. There are various methods to account for this like using entities or encoding the string and then decoding it when you read it back into memory.
led mike
|
|
|
|
|
led mike wrote: I'm assuming you mean inserting the SQL String as text into an XML TextNode yes?
No. The posted query is what I use to get the locations from SQL. I want to export the location list to XML and read the XML with .NET. The query is actually being ran in Query Analyzer.
|
|
|
|
|
Ah, I should have figured that from the FOR XML, by bad.
However it's probably the same problem with the results from the query containing invalid XML Text characters.
You might find more detailed answers in places like this[^]
led mike
|
|
|
|
|
I Googled this issue earlier and that site came up. Just thought I'd take the easy way out hoping someone has tried the exact same thing as myself.
Thanks for responses led mike!
|
|
|
|
|
Hi
Can i anyone provide me the links for the conversion of XML to XHTML in .Net.
Thanks in Advance.
|
|
|
|
|
|
Hi,
I have created a XMLWeb Service and there is a class like this
class CUSTOMER
{
public string user;
public string password;
}
I have to used above two attributes in many classes inside the namespace .That 's why I have to declare them as public.
In addition , I need to hide above attributes when clients access my xmlwebservice. becasue those variables are using inside the namespace classes only.
abcservice lobjservice=new abcservice()
lobjservice.customer.user="";
lobjservice.customer.password="";
How do I hide 'user' and 'password' ,when we are accessing the service?
|
|
|
|
|
 Hi....
I have a XML file which contains text and encoded waveforms of an ECG....
We had extracted the text, but we don't know to extract the waveform...
Please give a sample code to decode it...
Please reply as soon as possible...
|
|
|
|
|
Hi,
I am developing RDLC (Report) using XSD dataset. I have one doubt is that suppose multiple users display at a time report then can be it possible data show duplicate, because i am using XSD and its store as a XML. Means if users show parallel reports then all users show according to user select criteria and not all users show same reports because i am using XSD. I think you all understand my problem. Any suggestion? One more problem is that when i am insert new field or delete field from table then XSD not updated frequently and also report not show that updated fields. I am currently writing manually in XML file of report for update field related entry. Means updation in database table not update in XSD or Report.
Thanks
Do hard work, you will get result sure !
|
|
|
|
|
I have a code that get a record on table using xsl since my fields are dynamic I dont have the exact name of the field, Intead of the field name I'm thinking if I can use the index of the table to get the record
My sample code
<xsl:for-each select="NewDataSet/Info">
<xsl:value-of select="FIRST_NM"><xsl:value-of select="MIDDLE_NM"><xsl:value-of select="LAST_NM"><xsl:value-of select="ADDRESS"><xsl:value-of select="TEL">How can I change the field name into index field?
Thanks
|
|
|
|
|
I have an HTML file that loads an XML and XSL. If I open the file locally, it works. If I open it remotely, it fails. It works in IE both ways. My folder structure is like this.
FILE.HTML
./includes/css/FILE.css
./includes/js/FILE.js
./includes/xml/FILE.xml --- (XML_file_name) ---
./includes/xsl/FILE.xsl --- (XSL_file_name) ---
Here's the FF part of the code.
// For Firefox.
else if (document.implementation && document.implementation.createDocument)
{
// Load XSL.
var processor = new XSLTProcessor();
var xslt = document.implementation.createDocument("", "", null);
xslt.async = false;
xslt.load(XSL_file_name);
processor.importStylesheet(xslt);
// Load XML.
var src_doc = document.implementation.createDocument("","", null);
src_doc.async = false;
src_doc.load(XML_file_name);
var result = processor.transformToDocument(src_doc);
// Transform.
var xmls = new XMLSerializer();
output = xmls.serializeToString(result);
}
Anyone knows why this won't work? Do all my XML and XSL have to be in the same path?
Thanks!
"I know which side I want to win regardless of how many wrongs they have to commit to achieve it." - Stan Shannon
Web - Blog - RSS - Math - LinkedIn - BM
|
|
|
|
|
Hi
My xml looks like this and I have pasted the code below to parse. The issue is : The first two table nodes have just the LocnId info. So when I fetch LocnId and Zip code, the result of parsing is like this
LocnId Zip
1 30339
2 20000
8 undefined
9 undefinde
Expected output is
LocnId Zip
1 null
2 null
8 30339
9 20000
<NewDataSet>
<Table>
<LocnId>1</LocnId>
</Table>
<Table>
<LocnId>2</LocnId>
</Table>
<Table>
<LocnId>8</LocnId>
<Zip>30339</Zip>
</Table>
<Table>
<LocnId>9</LocnId>
<Zip>20000</Zip>
</Table>
</NewDataSet>
var xmlDoc = new ActiveXObject("Microsoft.XMLDOM")
xmlDoc.load("data.xml");
var x = xmlDoc.getElementsByTagName('Table');
for (var i = 0; i < x.length; i++)
{
LocnId = xmlDoc.getElementsByTagName("LocnId")[i].childNodes[0].nodeValue;
Zip = xmlDoc.getElementsByTagName("Zip")[i].childNodes[0].nodeValue;
}
I am trying to figureout other methods to fetch the node values, but havent figured out yet, any links/help is greatly appreciated.
Thanks
Joe
|
|
|
|
|
You can try XPath[^], which is easy and efficient.
|
|
|
|
|
<root>
<child id="1">
<child id="2">
</root> I have above XML file. I need to find out maximum value of the "id" attribute. I have done by getting all nodes and iterating through each one. I tried XPath also, but it don't have any method to find maximum value. Is there any other method to do this ? This XML file may have thousands of child nodes.
|
|
|
|
|
N a v a n e e t h wrote: I have done by getting all nodes and iterating through each one.
Is there a problem with that?
led mike
|
|
|
|
|
led mike wrote: Is there a problem with that?
Nope. It works well. But is there any other alternative for doing this ? As I will have many nodes, this method may be performance costly.
|
|
|
|
|
|
Try this one XPath-Expression:
child[not(../child/@id > @id)]/@id
|
|
|
|
|
Hi All,
I have XML Schema file(.xsd). I want to make a XML document(.xml) from it. Is there any tool/converter available for that? or I have to make it manually? Please help.
Thank you,
Regards.
|
|
|
|
|
dan neely wrote: Have grammar, need program to write book.
dan replied to the exact same question from another person. Do you understand his reply?
led mike
|
|
|
|
|
Hi led mike!
Thank you for reply. I have found the solution at MSDN. It's working fine for my XSD.
Regards.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
