AJUDA PARA LER UM XML

KERPLUNK 12/02/2014 16:29:16
#434661

Veja um exemplo simples do uso do xsd clicando aqui

KERPLUNK 13/02/2014 10:26:52
#434710

E então, conseguiu desenrolar aÃ?

ANGELOATA 13/02/2014 12:32:21
#434721

nada ainda, surgiu alguns entraves aqui no trabalho e to tendo que resolver, acho q ate amanha consigo mexer de novo

ANGELOATA 13/02/2014 12:40:38
#434723

consegui achar mais 2 topicos interessantes sobre o assunto

http://diegoalima.blogspot.com.br/2013/08/microsoft-net-gerando-classes-partir-de.html

http://www.danielgarcia.com.br/post/Como-Serializar-Objetos-em-XML-com-NET.aspx

ANGELOATA 13/02/2014 13:50:27
#434726

Certo fiz a serialização, coloquei o codigo na aplicação so que estou com mais uma duvida

no trecho

Dim ser As New XmlSerializer(GetType(Report))
Dim resultadoFinal As Report
Dim path As String = [Ã”]C:\program files\microsoft visual studio 10.0\vc\arq.xml[Ã”]
Using reader As XmlReader = XmlReader.Create(path)
resultadoFinal = DirectCast(ser.Deserialize(reader), Report)
End Using

Vc faz pegando o arquivo externo e no meu caso estou pegando o conteudo direto de um webservice, ou seja o xml esta com o conteudo numa variavel do tipo string.

Como faço para deserealizar a partir de uma variavel?

KERPLUNK 13/02/2014 15:50:05
#434738

Praticamente a mesma coisa. Só que ao invÃ©s de um xmlReader, você vai usar um StringReader:


Using reader As New StringReader(conteudo)
	resultadoFinal = DirectCast(ser.Deserialize(reader), Report)
End Using

ANGELOATA 14/02/2014 11:24:58
#434772

Cara fiz a conversao do xml coloquei no projeto e ao executar da o seguinte erro:

Dim ser As New XmlSerializer(GetType(Report))

Não Ã© possÃvel gerar uma classe temporária (result=1).
error CS0030: Não Ã© possÃvel converter o tipo [Ã´]fast.ReportRecordField[][Ã´] em [Ã´]fast.ReportRecordField[Ã´]
error CS0029: Não Ã© possÃvel converter implicitamente o tipo [Ã´]fast.ReportRecordField[Ã´] em [Ã´]fast.ReportRecordField[][Ã´]

O que pode ser?

ANGELOATA 14/02/2014 11:29:55
#434773

Segue a classe gerada pelo xsd

[Ã´]------------------------------------------------------------------------------
[Ã´] <auto-generated>
[Ã´] This code was generated by a tool.
[Ã´] Runtime Version:4.0.30319.586
[Ã´]
[Ã´] Changes to this file may cause incorrect behavior and will be lost if
[Ã´] the code is regenerated.
[Ã´] </auto-generated>
[Ã´]------------------------------------------------------------------------------

Option Strict Off
Option Explicit On

Imports System.Xml.Serialization

[Ã´]
[Ã´]This source code was auto-generated by xsd, Version=4.0.30319.1.
[Ã´]

[Ã´][Ã´][Ã´]<remarks/>
<System.CodeDom.Compiler.GeneratedCodeAttribute([Ã”]xsd[Ã”], [Ã”]4.0.30319.1[Ã”]), _
System.SerializableAttribute(), _
System.Diagnostics.DebuggerStepThroughAttribute(), _
System.ComponentModel.DesignerCategoryAttribute([Ã”]code[Ã”]), _
System.Xml.Serialization.XmlTypeAttribute(AnonymousType:=true), _
System.Xml.Serialization.XmlRootAttribute([Namespace]:=[Ã”][Ã”], IsNullable:=false)> _
Partial Public Class Report

Private recordField()() As ReportRecordField

Private objectNameField As String

Private storeNameField As String

Private execDateField As String

Private fromRecordField As String

Private toRecordField As String

Private parName1Field As String

Private parValue1Field As String

Private parName2Field As String

Private parValue2Field As String

Private parName3Field As String

Private parValue3Field As String

Private parName4Field As String

Private parValue4Field As String

Private parName5Field As String

Private parValue5Field As String

Private parName6Field As String

Private parValue6Field As String

Private parName7Field As String

Private parValue7Field As String

Private parName8Field As String

Private parValue8Field As String

Private recordsField As String

