|
쿼리한 결과를 출력한 그리드를
ADOQuery2->SaveToFile(SaveDialog2->FileName,pfXML);
이렇게 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" rs:updatable="true">
- <s:AttributeType name="num" rs:number="1" rs:nullable="true" rs:write="true" rs:basecatalog="mysql" rs:basetable="bbs_member" rs:basecolumn="num" rs:keycolumn="true" rs:autoincrement="true">
<s:datatype dt:type="int" dt:maxLength="4" rs:precision="11" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="id" rs:number="2" rs:write="true" rs:basecatalog="mysql" rs:basetable="bbs_member" rs:basecolumn="id" rs:keycolumn="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="passwd" rs:number="3" rs:write="true" rs:basecatalog="mysql" rs:basetable="bbs_member" rs:basecolumn="passwd" rs:keycolumn="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="30" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="section" rs:number="4" rs:write="true" rs:basecatalog="mysql" rs:basetable="bbs_member" rs:basecolumn="section" rs:keycolumn="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="6" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="dummy" rs:number="5" rs:nullable="true" rs:write="true" rs:basecatalog="mysql" rs:basetable="bbs_member" rs:basecolumn="dummy" rs:keycolumn="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row num="1" id="admin" passwd="1234" section="admin" dummy="" />
</rs:data>
</xml>
|