Ben -- modified at Monday 22nd May, 2006To make it possible to pass a string with XSD content instead of a location I changed a single line of the code above: Original: validating Reader = new Xml Validating Reader(new Xml Text Reader(@"Sample.xml")); New: validating Reader = new Xml Validating Reader(new Xml Text Reader(new String Reader(xsd Input))); Besides a warning that this function is qualified as obsolete I get an error: “The target Namespace parameter '' should be the same value as the target Namespace 'urn:bookstore-schema' of the schema.” I’d like to validate a xml string against a xsd string.
I am not sure if it can be done any easy way in sql server 2000.
Add(Nothing, "D:\xxml\books.xsd") Dim event Handler As New Validation Event Handler(Address Of Validation Event Handler) tmp Doc. Validate(event Handler) You can check the code of errors in your new list variable. You will want to comment out this line: Msg Box("Error: " & Convert. Message)) or you will get a message box for each error. Anyway, if you can determine from the error message what is really wrong you can certainly write some code that checks the error message givin and then change it to something that users would understand.
I don't know any way of doing xml validation in vb 6.0. NOTE since this is a shared varible you need to be careful you don't try to validate two xml files at the same time. Ben Private Shared error List As List(Of String) = New List(Of String) Private Shared Sub Validation Event Handler(By Val sender As Object, By Val e As Validation Event Args) Select Case e. Here is a sample of some simple C# code that works in 2.0: private void Form1_Load(object sender, Event Args e) static void Validation Event Handler(object sender, Validation Event Args e) You just need to take the code out of the form load method and put it where ever you need it. Ben -- modified at Monday 22nd May, 2006No actually I don't.
If you had sql server 2005 or 2008 I think you could do what you wanted.
Write End Element() Exit Select End Select with he above code a is created but its not as per the format needed the nodes & elements needs to be more structured & looped how can it be done i need the first line of the xml to be 'ABC xmlns:xsi=" xsi:no Namespace Schema Location="ABC.xsd") i am not getting it Honestly sql sever 2000 doesn't do xml very well.
urn:bookstore-schema (just like described in post above). IO; public class Sample NOTE that when you add the schema to the schema set you can use a xmlreader.