|
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">^]
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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."
|
|
|
|
|
|
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."
|
|
|
|
|
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 
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
|
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 
|
|
|
|
|
hi, did you resolve this problem, i have the same problem with you , if you've solved, plz tell me~
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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"
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
hi, thx for your answers. after several tests i think i will have to do this.
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
I have an xslt file that I use to transform an XML document to a html page. Can I use that same xslt file to change the html back to the original XML?
/\ |_ E X E GG
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
