XML / XSL

FirstPrevNext

word document and XML delnaz26-Jul-05 0:32 delnaz 26-Jul-05 0:32  I have a word document that i can show it in HTML form , but i wana to show all details on my word document such as PARAGRAPH , TITR , SPACES , how can i do this ? i test SAVE AS XML , but i think it must be eisier way to show these details , HELP ME BY SAMPLE i think i dont explain it well , i know i can see it with View menu , but i wana process this word document , so i must first process it , i can do it also , after processing , some sentence of this text change to some links , and some of them not !!! , THEN AFTER THESE PROCESS I WANA SHOW IT IN ASP FORM , but with paragraph , titrs , headers , footer !! how can i do this ??? thanks for helping me in this confused case !!!! Have good day and time convert xml file to access db in vb.net A.N24-Jul-05 14:43 A.N 24-Jul-05 14:43  AWAIS_YAR@YAHOO.COM AWAis_yar@hotmail.com Hi all I am preparing a xml to access db project in vb.net. which does the following 1) open dynamic access file in vb.net [done it] 2) create its xml file[done it] 3) again transform this xml file to mdb database file through vb.net[creating problem] I have tried many options but here is the xml file[which i am trying to update in MS Access Database through VB.NET] <newdataset> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:isdataset="true"> <xs:complextype> <xs:choice maxoccurs="unbounded"> <xs:element name="Employees"> <xs:complextype> <xs:sequence> <xs:element name="EmployeeId" type="xs:short" minoccurs="0"> <xs:element name="EmployeeName" type="xs:string" minoccurs="0"> <xs:element name="Address" type="xs:string" minoccurs="0"> <xs:element name="City" type="xs:string" minoccurs="0"> <employees> <employeeid>1 <employeename>awais 393 gg phase 4 <city>lahore <employees> <employeeid>2 <employeename>junaid 205 d phase 2 <city>lahore <employees> <employeeid>3 <employeename>ali 345 <city>lahore <employees> <employeeid>4 <employeename>mmm 999 <city>lahore what i am doing is load mdb file through this code[get dynamically its tables and columns] Imports Sdo = System.Data.OleDb Imports System.Data.OleDb Imports System.Xml Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click OpnFlDlg1.ShowDialog() Try If Len(OpnFlDlg1.FileName) > 0 Then Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & OpnFlDlg1.FileName & "" Cn.Open() btnImport.Enabled = True Dim schemaTable As Data.DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For Each row As DataRow In schemaTable.Rows Dim TableName As String = row("TABLE_NAME").ToString Dim DA As OleDbDataAdapter = New OleDbDataAdapter("Select * From [" + TableName + "]", Cn) DS.Tables.Add(TableName) DA.FillSchema(DS, SchemaType.Source, TableName) Next For Each dt In DS.Tables CmbTables.Items.Add(dt.TableName) Me.CmbTables.SelectedIndex = 0 Next End If Catch ex As Exception MsgBox("Error Connecting/Schema Loading : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub Private Sub xml_2_Db_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing If MsgBox("Are You Sure To Quit Application", MsgBoxStyle.Information + MsgBoxStyle.YesNo, "Information About Quitting Application") = MsgBoxResult.Yes Then e.Cancel = False Else e.Cancel = True End If Try Cn.Close() Cm.Connection.Close() dsAccess = Nothing Cn = Nothing Cm = Nothing Catch ex As Exception MsgBox("Error Closing" & ex.Message, MsgBoxStyle.Information, "Error Closing") End Try End Sub problem lies in this Import Button click methid when i am importing file to mdb Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Try Cm.Connection = Cn Cm.CommandText = "delete from " & CmbTables.SelectedItem & "" Cm.CommandType = CommandType.Text Cm.ExecuteNonQuery() dsAccess.Clear() Dim daxml As New Sdo.OleDbDataAdapter("select * from " & CmbTables.SelectedItem & "", Cn) 'FILLING VALUES FROM XML FILE TO DATAGRID dsAccess.ReadXml("c:\" & CmbTables.SelectedItem & ".xml", XmlReadMode.ReadSchema) daxml.Fill(dsAccess, "" & CmbTables.SelectedItem & "") DataGrid1.DataSource = dsAccess.DefaultViewManager 'FILLING VALUES FROM XML FILE TO EXCEL FILE Try Dim stream As FileStream = File.Open("C:\" & CmbTables.SelectedItem & ".xml", FileMode.Open) Dim output As FileStream = File.Create("output3.txt") Dim writer As StreamWriter = New StreamWriter(output) Dim dataset As DataSet = New DataSet Dim xx As Integer Dim StrQuery As String Dim xLoopCount As Int16 dataset.ReadXml(stream) For Each dc As Data.DataColumn In dt.Columns xLoopCount += 1 'MAKE STRING FROM COLUMN NAMES FOR INSERT QUERY 'writer.WriteLine("ID: {0}", row("ID")) 'writer.WriteLine("Text: {0}", row("Text")) 'writer.WriteLine("VarChar: {0}", row("VarChar")) 'writer.WriteLine("Data: {0}", row("Data")) 'If dc.DataType.ToString = "System.INT32" Or dc.DataType.ToString = "System.Int16" Or dc.DataType.ToString = "System.DateTime" Or dc.DataType.ToString = "System.Decimal" Or dc.DataType.ToString = "System.Float" Then ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")," ' Else ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")" ' End If ' MsgBox(dc.DataType.ToString) 'ElseIf dc.DataType.ToString = "System.String" Then ' MsgBox(dc.DataType.ToString) ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") ," ' Else ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") " ' End If 'End If Next MsgBox(StrQuery) 'writing each table/column in database Dim ss As Int16 = 0 'For Each table As Data.DataTable In dsAccess.Tables 'SELECT TABLE FROM SELECTED COMBO BOX & INSERT QUERY FROM ABOVE AND DATA FROM FILETEXT OR EXCEL For Each table As Data.DataTable In dataset.Tables For Each row As DataRow In table.Rows writer.Write("{0}*", row("TrnId")) writer.Write("{0}*", row("TrnDate")) writer.Write("{0}*", row("EmployeeId")) writer.Write("{0}#", row("Salary")) Next Next 'ss += 1 'Cm.Connection = Cn 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & StrQuery & ")" 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & ss & ",'2006-03-02','53','32.33')" 'MsgBox(Cm.CommandText) 'Cm.CommandType = CommandType.Text 'Cm.ExecuteNonQuery() stream.Close() writer.Close() output.Close() MsgBox("complete") Exit Sub Catch ex As Exception MsgBox(ex.ToString) End Try MsgBox("success Xml Written to Db") Catch ex As Exception MsgBox("Error Updating : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub also this method is not getting column names in combo box onItem Change Method Private Sub CmbTables_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmbTables.SelectedIndexChanged CmbColumns.Items.Clear() CountCol = 0 For Each dc As Data.DataColumn In dt.Columns CmbColumns.Items.Add(dc.ColumnName) CmbColumns.SelectedIndex = 0 CountCol += 1 Next End Sub plz help ...............URGENT..... REGARDS A.W " rel="nofollow">http://www.kdkeys.net/msgs/default.aspx?MessageID=48 Hi John I am preparing for MCAD Papers . and have assignment to get 1) open dynamic access file in vb.net [done it] 2) create its xml file[done it] 3) again transform this xml file to mdb database file through vb.net[creating problem] I have tried many options but here is the xml file[which i am trying to update in MS Access Database through VB.NET] <newdataset> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:isdataset="true"> <xs:complextype> <xs:choice maxoccurs="unbounded"> <xs:element name="Employees"> <xs:complextype> <xs:sequence> <xs:element name="EmployeeId" type="xs:short" minoccurs="0"> <xs:element name="EmployeeName" type="xs:string" minoccurs="0"> <xs:element name="Address" type="xs:string" minoccurs="0"> <xs:element name="City" type="xs:string" minoccurs="0"> <employees> <employeeid>1 <employeename>awais 393 gg phase 4 <city>lahore <employees> <employeeid>2 <employeename>junaid 205 d phase 2 <city>lahore <employees> <employeeid>3 <employeename>ali 345 <city>lahore <employees> <employeeid>4 <employeename>mmm 999 <city>lahore what i am doing is load mdb file through this code[get dynamically its tables and columns] Imports Sdo = System.Data.OleDb Imports System.Data.OleDb Imports System.Xml Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click OpnFlDlg1.ShowDialog() Try If Len(OpnFlDlg1.FileName) > 0 Then Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & OpnFlDlg1.FileName & "" Cn.Open() btnImport.Enabled = True Dim schemaTable As Data.DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For Each row As DataRow In schemaTable.Rows Dim TableName As String = row("TABLE_NAME").ToString Dim DA As OleDbDataAdapter = New OleDbDataAdapter("Select * From [" + TableName + "]", Cn) DS.Tables.Add(TableName) DA.FillSchema(DS, SchemaType.Source, TableName) Next For Each dt In DS.Tables CmbTables.Items.Add(dt.TableName) Me.CmbTables.SelectedIndex = 0 Next End If Catch ex As Exception MsgBox("Error Connecting/Schema Loading : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub Private Sub xml_2_Db_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing If MsgBox("Are You Sure To Quit Application", MsgBoxStyle.Information + MsgBoxStyle.YesNo, "Information About Quitting Application") = MsgBoxResult.Yes Then e.Cancel = False Else e.Cancel = True End If Try Cn.Close() Cm.Connection.Close() dsAccess = Nothing Cn = Nothing Cm = Nothing Catch ex As Exception MsgBox("Error Closing" & ex.Message, MsgBoxStyle.Information, "Error Closing") End Try End Sub problem lies in this Import Button click methid when i am importing file to mdb Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Try Cm.Connection = Cn Cm.CommandText = "delete from " & CmbTables.SelectedItem & "" Cm.CommandType = CommandType.Text Cm.ExecuteNonQuery() dsAccess.Clear() Dim daxml As New Sdo.OleDbDataAdapter("select * from " & CmbTables.SelectedItem & "", Cn) 'FILLING VALUES FROM XML FILE TO DATAGRID dsAccess.ReadXml("c:\" & CmbTables.SelectedItem & ".xml", XmlReadMode.ReadSchema) daxml.Fill(dsAccess, "" & CmbTables.SelectedItem & "") DataGrid1.DataSource = dsAccess.DefaultViewManager 'FILLING VALUES FROM XML FILE TO EXCEL FILE Try Dim stream As FileStream = File.Open("C:\" & CmbTables.SelectedItem & ".xml", FileMode.Open) Dim output As FileStream = File.Create("output3.txt") Dim writer As StreamWriter = New StreamWriter(output) Dim dataset As DataSet = New DataSet Dim xx As Integer Dim StrQuery As String Dim xLoopCount As Int16 dataset.ReadXml(stream) For Each dc As Data.DataColumn In dt.Columns xLoopCount += 1 'MAKE STRING FROM COLUMN NAMES FOR INSERT QUERY 'writer.WriteLine("ID: {0}", row("ID")) 'writer.WriteLine("Text: {0}", row("Text")) 'writer.WriteLine("VarChar: {0}", row("VarChar")) 'writer.WriteLine("Data: {0}", row("Data")) 'If dc.DataType.ToString = "System.INT32" Or dc.DataType.ToString = "System.Int16" Or dc.DataType.ToString = "System.DateTime" Or dc.DataType.ToString = "System.Decimal" Or dc.DataType.ToString = "System.Float" Then ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")," ' Else ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")" ' End If ' MsgBox(dc.DataType.ToString) 'ElseIf dc.DataType.ToString = "System.String" Then ' MsgBox(dc.DataType.ToString) ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") ," ' Else ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") " ' End If 'End If Next MsgBox(StrQuery) 'writing each table/column in database Dim ss As Int16 = 0 'For Each table As Data.DataTable In dsAccess.Tables 'SELECT TABLE FROM SELECTED COMBO BOX & INSERT QUERY FROM ABOVE AND DATA FROM FILETEXT OR EXCEL For Each table As Data.DataTable In dataset.Tables For Each row As DataRow In table.Rows writer.Write("{0}*", row("TrnId")) writer.Write("{0}*", row("TrnDate")) writer.Write("{0}*", row("EmployeeId")) writer.Write("{0}#", row("Salary")) Next Next 'ss += 1 'Cm.Connection = Cn 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & StrQuery & ")" 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & ss & ",'2006-03-02','53','32.33')" 'MsgBox(Cm.CommandText) 'Cm.CommandType = CommandType.Text 'Cm.ExecuteNonQuery() stream.Close() writer.Close() output.Close() MsgBox("complete") Exit Sub Catch ex As Exception MsgBox(ex.ToString) End Try MsgBox("success Xml Written to Db") Catch ex As Exception MsgBox("Error Updating : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub also this method is not getting column names in combo box onItem Change Method Private Sub CmbTables_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmbTables.SelectedIndexChanged CmbColumns.Items.Clear() CountCol = 0 For Each dc As Data.DataColumn In dt.Columns CmbColumns.Items.Add(dc.ColumnName) CmbColumns.SelectedIndex = 0 CountCol += 1 Next End Sub plz help ...............URGENT..... REGARDS A.W [ <newdataset> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:isdataset="true"> <xs:complextype> <xs:choice maxoccurs="unbounded"> <xs:element name="Employees"> <xs:complextype> <xs:sequence> <xs:element name="EmployeeId" type="xs:short" minoccurs="0"> <xs:element name="EmployeeName" type="xs:string" minoccurs="0"> <xs:element name="Address" type="xs:string" minoccurs="0"> <xs:element name="City" type="xs:string" minoccurs="0"> <employees> <employeeid>1 <employeename>awais 393 gg phase 4 <city>lahore <employees> <employeeid>2 <employeename>junaid 205 d phase 2 <city>lahore <employees> <employeeid>3 <employeename>ali 345 <city>lahore <employees> <employeeid>4 <employeename>mmm 999 <city>lahore what i am doing is load mdb file through this code[get dynamically its tables and columns] Imports Sdo = System.Data.OleDb Imports System.Data.OleDb Imports System.Xml Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click OpnFlDlg1.ShowDialog() Try If Len(OpnFlDlg1.FileName) > 0 Then Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & OpnFlDlg1.FileName & "" Cn.Open() btnImport.Enabled = True Dim schemaTable As Data.DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For Each row As DataRow In schemaTable.Rows Dim TableName As String = row("TABLE_NAME").ToString Dim DA As OleDbDataAdapter = New OleDbDataAdapter("Select * From [" + TableName + "]", Cn) DS.Tables.Add(TableName) DA.FillSchema(DS, SchemaType.Source, TableName) Next For Each dt In DS.Tables CmbTables.Items.Add(dt.TableName) Me.CmbTables.SelectedIndex = 0 Next End If Catch ex As Exception MsgBox("Error Connecting/Schema Loading : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub Private Sub xml_2_Db_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing If MsgBox("Are You Sure To Quit Application", MsgBoxStyle.Information + MsgBoxStyle.YesNo, "Information About Quitting Application") = MsgBoxResult.Yes Then e.Cancel = False Else e.Cancel = True End If Try Cn.Close() Cm.Connection.Close() dsAccess = Nothing Cn = Nothing Cm = Nothing Catch ex As Exception MsgBox("Error Closing" & ex.Message, MsgBoxStyle.Information, "Error Closing") End Try End Sub problem lies in this Import Button click methid when i am importing file to mdb Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Try Cm.Connection = Cn Cm.CommandText = "delete from " & CmbTables.SelectedItem & "" Cm.CommandType = CommandType.Text Cm.ExecuteNonQuery() dsAccess.Clear() Dim daxml As New Sdo.OleDbDataAdapter("select * from " & CmbTables.SelectedItem & "", Cn) 'FILLING VALUES FROM XML FILE TO DATAGRID dsAccess.ReadXml("c:\" & CmbTables.SelectedItem & ".xml", XmlReadMode.ReadSchema) daxml.Fill(dsAccess, "" & CmbTables.SelectedItem & "") DataGrid1.DataSource = dsAccess.DefaultViewManager 'FILLING VALUES FROM XML FILE TO EXCEL FILE Try Dim stream As FileStream = File.Open("C:\" & CmbTables.SelectedItem & ".xml", FileMode.Open) Dim output As FileStream = File.Create("output3.txt") Dim writer As StreamWriter = New StreamWriter(output) Dim dataset As DataSet = New DataSet Dim xx As Integer Dim StrQuery As String Dim xLoopCount As Int16 dataset.ReadXml(stream) For Each dc As Data.DataColumn In dt.Columns xLoopCount += 1 'MAKE STRING FROM COLUMN NAMES FOR INSERT QUERY 'writer.WriteLine("ID: {0}", row("ID")) 'writer.WriteLine("Text: {0}", row("Text")) 'writer.WriteLine("VarChar: {0}", row("VarChar")) 'writer.WriteLine("Data: {0}", row("Data")) 'If dc.DataType.ToString = "System.INT32" Or dc.DataType.ToString = "System.Int16" Or dc.DataType.ToString = "System.DateTime" Or dc.DataType.ToString = "System.Decimal" Or dc.DataType.ToString = "System.Float" Then ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")," ' Else ' StrQuery += "row(" & "" & dc.ColumnName & "" & ")" ' End If ' MsgBox(dc.DataType.ToString) 'ElseIf dc.DataType.ToString = "System.String" Then ' MsgBox(dc.DataType.ToString) ' If xLoopCount <> CountCol Then ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") ," ' Else ' StrQuery += "row(" & "'" & dc.ColumnName & "'" & ") " ' End If 'End If Next MsgBox(StrQuery) 'writing each table/column in database Dim ss As Int16 = 0 'For Each table As Data.DataTable In dsAccess.Tables 'SELECT TABLE FROM SELECTED COMBO BOX & INSERT QUERY FROM ABOVE AND DATA FROM FILETEXT OR EXCEL For Each table As Data.DataTable In dataset.Tables For Each row As DataRow In table.Rows writer.Write("{0}*", row("TrnId")) writer.Write("{0}*", row("TrnDate")) writer.Write("{0}*", row("EmployeeId")) writer.Write("{0}#", row("Salary")) Next Next 'ss += 1 'Cm.Connection = Cn 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & StrQuery & ")" 'Cm.CommandText = "Insert Into " & CmbTables.SelectedItem & " values(" & ss & ",'2006-03-02','53','32.33')" 'MsgBox(Cm.CommandText) 'Cm.CommandType = CommandType.Text 'Cm.ExecuteNonQuery() stream.Close() writer.Close() output.Close() MsgBox("complete") Exit Sub Catch ex As Exception MsgBox(ex.ToString) End Try MsgBox("success Xml Written to Db") Catch ex As Exception MsgBox("Error Updating : " & ex.Message, MsgBoxStyle.Information, "Error") End Try End Sub also this method is not getting column names in combo box onItem Change Method Private Sub CmbTables_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmbTables.SelectedIndexChanged CmbColumns.Items.Clear() CountCol = 0 For Each dc As Data.DataColumn In dt.Columns CmbColumns.Items.Add(dc.ColumnName) CmbColumns.SelectedIndex = 0 CountCol += 1 Next End Sub plz help ...............URGENT..... REGARDS A.W " target="_blank" rel="nofollow" title="New Window">^] How read the SOAP elements satishrg20-Jul-05 5:28 satishrg 20-Jul-05 5:28  hi, I am trying to access the webservice by sending the SOAP request.That webservice actually allows only the valid user so it validates with the data base.I got the folloing message <soap:body> <soap:fault> <soap:faultcode xmlns="urn:verizon:security:soap:authorize:code">DENIED<s oap:faultstring>DENIED when I tried to pass an invalid user. If the user on my application enters the valid "id" and "password" which i will be sending to the webservice then I get the Xml which I will be parsing but if the user enters the invalid id or password then I get the error as above How do I take care of this. What I am thinking is when I get the SOAP I will parse the SOAP response with the XMLDOCUMENT as bellow XmlDocument xd=new XmlDocument(); xd.LoadXml(strOutputXML); XmlNodeList JobIDNodeList=xd.GetElementsByTagName("soap:Faultcode"); but is throwing an error. questions: 1)IS my Approach wrong 2)IF correct How can I get the data of Xml tag with attributes in it 3)Does this problem get solved if I use proxy class instead of directly parsing the SOAP,If so how. Thanking you in advace. Satish. [HELP] I got error message, when I tried to parse XML on PocketPC Member 208243219-Jul-05 23:05 Member 2082432 19-Jul-05 23:05  I writen a application on Microsoft Mobile5.0 Pocket PC. Parts of my code as below. I create my own ISAXXMLContentHandler implementation class, and it used to handle my XML file ("\ori.xml"). <IMG src="http://home.pchome.com.tw/funny/alger_lin/Codes/code1.JPG"> I initiate XML reader as below. <img src="http://home.pchome.com.tw/funny/alger_lin/Codes/code2.JPG"> And my XML content handler class's constructor and destructor as below. <img src="http://home.pchome.com.tw/funny/alger_lin/Codes/code3.JPG"> However, when I call XML reader's parseURL() function in first picture, I got an error message as below. <img src="http://home.pchome.com.tw/funny/alger_lin/Codes/err1.JPG"> The error message's detail as below. <img src="http://home.pchome.com.tw/funny/alger_lin/Codes/err2.JPG"> I don't know what happen? and I don't know how to solve it? Does anyone can help me to solve it? Alger, Lin Re: [HELP] I got error message, when I tried to parse XML on PocketPC Philip Fitzsimons20-Jul-05 5:25 Philip Fitzsimons 20-Jul-05 5:25  you need to show us the exception information - scroll err2.jpg down a bit... "When the only tool you have is a hammer, a sore thumb you will have." Re: [HELP] I got error message, when I tried to parse XML on PocketPC Member 208243220-Jul-05 15:42 Member 2082432 20-Jul-05 15:42  I got frames of error messages as below. http://home.pchome.com.tw/funny/alger_lin/Codes/err.JPG[^] Re: [HELP] I got error message, when I tried to parse XML on PocketPC Philip Fitzsimons20-Jul-05 23:17 Philip Fitzsimons 20-Jul-05 23:17  can you not copy the error text to the clipboard? we need the text from: Exception Information ===================== "When the only tool you have is a hammer, a sore thumb you will have." Re: [HELP] I got error message, when I tried to parse XML on PocketPC Member 208243221-Jul-05 14:50 Member 2082432 21-Jul-05 14:50  Thanks for your attention, I found the reason of this problem yesterday. It's not a technical issue, it just because I made a stupid mistake As the code below, I invoke InitReader() function to create and initiate my XML reader. I pass a pointer of ISAXXMLReader into this function, this variable is xReader_Ori. http://home.pchome.com.tw/funny/alger_lin/Codes/code1.JPG[^] And in the InitReader(), I pass the inputed ISAXXMLReader pointer into CoCreateInstance() to receive the instance of ISAXXMLReader. However, the xReader parameter is a copy of xReader_Ori, the xReader was represented the ISAXXMLReader's instance after invoke CoCreateInstance(), but the xReader_Ori was not be modified at the same time. So, it cause some error when I called xReader_Ori's parseURL() function, because it's nothing http://home.pchome.com.tw/funny/alger_lin/Codes/code2.JPG[^] Now, I modified my InitReader()'s definition, I define it as HRESULE InitReader(ISAXXMLReader*& xReader). And it work smoothly now xslt table iteration Jag_K19-Jul-05 22:20 Jag_K 19-Jul-05 22:20  Hi, i was wondering if anyone can help. i am looking to find out how i place data from a query into my table. However this is being done via xml and xslt. The data file arrives as xml. the xslt should then take the data and place it into a table. if there are 6 rows it should draw 6 rows only in the table etc. does anyone know how this can be done in xslt? and if so how?. Thanks Jagdish Thanks J Re: xslt table iteration Anonymous21-Jul-05 7:56 Anonymous 21-Jul-05 7:56  Give this a try: http://www.w3schools.com/xsl/xsl_for_each.asp[^] Help: XML transform with XSL Anonymous19-Jul-05 5:40 Anonymous 19-Jul-05 5:40  Hi all, I'm having a problem with my XSL converting to HTML. I can view all content fine, except the white space is not preserved! I thought whitespace was preserved by default? For example in my XML: <catalog> <content> lines and lines of text more text </content> </catalog> When transforming I get: lines and lines of text more text It's all bunched up...where did the newline characters go? my XSL contains this: <xsl:value-of select="content"/> Any ideas? Thanks. Re: Help: XML transform with XSL Christian Graus19-Jul-05 11:19 Christian Graus 19-Jul-05 11:19  xsl:preserve-space[^] is what you need. Christian Graus - Microsoft MVP - C++ Re: Help: XML transform with XSL Anonymous19-Jul-05 13:14 Anonymous 19-Jul-05 13:14  Thanks for the reply, but I have read that tutorial prior to posting here. I still have an issue with the whitespaces. Plus W3Schools mentions the following: Note: Preserving white space is the default setting, so using the <xsl:preserve-space> element is only necessary if the <xsl:strip-space> element is used. So, by default, I shouldn't have to use the xsl:preserve-space. Although, I have tried either way...and the same result occurred. White-space was not preserved Re: Help: XML transform with XSL Bluebamboo29-Jun-06 4:48 Bluebamboo 29-Jun-06 4:48  hi, did you resolve this problem, i have the same problem with you , if you've solved, plz tell me~ Webservice against DLL dabuskol18-Jul-05 20:42 dabuskol 18-Jul-05 20:42  Guys, Hope I am in the right forum. What is the difference between the webservice and DLL? Which one is fater? It seems that both of them are the same it depends on how you will use it. Just a clear explanation since I am new to WEBSERVICE. I am C# programmer. Re: Webservice against DLL DavidNohejl19-Jul-05 2:48 DavidNohejl 19-Jul-05 2:48  hi, dabuskol wrote: What is the difference between the webservice and DLL? Which one is fater? It seems that both of them are the same it depends on how you will use it. well, when you use webservice, you actually call some methods from dll that is somewhere on the web. Communication (transfer of arguments and return value) is done via SOAP - it is XML based format, so you are close to the right forum Dll on the other hand, is usualy on the same computer as caller. So obviously it is faster... but advantage of Web Service (WS) is that it is platform independent (all you need is to have implementation of SOAP) since communication is basicaly done via XML. And it is web service - it allows you to execute code on distant servers and get results from them. I hope I said it understandably. However, there is some study material: http://msdn.microsoft.com/webservices/[^] David My XmlFile looses its tree hierarchy after saving it rudy.net18-Jul-05 5:44 rudy.net 18-Jul-05 5:44  Hello, I read my xml file into a dataset and set the datasource of a datagrid to access one of the datatables. Problem is that when new rows are added to the datagrid, and I call the WriteXml method, the new rows are added at the root. Following is an example: <?xml version="1.0" standalone="yes"?> <root xmlns="http://tempuri.org/Database.xsd"> <Database> <Positions> <Position PositionCode="1" PositionName="Operations Supervisor" Salary="0" /> </Positions> </Database> </root> Then I set the DataSource to of a datagrid to "Position" table and after adding a couple of rows, the saved file looks like: <?xml version="1.0" standalone="yes"?> <root xmlns="http://tempuri.org/Database.xsd"> <Database> <Positions> <Position PositionCode="1" PositionName="Operations Supervisor" Salary="0" /> </Positions> </Database> <Position PositionCode="2" PositionName="Secretary" Salary="0"/> <Position PositionCode="3" PositionName="LazyGuy" Salary="0"/> </root> Note that the new rows were added in "/root" instead of in "root/Database/positions" file containing specification of default namespace Suman Singh18-Jul-05 4:31 Suman Singh 18-Jul-05 4:31  Hi all, I want to know the name of the file which contains the specification of default namespace(www.w3.org/2001/XMLSchema) in XML. Plz help.. Suman Singh execute xml 18-Jul-05 1:23 18-Jul-05 1:23  Hello, I have a xml file: <akis xmlns:sql="urn:schemas-microsoft-com:xml-sql"> <element><sql:query>SELECT @Element</sql:query></element> <rows><sql:query>EXEC sp_ForXML @Element,'XML'</sql:query></rows> </akis> and I need to get the results of that.Is there any way to get them not by running the stored procedure but from the xml itself? thaks in advance, akis Memory leak? LaxRoth17-Jul-05 21:29 LaxRoth 17-Jul-05 21:29  Hi, i'm trying to load an xml document from C++ with: MSXML::IXMLDOMDocumentPtr pXMLDocument (__uuidof (MSXML:OMDocument)); // main document parsed hr = pXMLDocument->loadXML (BSTRTemp); /* trying parse string, if success, we have doc object*/ this method uses offensive memory. i have xml files that are about 100MB size. i feel the function does not clear the memory. anyone an idea? if i load 3 times the same file, my memory is full. suggestion? is there a free method or something? thank you, lutz Re: Memory leak? Philip Fitzsimons20-Jul-05 5:23 Philip Fitzsimons 20-Jul-05 5:23  loading a 100mb xml file into the DOM model is going to hurt - you can expect it to take up 10 times the size on disk when its in memory.... so you could use the MSXML 3.0 Sax implementation instead... http://www.xml.com/pub/a/2002/03/06/efficient.html?page=last&x-order=date[^] "When the only tool you have is a hammer, a sore thumb you will have." Re: Memory leak? LaxRoth21-Jul-05 21:04 LaxRoth 21-Jul-05 21:04  hi, thx for your answers. after several tests i think i will have to do this. XML to Text with &quot;C#&quot; fcn][Stampede17-Jul-05 9:07 fcn][Stampede 17-Jul-05 9:07  Hi guys, I've tried some stuff with XML and XSLT in Java. I had to develop an application that would transform various standards (XML and text) into one overall standard (XML) and then into some other formats (again XML and text). I did it by using Xerces for the text->xml and xml->xml stuff, but it couldn't do the transformations from XML to text. I know want to do the same thing with "C#" and again I don't know how to transform xml to text. Does anyone know if it is possible with XSLT? And if yes, how can it be done? greetz Stampede PS: An example of the transformation I need to do would be the following: <myDoc> <firstNode>asdf1</firstNode> <secondNode>asdf2</secondNode> <thirdNode> <fourthNode>asdf3</fourthNode> </thirdNode> </myDoc> this would be transformed into something like the following: firstNode:'asdf1' secondNode:'asdf2' thirdNode#fourthNode:'asdf3' Of course this is only an example, but I think it shows what I want to do. Re: XML to Text with &quot;C#&quot; Gavin Jeffrey17-Jul-05 21:02 Gavin Jeffrey 17-Jul-05 21:02  It should be possible check out this tutorial http://www.w3schools.com/xsl/default.asp[^] change in schema file qadirchalla@yahoo.com17-Jul-05 1:50 qadirchalla@yahoo.com 17-Jul-05 1:50  Hi, We are making use of SourceGenerator of Castor to generate Java class file from a given schema file and based on the class files we are calling the set functions of the respective classes to populate the corresponding tags in the XML file. We use the marshall function to generate the XML. We might change the schema file in future, i.e. move some child tags in some different parent tags. for e.g. excerpt of a schema file. <empaddress> <street> Street1 <pincode> 111111 <companyaddress> <city> XYZ New schema file: <empaddress> <pincode> 111111 <companyaddress> <street> Street1 <city> XYZ As it is visible, that <street> tag is moved under <companyaddress> tag. This change triggers change in the names of get/set functions for the corresponding classes and thus generates error during marshalling. Could you please suggest some steps, wherein no code change is required apart from class generation, to accomodate this change in schema file. Thanks and Regards, Abdul Qadir Thanks and Regards, Abdul Qadir

Last Visit: 31-Dec-99 18:00     Last Update: 13-Jun-24 8:32 Refresh ᐊ Prev1...174175176177178179180181182183 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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