데이타셋을 레코드셋으로 변경하려고 합니다.
방법은
데이타셋 -> XML -> 파일스트림 -> 레코드셋
이렇게 하려고 하는데...
레코드셋 -> 파일스트림 -> XML 로 변경해서 XML -> 파일스트림 -> 레코드셋
Dim rs As New ADODB.Recordset
Dim st As New ADODB.Stream
st.Open
st.WriteText txtXML.Text
st.Position = 0
rs.Open st
이런 식으로 해서 XML 을 레코드셋으로 오픈을 할 수 있습니다.
그런데
데이타셋 -> XML -> 파일스트림 -> 레코드셋 으로 하는 방법은 안되더라구요.
찾아보았는데....
레코드셋 -> 파일스트림 -> XML 로 변경해서 XML -> 파일스트림 -> 레코드셋 으로 하는 방법에서
나온 XML 파일과
데이타셋 -> XML -> 파일스트림 -> 레코드셋
방법에서 나온 XML 파일이 좀 다르더라구요.
데이타셋 -> XML -> 파일스트림 -> 레코드셋 에서 나온 XML 파일은
=========================
<?xml version="1.0" standalone="yes" ?>
- <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" msdata:UseCurrentLocale="true">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="TABLE1">
- <xs:complexType>
- <xs:sequence>
<xs:element name="DEPT_CD_KIND" type="xs:string" minOccurs="0" />
<xs:element name="DEPT_CD" type="xs:string" minOccurs="0" />
<xs:element name="DEPT_NAME" type="xs:string" minOccurs="0" />
<xs:element name="TREE_CD" type="xs:string" minOccurs="0" />
<xs:element name="ORG_PART" type="xs:string" minOccurs="0" />
<xs:element name="PRT_PRY" type="xs:string" minOccurs="0" />
<xs:element name="MAKE_SALE" type="xs:string" minOccurs="0" />
<xs:element name="DIR_TYPE" type="xs:string" minOccurs="0" />
<xs:element name="USER_YN" type="xs:string" minOccurs="0" />
<xs:element name="DIR_MAN" type="xs:decimal" minOccurs="0" />
<xs:element name="INDIR_MAN" type="xs:decimal" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
- <TABLE1>
<DEPT_CD_KIND>1</DEPT_CD_KIND>
<DEPT_CD>9999</DEPT_CD>
<DEPT_NAME>전체부서</DEPT_NAME>
<TREE_CD>dot</TREE_CD>
<ORG_PART>1</ORG_PART>
<PRT_PRY>000</PRT_PRY>
<MAKE_SALE>2</MAKE_SALE>
<DIR_TYPE>1</DIR_TYPE>
<USER_YN>Y</USER_YN>
<DIR_MAN>0</DIR_MAN>
<INDIR_MAN>0</INDIR_MAN>
</TABLE1>
================================
이런 식으로 생겼는데...
레코드셋 -> 파일스트림 -> XML 로 변경해서 XML -> 파일스트림 -> 레코드셋 방법에서
나온 XML 파일은
===================================
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='PO_PLAN_NO' rs:number='1' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='PO_PLAN_DT' rs:number='2' rs:nullable='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10'/>
</s:AttributeType>
<s:AttributeType name='EMP_NO' rs:number='3' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='8'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='NAME' rs:number='4' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='16'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ITEM_LVL1' rs:number='5' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='3'/>
</s:AttributeType>
<s:AttributeType name='ITEM_LVL2' rs:number='6' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='3'/>
</s:AttributeType>
<s:AttributeType name='ITEM_LVL3' rs:number='7' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='3'/>
</s:AttributeType>
<s:AttributeType name='MODEL' rs:number='8' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='MODEL_NM' rs:number='9' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='40'/>
</s:AttributeType>
<s:AttributeType name='PJT_NO' rs:number='10' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='14'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ITEM_CD' rs:number='11' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ITEM_NM' rs:number='12' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='100'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='CODE_NAME' rs:number='13' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='BASE_PRICE' rs:number='14' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='4' rs:precision='18' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='MONEY_UNIT' rs:number='15' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='3'/>
</s:AttributeType>
<s:AttributeType name='P_ITEM_CD' rs:number='16' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='SPEC' rs:number='17' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='100'/>
</s:AttributeType>
<s:AttributeType name='REQ_QTY' rs:number='18' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='4' rs:precision='18' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='PO_AMT' rs:number='19' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='4' rs:precision='18' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='MAKER' rs:number='20' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='30'/>
</s:AttributeType>
<s:AttributeType name='DVRY_DT' rs:number='21' rs:nullable='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10'/>
</s:AttributeType>
<s:AttributeType name='MIN_PJT_NO' rs:number='22' rs:nullable='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='14'/>
</s:AttributeType>
<s:AttributeType name='MAX_PJT_NO' rs:number='23' rs:nullable='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='14'/>
</s:AttributeType>
<s:AttributeType name='AMT' rs:number='24'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='8' rs:precision='37' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='RMK' rs:number='25' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='200'/>
</s:AttributeType>
<s:AttributeType name='PO_PLAN_KIND' rs:number='26'
rs:nullable='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50'/>
</s:AttributeType>
<s:AttributeType name='BASE_ITEM_CD' rs:number='27'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='STOCK_QTY' rs:number='28'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='4' rs:precision='38' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='old_price' rs:number='29' rs:nullable='true'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='4' rs:precision='18' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row PO_PLAN_NO='PR050700198' PO_PLAN_DT='2005-07-29'
EMP_NO='0307022' NAME='김기환' ITEM_LVL1='*' ITEM_LVL2='*'
ITEM_LVL3='*' MODEL='*' PJT_NO='RDNC1205001' ITEM_CD='KSP1-049229'
ITEM_NM='PRESSURE SENSOR' CODE_NAME='EA' BASE_PRICE='.0000'
MONEY_UNIT='KRW' P_ITEM_CD='KSP1-049229' SPEC='DP4-52(1.0MPa)'
REQ_QTY='6.0000' PO_AMT='.0000' MAKER='SUNX' DVRY_DT='2005-07-29'
MIN_PJT_NO='RDNC1205001' MAX_PJT_NO='RDNC1205001' AMT='.00000000'
PO_PLAN_KIND='설계변경' BASE_ITEM_CD='*' STOCK_QTY='.0000'
old_price='85000.0000'/>
</rs:data>
</xml>
===========================
이런 식으로 생겼더라구요...
데이타셋 -> XML -> 파일스트림 -> 레코드셋 방법에서 나오는 오류가 화면과 같습니다.
방법이 없을까요?....계속 고민 중인데....조언 좀 부탁드립니다.
[최초 등록일: ]
[최종 수정일: 5/13/2006]