Click here to Skip to main content
16,006,709 members
Home / Discussions / XML / XSL
   

XML / XSL

 
GeneralPrinting Screen Pin
Member 168150415-Apr-05 0:28
Member 168150415-Apr-05 0:28 
GeneralRe: Printing Screen Pin
Javier Lozano15-Apr-05 18:54
Javier Lozano15-Apr-05 18:54 
QuestionHow to display all xml fields and values using ASP Pin
Boy7514-Apr-05 9:30
sussBoy7514-Apr-05 9:30 
AnswerRe: How to display all xml fields and values using ASP Pin
Hrashita Triapthi22-Apr-05 0:50
Hrashita Triapthi22-Apr-05 0:50 
GeneralXML generation using DTD in VC++ Pin
guru*p13-Apr-05 9:58
guru*p13-Apr-05 9:58 
GeneralWeb Service Consuming VB 60 Pin
Anonymous13-Apr-05 8:00
Anonymous13-Apr-05 8:00 
GeneralValidate XML file with DTD Pin
Nusrat.Khan13-Apr-05 5:36
Nusrat.Khan13-Apr-05 5:36 
GeneralConvert SQLServer dataset into XML using XSD Pin
SarunMK13-Apr-05 5:04
SarunMK13-Apr-05 5:04 
Hi,

Please help me out in solving the problem. I retrived the data from SQL Server 2000 using SQLXML. I have created an XSD. Now, I have to convert the dataset into XML based on the XSD. While doing so, I get the following error:

"MSXML: is an invalid or unsupported XPath "

I installed MSXML 4.0 SP2, still I couldn't find the solution.

test.xsd is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="Limit" sql:relation="SM_Limit_Type">
<xs:complexType>
<xs:sequence>
<xs:element name="LT_LimitType_Name" type="xs:string" sql:field="LT_LimitType_Name"/>
<xs:element name="LT_Country_ID" type="xs:int" sql:field="LT_Country_ID"/>
<xs:element name="LT_Active" type="xs:int" sql:field="LT_Active"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

On Page_Load, I give the following code...

SqlXmlCommand xmlCom = new SqlXmlCommand("Provider=SQLOLEDB;server=servername;user id=sa;pwd=;database=dbname");
Stream strm;
StreamReader strmRead;
XmlDocument xmlDoc=new XmlDocument();
string strXml;
xmlCom.CommandText="SELECT LT_LimitType_Name, LT_Country_ID, LT_Active FROM SM_Limit_Type WHERE LT_LimitType_ID = 2";
xmlCom.CommandType=SqlXmlCommandType.XPath;
xmlCom.SchemaPath=path+@"test.xsd";
xmlCom.RootTag="RootElement";
strm=xmlCom.ExecuteStream();
strmRead=new StreamReader(strm);
strXml=strmRead.ReadToEnd();
xmlDoc.LoadXml(strXml);

Please help me out in finding the solution. Thanks in advance...
Sarun


Please rate this page...
GeneralRe: Convert SQLServer dataset into XML using XSD Pin
Javier Lozano15-Apr-05 19:00
Javier Lozano15-Apr-05 19:00 
GeneralRe: Convert SQLServer dataset into XML using XSD Pin
SarunMK16-Apr-05 3:02
SarunMK16-Apr-05 3:02 
GeneralMultipart/Related XML Pin
Weiz817-Apr-05 16:34
Weiz817-Apr-05 16:34 
GeneralPopulating datagrid from typed dataset Pin
C_Simpkins7-Apr-05 11:29
C_Simpkins7-Apr-05 11:29 
QuestionHow do i use Xquery with asp 3.0 Pin
Wilbur J. Pereira6-Apr-05 20:24
Wilbur J. Pereira6-Apr-05 20:24 
GeneralXML Data Pin
Anonymous6-Apr-05 3:39
Anonymous6-Apr-05 3:39 
GeneralXML Pin
Anonymous6-Apr-05 3:34
Anonymous6-Apr-05 3:34 
GeneralXML with Crystal Report Pin
Anonymous6-Apr-05 3:23
Anonymous6-Apr-05 3:23 
GeneralXML Table Hint Pin
Anonymous6-Apr-05 3:19
Anonymous6-Apr-05 3:19 
GeneralXSLT Pin
Daredeviljpr4-Apr-05 4:15
Daredeviljpr4-Apr-05 4:15 
GeneralRe: XSLT Pin
Christian Graus4-Apr-05 10:30
protectorChristian Graus4-Apr-05 10:30 
GeneralRe: XSLT Pin
Daredeviljpr4-Apr-05 19:18
Daredeviljpr4-Apr-05 19:18 
GeneralRe: XSLT Pin
Stuart Dootson4-Apr-05 21:56
professionalStuart Dootson4-Apr-05 21:56 
GeneralRe: XSLT Pin
Daredeviljpr5-Apr-05 5:13
Daredeviljpr5-Apr-05 5:13 
GeneralRe: XSLT Pin
Daredeviljpr5-Apr-05 5:21
Daredeviljpr5-Apr-05 5:21 
GeneralRe: XSLT Pin
hp10811-May-05 4:20
hp10811-May-05 4:20 
GeneralQuestion Pin
reema13-Apr-05 21:27
reema13-Apr-05 21:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.