|
Hi,
the problem of loading xml+xsl is solved for mozilla.the problem was i ddin't know mozilla doesn't support external dtd.it works fine for internal dtd.But IE cannot load either external or internal.i used several alerts in several position.all are showed in output.but the transformed xml page does not show.
function loadXMLDoc(fname)
{
var xmlDoc;
// code for IE
if (window.ActiveXObject)
{
xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
alert("LoadXML");
}
// code for Mozilla, Firefox, Opera, etc.
else if (document.implementation
&& document.implementation.createDocument)
{
xmlDoc=document.implementation.createDocument("","",null);
}
else
{
alert('Your browser cannot handle this script');
}
xmlDoc.async=false;
xmlDoc.load(fname);
return(xmlDoc);
}
function displayResult()
{
xml=loadXMLDoc("Book2006_Overview.xml");
xsl=loadXMLDoc("Book2006_manee.xsl");
// code for IE
if (window.ActiveXObject)
{
ex=xml.transformNode(xsl);
document.getElementById("example").innerHTML=ex;
alert("after innerHTML");
alert(ex);
}
// code for Mozilla, Firefox, Opera, etc.
else if (document.implementation
&& document.implementation.createDocument)
{
xsltProcessor=new XSLTProcessor();
xsltProcessor.importStylesheet(xsl);
resultDocument = xsltProcessor.transformToFragment(xml,document);
document.getElementById("example").appendChild(resultDocument);
}
}
|
|
|
|
|
Hello together,
i wondered if there's a simple possibility to combine several xml schemata in one single file?
The schemas are connected using include-statements.
It would be nice instead of deploying several files at once to deploy just one.
I'm using Altova XML Spy 2008 for creating the schemas.
Thanks for any help!!
happy programming...
|
|
|
|
|
I’m a novice in XSD and not know some. I use MS Visual Studio 2005 to generate XML schema by dragging table from Server Explorer. Some column properties are not generated in xsd file. I want to add them but not know how to add them or whether they should be added or not. Pls help me.
1. I don’t know how to identify these column properties based on Microsoft SQL Server, in XML schema?
eg,
In SQL,
Create Table Employee(
EmpID int identity Not Null,
Constraint PK_Employee Primary Key (EmpID)
)
In XSD,
<xs:element name="“Employee”">
<xs:complex type="">
<xs:sequence>
<xs:element name="“EmpID”" type="“xs:int”/">
br mode="hold" />
2. In Sql, we can define variable length. But in xsd, there is no limit length. Is it all right?
Eg,
In sql,
EmpName varchar(20) Not Null
In xsd,
<xs:element name="”EmpName”" type="“xs:string”/">
3. How I can describe Derived attribute in XSD? Can I use DefaultValue?
Eg,
In sql,
Create Table Furniture(
FurnitureID smallint,
LowSize int,
HighSize int,
AvgSize As (LowSize + HighSize)/2
)
In xsd,
<xs:element name="“FurnitureID”" type="“xs:short”/">
<xs:element name="“LowSize”" type="“xs:int”/">
<xs:element name="“HighSize”" type="“xs:int”/">
<xs:element name="“AvgSize”" type="“xs:int”" msdata:defaultvalue="“(LowSize+HighSize)/2”/">
4. And also Default Constraint like below?
Eg,
State varchar(10) constraint DF_State Default ‘YK’
<xs:element name="“State”" type="”xs:string”" default="“YK”/">
Good Luck!
soclose
(oops xsd keyword are missed! why? )
modified on Monday, March 17, 2008 9:19 AM
|
|
|
|
|
Hi,
I'm wondering if anybody could help me with the following?
I have this XML:
<?xml version="1.0" encoding="utf-8"?>
<dataset xmlns="http://developer.cognos.com/schemas/xmldata/1/" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance">
<!--
<dataset
xmlns="http://developer.cognos.com/schemas/xmldata/1/"
xmlns:xs="http://www.w3.org/2001/XMLSchema-instance"
xs:schemaLocation="http://developer.cognos.com/schemas/xmldata/1/ xmldata.xsd"
>
-->
<metadata>
<item name="Product type" type="xs:string" length="102"/>
<item name="Quantity" type="xs:int" precision="1"/>
</metadata>
<data>
<row>
<value>Binoculars</value>
<value>1075087</value>
</row>
<row>
<value>Climbing Accessories</value>
<value>5850251</value>
</row>
<row>
<value>Cooking Gear</value>
<value>13400351</value>
</row>
</data>
</dataset>
which I want to transform to the following using XSL (the number of row nodes is not fixed):
<?xml version="1.0" encoding="utf-8"?>
<data>
<row
ProductType="Binoculars"
Quantity="1075087"
/>
<row
ProductType="Climbing Accessories"
Quantity="5850251"
/>
<row
ProductType="Cooking Gear"
Quantity="13400351"
/>
</data>
Please notice that the metadata node (in the source XML) contains the names to be used in the resulting XML file as attribute names and that the name can contain one or more spaces (as indicated below in the name "Product yype").
<metadata>
<item name="Product type" type="xs:string" length="102"/>
<item name="Quantity" type="xs:int" precision="1"/>
</metadata>
Thank you very much in advance... 
|
|
|
|
|
Hi! I want to know how is it possible to make a restriction the data to be just two letters, like the ISO code for the nation: UK, NL, FR??
Thanks ahead
|
|
|
|
|
yes, using regex-patterns:
<xsd:restriction base="xsd:string">
<xsd:pattern value="[A-Z]{2}"/>
</xsd:restriction>
|
|
|
|
|
|
Hi guys,
In C#, i have a
XmlNodeList nodelist1;
and another one (with different nodes form the same XmlDocument)
XmlNodelist nodelist2;
I want to combine these into 1 large XmlNodelist.
I tried the operators &= and +=, but neither works.
Can this be done
Life is what happens while you make other plans.
|
|
|
|
|
Not quite sure what your overall goal is but use the XML DOM API's to move nodes around or copy them etc.
XmlNode.CloneNode<br />
XmlNode.RemoveChild<br />
XmlNode.AppendNode
led mike
|
|
|
|
|
now i've a problem with the xml file....coz the main form from xml file is can open..but i want to show into gribview of the another form....but there's no way to do for me...
plz help me....i've already use this method (**)...when i use that method, there's no bind() function.... so im so
(**)
DataSet xml = new DataSet();
xml.ReadXml(ChooseFolder.filepath);
DataTable file = xml.Tables["file"];
gvXml.DataSource = file;
gvXml.(??????????)
ChooseFolder is the name of main form and filepath is file name;
|
|
|
|
|
Don't cross post, it's an abuse of the forum resources.
led mike
|
|
|
|
|
question as title.
thanks guys for helping
|
|
|
|
|
What do you mean reserve char? An entity?
Deserialize it to what?
Are you getting an error message? If so post it and the relevant code.
led mike
|
|
|
|
|
Hi there,
i create an Excel XML File with c#.
It works fine, but there is one problem left, that i cannot solve:
I can put strings with multiple lines in one single cell, but the autoheight funcion does not work!
I set it in the row-Tag (ss:AutoFitHeight="1"), but when a open the excel file, the cell has always the same height - if there is only a single line string in the cell or a multiline string.
Could you help me?
Bodo
|
|
|
|
|
Hi all,
i found the solution, i wrote the ss:Wrap="1" attribute into the align-Tag instead of the Style tag.
Sometimes, I'm blind
|
|
|
|
|
i am a new guy to learn xslt, i follow the example of book to do one example but i also fail,pleae help solve it out. the code as the following:
<xml version="1.0" encoding="utf-8" ?="">
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:mydiscount="urn:discount">
<![CDATA[
public string Revalue()
{
return "a";
}
]]>;
;
......
<xsl:value-of select="myDiscount:Revalue">
....
when i try to use this function, i got error about Invalid class string
please help me.
thank you.
bing
|
|
|
|
|
How can i protect a xml file with password in a VB.Net project?
|
|
|
|
|
See if this helps.[^]
In case you are interested I know nothing about VB or VB.NET, I found this by searching with Google.
led mike
|
|
|
|
|
iam creating a reporting webpage. we have several types of reports like sales , customer ,....... if the user selects sales it will redirects to a separate page where they need to enter different parameters using the dropdown,textbox or listbox. for example they have different parameters like product,month,year,location. the user can enter any combinations. like either they select product and location or month and year like any combinations. once they submit the webpage , we have to pass those parameters to the XML and then query the database according to that. hope you've understood my explanation. so for this i just want to know how to send the parameters to the XML and then query the database. Please help me out
|
|
|
|
|
|
|
What does 'can't read data' mean ? What happens ? What does your XML look like ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
How is it intelligent to post a question, and to respond when someone tries to get enough info out of you that they can help, by deleting your message ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
.NET 1.1
Working with the XmlValidatingReader object with an xsd in the XmlSchemCollection to validate a serialized version of a class.
I am getting this XmlSchemaException when I read through the stream to validate my XML.
"The 'TransactionMethod' element is not declared. An error occurred at , (22, 4)."
I am not an XSD expert and would like to get some feedback as to what may be the cause/solution of/for this exception. Included is an XSD that was generated from the actual class as well as the xml I am trying to validate.
---- XSD ----
<br />
<?xml version="1.0" encoding="utf-8"?><br />
<xs:schema targetNamespace="urn:creditcardpaymentrequest-schema" xmlns="urn:creditcardpaymentrequest-schema" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"><br />
<xs:element name="CreditCardPaymentRequest" nillable="true" type="CreditCardPaymentRequest" /><br />
<xs:complexType name="CreditCardPaymentRequest"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="EPayPaymentRequest"><br />
<xs:sequence><br />
<xs:element minOccurs="0" maxOccurs="1" name="CreditCard" type="CreditCard" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="AuthorizationOnly" type="xs:boolean" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:complexType name="EPayPaymentRequest" abstract="true"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="EPayTransactionRequest"><br />
<xs:sequence><br />
<xs:element minOccurs="1" maxOccurs="1" name="IgnoreDuplicates" type="xs:boolean" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="RecurringIndicator" type="xs:boolean" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:complexType name="EPayTransactionRequest" abstract="true"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="BaseEntity"><br />
<xs:sequence><br />
<xs:element minOccurs="1" maxOccurs="1" name="CustomerId" type="xs:int" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="CustomerNumber" type="xs:string" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="TransactionId" type="xs:int" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="TransactionType" type="TransactionType" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="TransactionMethod" type="TransactionMethod" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="TransactionOrigin" type="TransactionOrigin" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="TransactionAmount" type="xs:decimal" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="ConvenienceFee" type="xs:decimal" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="ServiceOrderFee" type="xs:decimal" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="TotalAmount" type="xs:decimal" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="WaiveMinimumAmount" type="xs:boolean" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="WaiveConvenienceFee" type="xs:boolean" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="WaiveServiceOrderFee" type="xs:boolean" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="ContactName" type="xs:string" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="ContactNumber" type="xs:string" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="Note" type="xs:string" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:complexType name="BaseEntity" abstract="true"><br />
<xs:sequence><br />
<xs:element minOccurs="1" maxOccurs="1" name="DataStatus" type="EntityDataStatus" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="OldChangedValues" type="ArrayOfKeyValue" /><br />
</xs:sequence><br />
</xs:complexType><br />
<xs:simpleType name="EntityDataStatus"><br />
<xs:restriction base="xs:string"><br />
<xs:enumeration value="NewItem" /><br />
<xs:enumeration value="NewModified" /><br />
<xs:enumeration value="Modified" /><br />
<xs:enumeration value="NotModified" /><br />
<xs:enumeration value="Deleted" /><br />
</xs:restriction><br />
</xs:simpleType><br />
<xs:complexType name="ArrayOfKeyValue"><br />
<xs:sequence><br />
<xs:element minOccurs="0" maxOccurs="unbounded" name="KeyValue" nillable="true" type="KeyValue" /><br />
</xs:sequence><br />
</xs:complexType><br />
<xs:complexType name="KeyValue"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="BaseEntity"><br />
<xs:sequence><br />
<xs:element minOccurs="0" maxOccurs="1" name="Key" type="xs:string" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="Value" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:complexType id="TransactionMethod" name="TransactionMethod" abstract="true"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="BaseEntity"><br />
<xs:sequence><br />
<xs:element minOccurs="1" maxOccurs="1" name="CustomerId" type="xs:int" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="AccountId" type="xs:int" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="AccountNumber" type="xs:string" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="AccountLastFour" type="xs:string" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="NameOnAccount" type="xs:string" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="RecurringIndicator" type="xs:boolean" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="RecurringDocumentReceivedDate" type="xs:dateTime" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="RecurringStartDate" type="xs:dateTime" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="RecurringEndDate" type="xs:dateTime" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="ArEPayStatusId" type="xs:int" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="UpdateDate" type="xs:dateTime" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:complexType name="CreditCard"><br />
<xs:complexContent mixed="false"><br />
<xs:extension base="TransactionMethod"><br />
<xs:sequence><br />
<xs:element minOccurs="1" maxOccurs="1" name="CardType" type="CreditCardType" /><br />
<xs:element minOccurs="1" maxOccurs="1" name="ExpirationDate" type="xs:dateTime" /><br />
<xs:element minOccurs="0" maxOccurs="1" name="BillingZipCode" type="xs:string" /><br />
</xs:sequence><br />
</xs:extension><br />
</xs:complexContent><br />
</xs:complexType><br />
<xs:simpleType name="CreditCardType"><br />
<xs:restriction base="xs:string"><br />
<xs:enumeration value="Visa" /><br />
<xs:enumeration value="MasterCard" /><br />
<xs:enumeration value="Discover" /><br />
</xs:restriction><br />
</xs:simpleType><br />
<xs:simpleType name="TransactionType"><br />
<xs:restriction base="xs:string"><br />
<xs:enumeration value="Payment" /><br />
<xs:enumeration value="PaymentForReconnect" /><br />
<xs:enumeration value="PaymentForRestore" /><br />
<xs:enumeration value="Refund" /><br />
</xs:restriction><br />
</xs:simpleType><br />
<xs:simpleType name="TransactionOrigin"><br />
<xs:restriction base="xs:string"><br />
<xs:enumeration value="Collections" /><br />
<xs:enumeration value="BillStub" /><br />
<xs:enumeration value="WalkIn" /><br />
<xs:enumeration value="Recurring" /><br />
<xs:enumeration value="AdvancePayment" /><br />
</xs:restriction><br />
</xs:simpleType><br />
</xs:schema><br />
--- XML TO VALIDATE ---
<br />
<?xml version="1.0" encoding="utf-8"?><br />
<CreditCardPaymentRequest xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><br />
<DataStatus>NewModified</DataStatus><br />
<OldChangedValues /><br />
<CustomerId>11270</CustomerId><br />
<CustomerNumber>119931004</CustomerNumber><br />
<TransactionId>0</TransactionId><br />
<TransactionType>Payment</TransactionType><br />
<TransactionOrigin>BillStub</TransactionOrigin><br />
<TransactionAmount>31</TransactionAmount> <br />
<ConvenienceFee>0</ConvenienceFee><br />
<ServiceOrderFee>0</ServiceOrderFee><br />
<TotalAmount>31</TotalAmount><br />
<WaiveMinimumAmount>false</WaiveMinimumAmount><br />
<WaiveConvenienceFee>false</WaiveConvenienceFee><br />
<WaiveServiceOrderFee>false</WaiveServiceOrderFee><br />
<ContactName>STEVE SMITH</ContactName><br />
<ContactNumber>9034547688</ContactNumber><br />
<IgnoreDuplicates>false</IgnoreDuplicates><br />
<RecurringIndicator>false</RecurringIndicator><br />
<AuthorizationOnly>false</AuthorizationOnly><br />
<TransactionMethod xsi:type="TransactionMethod"><br />
<DataStatus>NewModified</DataStatus><br />
<OldChangedValues /><br />
<CustomerId>11270</CustomerId><br />
<AccountId>0</AccountId><br />
<AccountNumber>5454545454545454</AccountNumber><br />
<AccountLastFour>5454</AccountLastFour><br />
<NameOnAccount>Test User</NameOnAccount><br />
<RecurringIndicator>false</RecurringIndicator><br />
<RecurringDocumentReceivedDate>0001-01-01T00:00:00.0000000-06:00</RecurringDocumentReceivedDate><br />
<RecurringStartDate>0001-01-01T00:00:00.0000000-06:00</RecurringStartDate><br />
<RecurringEndDate>0001-01-01T00:00:00.0000000-06:00</RecurringEndDate><br />
<ArEPayStatusId>0</ArEPayStatusId><br />
<UpdateDate>0001-01-01T00:00:00.0000000-06:00</UpdateDate><br />
<CardType>MasterCard</CardType><br />
<ExpirationDate>2010-10-10T00:00:00.0000000-05:00</ExpirationDate><br />
<BillingZipCode>77777</BillingZipCode><br />
</TransactionMethod> <br />
<CreditCard xsi:type="CreditCard"><br />
<DataStatus>NewModified</DataStatus><br />
<OldChangedValues /><br />
<CustomerId>11270</CustomerId><br />
<AccountId>0</AccountId><br />
<AccountNumber>5454545454545454</AccountNumber><br />
<AccountLastFour>5454</AccountLastFour><br />
<NameOnAccount>Test User</NameOnAccount><br />
<RecurringIndicator>false</RecurringIndicator><br />
<RecurringDocumentReceivedDate>0001-01-01T00:00:00.0000000-06:00</RecurringDocumentReceivedDate><br />
<RecurringStartDate>0001-01-01T00:00:00.0000000-06:00</RecurringStartDate><br />
<RecurringEndDate>0001-01-01T00:00:00.0000000-06:00</RecurringEndDate><br />
<ArEPayStatusId>0</ArEPayStatusId><br />
<UpdateDate>0001-01-01T00:00:00.0000000-06:00</UpdateDate><br />
<CardType>MasterCard</CardType><br />
<ExpirationDate>2010-10-10T00:00:00.0000000-05:00</ExpirationDate><br />
<BillingZipCode>77777</BillingZipCode><br />
</CreditCard> <br />
</CreditCardPaymentRequest><br />
thanks!
|
|
|
|
|
hi friends...
i am reading xml file but i am not able to write it in .txt file.
so please help me how to do it. and i am using c#.net
i want read xml file and generate xyz.txt file
thanks
manohar
manohar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
