|
Hi,
I was wondering if anyone could tell me if it is possible to write a xml program that would upload documents via HTTPS to a server. Is this possible?. If so please can someone explain how i would have to do this.
Thanks
Thanks
J
|
|
|
|
|
|
Hi,
I see that Loading and Iterating huge XML file using DOM is slow on Win2003SP1. Any idea why ? Is there any solution ?
I am using MSXML3.dll ver 8.10.8308.0 .I modified sample Books.xml to add 2000 more nodes. I wrote simple App in VC++ 6.0 to load books.xml and iterated through all the elements. I executed this on both Win2000-Sp4 and Win2003-Sp1. I see that on Win2003Sp1 its takes more time compared to Windows 2000 Sp4. Please comment on this.
Thanks
Sandeep Naik
|
|
|
|
|
Hi,
I am trying to load the following XML through MSXML4 APIs. But it does not load. It says "Reference to undeclared namespace prefix 'ns0'".
The code is:
CComBSTR bstrXML = "<ns0:name>Arun</ns0:name>";<br />
MSXML2::IXMLDOMDocumentPtr pDoc(__uuidof(MSXML2::DOMDocument30));<br />
VARIANT_BOOL b1 = pDoc->loadXML(bstrXML.m_str);
Could anyone tell me how to resolve this ?
Thanks in advance,
Arun.
|
|
|
|
|
I couldn't replicate it but i'd try:
- Change DOMDocument30 to DOMDocument40 if you don't have a good reason to not to do it.
- Have you added using namespace MSXML2;
Marc Soleda.
... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|