Private readRecordsField As String

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlArrayAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified), _
System.Xml.Serialization.XmlArrayItemAttribute([Ã”]Field[Ã”], GetType(ReportRecordField), Form:=System.Xml.Schema.XmlSchemaForm.Unqualified, IsNullable:=false)> _
Public Property Record() As ReportRecordField()()
Get
Return Me.recordField
End Get
Set
Me.recordField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ObjectName() As String
Get
Return Me.objectNameField
End Get
Set
Me.objectNameField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property StoreName() As String
Get
Return Me.storeNameField
End Get
Set
Me.storeNameField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ExecDate() As String
Get
Return Me.execDateField
End Get
Set
Me.execDateField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property FromRecord() As String
Get
Return Me.fromRecordField
End Get
Set
Me.fromRecordField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ToRecord() As String
Get
Return Me.toRecordField
End Get
Set
Me.toRecordField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName1() As String
Get
Return Me.parName1Field
End Get
Set
Me.parName1Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue1() As String
Get
Return Me.parValue1Field
End Get
Set
Me.parValue1Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName2() As String
Get
Return Me.parName2Field
End Get
Set
Me.parName2Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue2() As String
Get
Return Me.parValue2Field
End Get
Set
Me.parValue2Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName3() As String
Get
Return Me.parName3Field
End Get
Set
Me.parName3Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue3() As String
Get
Return Me.parValue3Field
End Get
Set
Me.parValue3Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName4() As String
Get
Return Me.parName4Field
End Get
Set
Me.parName4Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue4() As String
Get
Return Me.parValue4Field
End Get
Set
Me.parValue4Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName5() As String
Get
Return Me.parName5Field
End Get
Set
Me.parName5Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue5() As String
Get
Return Me.parValue5Field
End Get
Set
Me.parValue5Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName6() As String
Get
Return Me.parName6Field
End Get
Set
Me.parName6Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue6() As String
Get
Return Me.parValue6Field
End Get
Set
Me.parValue6Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName7() As String
Get
Return Me.parName7Field
End Get
Set
Me.parName7Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue7() As String
Get
Return Me.parValue7Field
End Get
Set
Me.parValue7Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParName8() As String
Get
Return Me.parName8Field
End Get
Set
Me.parName8Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ParValue8() As String
Get
Return Me.parValue8Field
End Get
Set
Me.parValue8Field = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property Records() As String
Get
Return Me.recordsField
End Get
Set
Me.recordsField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property ReadRecords() As String
Get
Return Me.readRecordsField
End Get
Set
Me.readRecordsField = value
End Set
End Property
End Class

[Ã´][Ã´][Ã´]<remarks/>
<System.CodeDom.Compiler.GeneratedCodeAttribute([Ã”]xsd[Ã”], [Ã”]4.0.30319.1[Ã”]), _
System.SerializableAttribute(), _
System.Diagnostics.DebuggerStepThroughAttribute(), _
System.ComponentModel.DesignerCategoryAttribute([Ã”]code[Ã”]), _
System.Xml.Serialization.XmlTypeAttribute(AnonymousType:=true)> _
Partial Public Class ReportRecordField

Private nameField As String

Private valueField As String

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property Name() As String
Get
Return Me.nameField
End Get
Set
Me.nameField = value
End Set
End Property

[Ã´][Ã´][Ã´]<remarks/>
<System.Xml.Serialization.XmlAttributeAttribute()> _
Public Property Value() As String
Get
Return Me.valueField
End Get
Set
Me.valueField = value
End Set
End Property
End Class

[Ã´][Ã´][Ã´]<remarks/>
<System.CodeDom.Compiler.GeneratedCodeAttribute([Ã”]xsd[Ã”], [Ã”]4.0.30319.1[Ã”]), _
System.SerializableAttribute(), _
System.Diagnostics.DebuggerStepThroughAttribute(), _
System.ComponentModel.DesignerCategoryAttribute([Ã”]code[Ã”]), _
System.Xml.Serialization.XmlTypeAttribute(AnonymousType:=true), _
System.Xml.Serialization.XmlRootAttribute([Na

KERPLUNK 14/02/2014 11:34:02
#434774

é um erro conhecido do xsd. Ao gerar o arquivo .xsd, você deve incluir um atributo dummy antes de converter para classes:


<xs:sequence maxOccurs=[Ã”]unbounded[Ã”]>
  <xs:element ../>
<xs:sequence>
<xs:attribute name=[Ã”]tmp[Ã”] type=[Ã”]xs:string[Ã”] />      <-- adicione isso

No xsd vai ter algo parecido com as 3 primeiras linhas do exemplo, simplesmente adicione uma linha [Ã”]tmp[Ã”] como mostrado.

ANGELOATA 14/02/2014 11:47:41
#434776

Cara

Adicionei a linha mas ainda nao deu certo. ve se esta correto:

<?xml version=[Ã”]1.0[Ã”] encoding=[Ã”]utf-8[Ã”]?>
<xs:schema id=[Ã”]NewDataSet[Ã”] xmlns=[Ã”][Ã”] xmlns:xs=[Ã”]http://www.w3.org/2001/XMLSchema[Ã”] xmlns:msdata=[Ã”]urn:schemas-microsoft-com:xml-msdata[Ã”]>
<xs:element name=[Ã”]Report[Ã”]>
<xs:complexType>
<xs:sequence>
<xs:element name=[Ã”]Record[Ã”] minOccurs=[Ã”]0[Ã”] maxOccurs=[Ã”]unbounded[Ã”]>
<xs:complexType>
<xs:sequence>
<xs:element name=[Ã”]Field[Ã”] minOccurs=[Ã”]0[Ã”] maxOccurs=[Ã”]unbounded[Ã”]>
<xs:complexType>
<xs:attribute name=[Ã”]Name[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]Value[Ã”] type=[Ã”]xs:string[Ã”] />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name=[Ã”]ObjectName[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]StoreName[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ExecDate[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]FromRecord[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ToRecord[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName1[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue1[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName2[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue2[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName3[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue3[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName4[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue4[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName5[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue5[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName6[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue6[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName7[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue7[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParName8[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ParValue8[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]Records[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]ReadRecords[Ã”] type=[Ã”]xs:string[Ã”] />
<xs:attribute name=[Ã”]tmp[Ã”] type=[Ã”]xs:string[Ã”] />
</xs:complexType>
</xs:element>
<xs:element name=[Ã”]NewDataSet[Ã”] msdata:IsDataSet=[Ã”]true[Ã”] msdata:UseCurrentLocale=[Ã”]true[Ã”]>
<xs:complexType>
<xs:choice minOccurs=[Ã”]0[Ã”] maxOccurs=[Ã”]unbounded[Ã”]>
<xs:element ref=[Ã”]Report[Ã”] />
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>

Página 2 de 3 [26 registro(s)]

Tópico encerrado , respostas não são mais permitidas

Voltar