[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.aspnet.webservices

Problem using an XML document created by SQL Server in Datagrid

Ken

12/31/2002 12:03:00 AM

I still have a problem. Here is the code that is suppose to get the XML
document and attach it to the datagrid.
Please let me know what I am missing in the code!

Again, Thank You for Your Help,
kkoski1@mindspring.com
Ken



string mypath;
mypath = "";
DataSet dsdata = new DataSet();

mypath = TxtPath_fileName.Text.ToString()+ "\\" +
Txt_filename.Text.ToString();
System.IO.FileStream fsReadXml = new System.IO.FileStream (mypath,
System.IO.FileMode.Open,FileAccess.Read);
StreamReader reader = new StreamReader(fsReadXml);
dsdata.ReadXml(fsReadXml);
fsReadXml.Close();
reader.Close();
DataView view = dsdata.Tables[0].DefaultView;
MYXML.DataSource = view;
MYXML.DataBind();

------------------------------------------------------------------------
----
-------------
This is what I end up with. When I look at the XML document I can see
that
this is the last table segment
------------------------------------------------------------------------
----
-------------


XML_F52E2B61-18A1-11d1-B105-00805F49916B

tName="Zbyszek Piestrzeniewicz" ContactTitle="Owner" Address="ul.
Filtrowa
68" City="Warszawa" PostalCode="01-012" Country="Poland" Phone="(26)
642-7012" Fax="(26) 642-7012"/>
------------------------------------------------------------------------
----
--------------

- <NewDataSet>
- <xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSc...
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="NewDataSet" msdata:IsDataSet="true">
- <xs:complexType>
- <xs:choice maxOccurs="unbounded">
- <xs:element name="Table">
- <xs:complexType>
- <xs:sequence>
<xs:element name="XML_F52E2B61-18A1-11d1-B105-00805F49916B"
type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B><customers
CustomerID="ALFKI"
CompanyName="Alfreds Futterkiste" ContactName="Maria Anders"
ContactTitle="Sales Representative" Address="Obere Str. 57"
City="Berlin"
PostalCode="12209" Country="Germany" Phone="030-0074321"
Fax="030-0076545"/><customers CustomerID="ANATR" CompanyName="Ana
Trujillo
Emparedados y helados" ContactName="Ana Trujillo" ContactTitle="Owner"
Address="Avda. de la Constitución 2222" City="México D.F."
PostalCode="05021" Country="Mexico" Phone="(5) 555-4729" Fax="(5)
555-3745"/><customers CustomerID="ANTON" CompanyName="Antonio Moreno
Taquería" ContactName="Antonio Moreno" ContactTitle="Owner"
Address="Mataderos 2312" City="México D.F." PostalCode="05023"
Country="Mexico" Phone="(5) 555-3932"/><customers CustomerID="AROUT"
CompanyName="Around the Horn" ContactName="Thomas Hardy"
ContactTitle="Sales
Representative" Address="120 Hanover Sq." City="London" PostalCode="WA1
1DP"
Country="UK" Phone="(171) 555-7788" Fax="(171) 555-6750"/><customers
CustomerID="BERGS" CompanyName="Berglunds snabbköp"
ContactName="Christina
Berglund" ContactTitle="Order Administrator" Address="Berguvsvägen 8"
City="Luleå" PostalCode="S-958 22" Country="Sweden" Phone="0921-12 34
65"
Fax="0921-12 34 67"/><customers CustomerID="BLAUS" CompanyName="Blauer
See
Delikatessen" ContactName="Hanna Moos" ContactTitle="Sales
Representative"
Address="Forsterstr. 57" City="Mannheim" PostalCode="68306"
Country="Germany" Phone="0621-08460" Fax="0621-08924"/><customers
CustomerID="BLONP" CompanyName="Blondesddsl père et fils"
ContactName="Frédérique Citeaux" ContactTitle="Marketing Manager"
Address="24, place Kléber" City="Strasbourg" PostalCode="67000"
Country="France" Phone="88.60.15.31" Fax="88.60.15.32"/><customers
CustomerID="BOLID" CompanyName="Bólido Comidas preparadas"
ContactName="Martín Sommer" ContactTitle="Owner" Address="C/ Araquil,
67"
City="Madrid" PostalCode="28023" Country="Spain" Phone="(91) 555 22 82"
Fax="(91) 555 91 99"/><customers CustomerID="BONAP" CompanyName="Bon
app&apos;"
ContactName="Lauren</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>ce Lebihan"
ContactTitle="Owner"
Address="12, rue des Bouchers" City="Marseille" PostalCode="13008"
Country="France" Phone="91.24.45.40" Fax="91.24.45.41"/><customers
CustomerID="BOTTM" CompanyName="Bottom-Dollar Markets"
ContactName="Elizabeth Lincoln" ContactTitle="Accounting Manager"
Address="23 Tsawassen Blvd." City="Tsawassen" Region="BC"
PostalCode="T2F
8M4" Country="Canada" Phone="(604) 555-4729" Fax="(604)
555-3745"/><customers CustomerID="BSBEV" CompanyName="B&apos;s
Beverages"
ContactName="Victoria Ashworth" ContactTitle="Sales Representative"
Address="Fauntleroy Circus" City="London" PostalCode="EC2 5NT"
Country="UK"
Phone="(171) 555-1212"/><customers CustomerID="CACTU"
CompanyName="Cactus
Comidas para llevar" ContactName="Patricio Simpson" ContactTitle="Sales
Agent" Address="Cerrito 333" City="Buenos Aires" PostalCode="1010"
Country="Argentina" Phone="(1) 135-5555" Fax="(1) 135-4892"/><customers
CustomerID="CENTC" CompanyName="Centro comercial Moctezuma"
ContactName="Francisco Chang" ContactTitle="Marketing Manager"
Address="Sierras de Granada 9993" City="México D.F." PostalCode="05022"
Country="Mexico" Phone="(5) 555-3392" Fax="(5) 555-7293"/><customers
CustomerID="CHOPS" CompanyName="Chop-suey Chinese" ContactName="Yang
Wang"
ContactTitle="Owner" Address="Hauptstr. 29" City="Bern"
PostalCode="3012"
Country="Switzerland" Phone="0452-076545"/><customers CustomerID="COMMI"
CompanyName="Comércio Mineiro" ContactName="Pedro Afonso"
ContactTitle="Sales Associate" Address="Av. dos Lusíadas, 23" City="Sao
Paulo" Region="SP" PostalCode="05432-043" Country="Brazil" Phone="(11)
555-7647"/><customers CustomerID="CONSH" CompanyName="Consolidated
Holdings"
ContactName="Elizabeth Brown" ContactTitle="Sales Representative"
Address="Berkeley Gardens 12 Brewery" City="London" PostalCode="WX1 6LT"
Country="UK" Phone="(171) 555-2282" Fax="(171) 555-9199"/><customers
CustomerID="DRACD" CompanyName="Drachenblut Delikatessen"
ContactName="Sven
Ottlieb" ContactTitle="Order Administrator"
Address="Walserweg</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>21" City="Aachen"
PostalCode="52066" Country="Germany" Phone="0241-039123"
Fax="0241-059428"/><customers CustomerID="DUMON" CompanyName="Du monde
entier" ContactName="Janine Labrune" ContactTitle="Owner" Address="67,
rue
des Cinquante Otages" City="Nantes" PostalCode="44000" Country="France"
Phone="40.67.88.88" Fax="40.67.89.89"/><customers CustomerID="EASTC"
CompanyName="Eastern Connection" ContactName="Ann Devon"
ContactTitle="Sales
Agent" Address="35 King George" City="London" PostalCode="WX3 6FW"
Country="UK" Phone="(171) 555-0297" Fax="(171) 555-3373"/><customers
CustomerID="ERNSH" CompanyName="Ernst Handel" ContactName="Roland
Mendel"
ContactTitle="Sales Manager" Address="Kirchgasse 6" City="Graz"
PostalCode="8010" Country="Austria" Phone="7675-3425"
Fax="7675-3426"/><customers CustomerID="FAMIA" CompanyName="Familia
Arquibaldo" ContactName="Aria Cruz" ContactTitle="Marketing Assistant"
Address="Rua Orós, 92" City="Sao Paulo" Region="SP"
PostalCode="05442-030"
Country="Brazil" Phone="(11) 555-9857"/><customers CustomerID="FISSA"
CompanyName="FISSA Fabrica Inter. Salchichas S.A." ContactName="Diego
Roel"
ContactTitle="Accounting Manager" Address="C/ Moralzarzal, 86"
City="Madrid"
PostalCode="28034" Country="Spain" Phone="(91) 555 94 44" Fax="(91) 555
55
93"/><customers CustomerID="FOLIG" CompanyName="Folies gourmandes"
ContactName="Martine Rancé" ContactTitle="Assistant Sales Agent"
Address="184, chaussée de Tournai" City="Lille" PostalCode="59000"
Country="France" Phone="20.16.10.16" Fax="20.16.10.17"/><customers
CustomerID="FOLKO" CompanyName="Folk och fä HB" ContactName="Maria
Larsson"
ContactTitle="Owner" Address="Åkergatan 24" City="Bräcke"
PostalCode="S-844
67" Country="Sweden" Phone="0695-34 67 21"/><customers
CustomerID="FRANK"
CompanyName="Frankenversand" ContactName="Peter Franken"
ContactTitle="Marketing Manager" Address="Berliner Platz 43"
City="München"
PostalCode="80805" Country="Germany" Phone="089-0877310"
Fax="089-0877451"/><customers CustomerID="FRANR" CompanyName="France
res</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>tauration"
ContactName="Carine
Schmitt" ContactTitle="Marketing Manager" Address="54, rue Royale"
City="Nantes" PostalCode="44000" Country="France" Phone="40.32.21.21"
Fax="40.32.21.20"/><customers CustomerID="FRANS" CompanyName="Franchi
S.p.A." ContactName="Paolo Accorti" ContactTitle="Sales Representative"
Address="Via Monte Bianco 34" City="Torino" PostalCode="10100"
Country="Italy" Phone="011-4988260" Fax="011-4988261"/><customers
CustomerID="FURIB" CompanyName="Furia Bacalhau e Frutos do Mar"
ContactName="Lino Rodriguez" ContactTitle="Sales Manager"
Address="Jardim
das rosas n. 32" City="Lisboa" PostalCode="1675" Country="Portugal"
Phone="(1) 354-2534" Fax="(1) 354-2535"/><customers CustomerID="GALED"
CompanyName="Galería del gastrónomo" ContactName="Eduardo Saavedra"
ContactTitle="Marketing Manager" Address="Rambla de Cataluña, 23"
City="Barcelona" PostalCode="08022" Country="Spain" Phone="(93) 203
4560"
Fax="(93) 203 4561"/><customers CustomerID="GODOS" CompanyName="Godos
Cocina
Típica" ContactName="José Pedro Freyre" ContactTitle="Sales Manager"
Address="C/ Romero, 33" City="Sevilla" PostalCode="41101"
Country="Spain"
Phone="(95) 555 82 82"/><customers CustomerID="GOURL"
CompanyName="Gourmet
Lanchonetes" ContactName="André Fonseca" ContactTitle="Sales Associate"
Address="Av. Brasil, 442" City="Campinas" Region="SP"
PostalCode="04876-786"
Country="Brazil" Phone="(11) 555-9482"/><customers CustomerID="GREAL"
CompanyName="Great Lakes Food Market" ContactName="Howard Snyder"
ContactTitle="Marketing Manager" Address="2732 Baker Blvd."
City="Eugene"
Region="OR" PostalCode="97403" Country="USA" Phone="(503)
555-7555"/><customers CustomerID="GROSR"
CompanyName="GROSELLA-Restaurante"
ContactName="Manuel Pereira" ContactTitle="Owner" Address="5ª Ave. Los
Palos
Grandes" City="Caracas" Region="DF" PostalCode="1081"
Country="Venezuela" Ph
one="(2) 283-2951" Fax="(2) 283-3397"/><customers CustomerID="HANAR"
CompanyName="Hanari Carnes" ContactName="Mario Pontes"
ContactTitle="Accounting Manager"
Address="R</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>ua do Paço, 67" City="Rio de
Janeiro" Region="RJ" PostalCode="05454-876" Country="Brazil" Phone="(21)
555-0091" Fax="(21) 555-8765"/><customers CustomerID="HILAA"
CompanyName="HILARION-Abastos" ContactName="Carlos Hernández"
ContactTitle="Sales Representative" Address="Carrera 22 con Ave. Carlos
Soublette #8-35" City="San Cristóbal" Region="Táchira" PostalCode="5022"
Country="Venezuela" Phone="(5) 555-1340" Fax="(5) 555-1948"/><customers
CustomerID="HUNGC" CompanyName="Hungry Coyote Import Store"
ContactName="Yoshi Latimer" ContactTitle="Sales Representative"
Address="City Center Plaza 516 Main St." City="Elgin" Region="OR"
PostalCode="97827" Country="USA" Phone="(503) 555-6874" Fax="(503)
555-2376"/><customers CustomerID="HUNGO" CompanyName="Hungry Owl
All-Night
Grocers" ContactName="Patricia McKenna" ContactTitle="Sales Associate"
Address="8 Johnstown Road" City="Cork" Region="Co. Cork"
Country="Ireland"
Phone="2967 542" Fax="2967 3333"/><customers CustomerID="ISLAT"
CompanyName="Island Trading" ContactName="Helen Bennett"
ContactTitle="Marketing Manager" Address="Garden House Crowther Way"
City="Cowes" Region="Isle of Wight" PostalCode="PO31 7PJ" Country="UK"
Phone="(198) 555-8888"/><customers CustomerID="KOENE"
CompanyName="Königlich
Essen" ContactName="Philip Cramer" ContactTitle="Sales Associate"
Address="Maubelstr. 90" City="Brandenburg" PostalCode="14776"
Country="Germany" Phone="0555-09876"/><customers CustomerID="LACOR"
CompanyName="La corne d&apos;abondance" ContactName="Daniel Tonini"
ContactTitle="Sales Representative" Address="67, avenue de
l&apos;Europe"
City="Versailles" PostalCode="78000" Country="France"
Phone="30.59.84.10"
Fax="30.59.85.11"/><customers CustomerID="LAMAI" CompanyName="La maison
d&apos;Asie" ContactName="Annette Roulet" ContactTitle="Sales Manager"
Address="1 rue Alsace-Lorraine" City="Toulouse" PostalCode="31000"
Country="France" Phone="61.77.61.10" Fax="61.77.61.11"/><customers
CustomerID="LAUGB" CompanyName="Laughing Bacchus Wine Cellars"
ContactName="Yoshi Tann</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>amuri"
ContactTitle="Marketing
Assistant" Address="1900 Oak St." City="Vancouver" Region="BC"
PostalCode="V3F 2K1" Country="Canada" Phone="(604) 555-3392" Fax="(604)
555-7293"/><customers CustomerID="LAZYK" CompanyName="Lazy K Kountry
Store"
ContactName="John Steel" ContactTitle="Marketing Manager" Address="12
Orchestra Terrace" City="Walla Walla" Region="WA" PostalCode="99362"
Country="USA" Phone="(509) 555-7969" Fax="(509) 555-6221"/><customers
CustomerID="LEHMS" CompanyName="Lehmanns Marktstand" ContactName="Renate
Messner" ContactTitle="Sales Representative" Address="Magazinweg 7"
City="Frankfurt a.M." PostalCode="60528" Country="Germany"
Phone="069-0245984" Fax="069-0245874"/><customers CustomerID="LETSS"
CompanyName="Let&apos;s Stop N Shop" ContactName="Jaime Yorres"
ContactTitle="Owner" Address="87 Polk St. Suite 5" City="San Francisco"
Region="CA" PostalCode="94117" Country="USA" Phone="(415)
555-5938"/><customers CustomerID="LILAS" CompanyName="LILA-Supermercado"
ContactName="Carlos González" ContactTitle="Accounting Manager"
Address="Carrera 52 con Ave. Bolívar #65-98 Llano Largo"
City="Barquisimeto"
Region="Lara" PostalCode="3508" Country="Venezuela" Phone="(9) 331-6954"
Fax="(9) 331-7256"/><customers CustomerID="LINOD"
CompanyName="LINO-Delicateses" ContactName="Felipe Izquierdo"
ContactTitle="Owner" Address="Ave. 5 de Mayo Porlamar" City="I. de
Margarita" Region="Nueva Esparta" PostalCode="4980" Country="Venezuela"
Phone="(8) 34-56-12" Fax="(8) 34-93-93"/><customers CustomerID="LONEP"
CompanyName="Lonesome Pine Restaurant" ContactName="Fran Wilson"
ContactTitle="Sales Manager" Address="89 Chiaroscuro Rd."
City="Portland"
Region="OR" PostalCode="97219" Country="USA" Phone="(503) 555-9573"
Fax="(503) 555-9646"/><customers CustomerID="MAGAA"
CompanyName="Magazzini
Alimentari Riuniti" ContactName="Giovanni Rovelli"
ContactTitle="Marketing
Manager" Address="Via Ludovico il Moro 22" City="Bergamo"
PostalCode="24100"
Country="Italy" Phone="035-640230" Fax="035-640231"/><customers
CustomerID="</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>MAISD" CompanyName="Maison
Dewey" ContactName="Catherine Dewey" ContactTitle="Sales Agent"
Address="Rue
Joseph-Bens 532" City="Bruxelles" PostalCode="B-1180" Country="Belgium"
Phone="(02) 201 24 67" Fax="(02) 201 24 68"/><customers
CustomerID="MEREP"
CompanyName="Mère Paillarde" ContactName="Jean Fresnière"
ContactTitle="Marketing Assistant" Address="43 rue St. Laurent"
City="Montréal" Region="Québec" PostalCode="H1J 1C3" Country="Canada"
Phone="(514) 555-8054" Fax="(514) 555-8055"/><customers
CustomerID="MORGK"
CompanyName="Morgenstern Gesundkost" ContactName="Alexander Feuer"
ContactTitle="Marketing Assistant" Address="Heerstr. 22" City="Leipzig"
PostalCode="04179" Country="Germany" Phone="0342-023176"/><customers
CustomerID="NORTS" CompanyName="North/South" ContactName="Simon
Crowther"
ContactTitle="Sales Associate" Address="South House 300 Queensbridge"
City="London" PostalCode="SW7 1RZ" Country="UK" Phone="(171) 555-7733"
Fax="(171) 555-2530"/><customers CustomerID="OCEAN" CompanyName="Océano
Atlántico Ltda." ContactName="Yvonne Moncada" ContactTitle="Sales Agent"
Address="Ing. Gustavo Moncada 8585 Piso 20-A" City="Buenos Aires"
PostalCode="1010" Country="Argentina" Phone="(1) 135-5333" Fax="(1)
135-5535"/><customers CustomerID="OLDWO" CompanyName="Old World
Delicatessen" ContactName="Rene Phillips" ContactTitle="Sales
Representative" Address="2743 Bering St." City="Anchorage" Region="AK"
PostalCode="99508" Country="USA" Phone="(907) 555-7584" Fax="(907)
555-2880"/><customers CustomerID="OTTIK" CompanyName="Ottilies
Käseladen"
ContactName="Henriette Pfalzheim" ContactTitle="Owner"
Address="Mehrheimerstr. 369" City="Köln" PostalCode="50739"
Country="Germany" Phone="0221-0644327" Fax="0221-0765721"/><customers
CustomerID="PARIS" CompanyName="Paris spécialités" ContactName="Marie
Bertrand" ContactTitle="Owner" Address="265, boulevard Charonne"
City="Paris" PostalCode="75012" Country="France" Phone="(1) 42.34.22.66"
Fax="(1) 42.34.22.77"/><customers CustomerID="PERIC"
CompanyName="Pericles
Comidas</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>clásicas"
ContactName="Guillermo
Fernández" ContactTitle="Sales Representative" Address="Calle Dr. Jorge
Cash
321" City="México D.F." PostalCode="05033" Country="Mexico" Phone="(5)
552-3745" Fax="(5) 545-3745"/><customers CustomerID="PICCO"
CompanyName="Piccolo und mehr" ContactName="Georg Pipps"
ContactTitle="Sales
Manager" Address="Geislweg 14" City="Salzburg" PostalCode="5020"
Country="Austria" Phone="6562-9722" Fax="6562-9723"/><customers
CustomerID="PRINI" CompanyName="Princesa Isabel Vinhos"
ContactName="Isabel
de Castro" ContactTitle="Sales Representative" Address="Estrada da saúde
n.
58" City="Lisboa" PostalCode="1756" Country="Portugal" Phone="(1)
356-5634"/><customers CustomerID="QUEDE" CompanyName="Que Delícia"
ContactName="Bernardo Batista" ContactTitle="Accounting Manager"
Address="Rua da Panificadora, 12" City="Rio de Janeiro" Region="RJ"
PostalCode="02389-673" Country="Brazil" Phone="(21) 555-4252" Fax="(21)
555-4545"/><customers CustomerID="QUEEN" CompanyName="Queen Cozinha"
ContactName="Lúcia Carvalho" ContactTitle="Marketing Assistant"
Address="Alameda dos Canàrios, 891" City="Sao Paulo" Region="SP"
PostalCode="05487-020" Country="Brazil" Phone="(11)
555-1189"/><customers
CustomerID="QUICK" CompanyName="QUICK-Stop" ContactName="Horst Kloss"
ContactTitle="Accounting Manager" Address="Taucherstraße 10"
City="Cunewalde" PostalCode="01307" Country="Germany"
Phone="0372-035188"/><customers CustomerID="RANCH" CompanyName="Rancho
grande" ContactName="Sergio Gutiérrez" ContactTitle="Sales
Representative"
Address="Av. del Libertador 900" City="Buenos Aires" PostalCode="1010"
Country="Argentina" Phone="(1) 123-5555" Fax="(1) 123-5556"/><customers
CustomerID="RATTC" CompanyName="Rattlesnake Canyon Grocery"
ContactName="Paula Wilson" ContactTitle="Assistant Sales Representative"
Address="2817 Milton Dr." City="Albuquerque" Region="NM"
PostalCode="87110"
Country="USA" Phone="(505) 555-5939" Fax="(505) 555-3620"/><customers
CustomerID="REGGC" CompanyName="Reggiani Caseifici"
ContactName="Mauri</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>zio Moroni"
ContactTitle="Sales
Associate" Address="Strada Provinciale 124" City="Reggio Emilia"
PostalCode="42100" Country="Italy" Phone="0522-556721"
Fax="0522-556722"/><customers CustomerID="RICAR" CompanyName="Ricardo
Adocicados" ContactName="Janete Limeira" ContactTitle="Assistant Sales
Agent" Address="Av. Copacabana, 267" City="Rio de Janeiro" Region="RJ"
PostalCode="02389-890" Country="Brazil" Phone="(21)
555-3412"/><customers
CustomerID="RICSU" CompanyName="Richter Supermarkt" ContactName="Michael
Holz" ContactTitle="Sales Manager" Address="Grenzacherweg 237"
City="Genève"
PostalCode="1203" Country="Switzerland" Phone="0897-034214"/><customers
CustomerID="ROMEY" CompanyName="Romero y tomillo" ContactName="Alejandra
Camino" ContactTitle="Accounting Manager" Address="Gran Vía, 1"
City="Madrid" PostalCode="28001" Country="Spain" Phone="(91) 745 6200"
Fax="(91) 745 6210"/><customers CustomerID="SANTG" CompanyName="Santé
Gourmet" ContactName="Jonas Bergulfsen" ContactTitle="Owner"
Address="Erling
Skakkes gate 78" City="Stavern" PostalCode="4110" Country="Norway"
Phone="07-98 92 35" Fax="07-98 92 47"/><customers CustomerID="SAVEA"
CompanyName="Save-a-lot Markets" ContactName="Jose Pavarotti"
ContactTitle="Sales Representative" Address="187 Suffolk Ln."
City="Boise"
Region="ID" PostalCode="83720" Country="USA" Phone="(208)
555-8097"/><customers CustomerID="SEVES" CompanyName="Seven Seas
Imports"
ContactName="Hari Kumar" ContactTitle="Sales Manager" Address="90
Wadhurst
Rd." City="London" PostalCode="OX15 4NB" Country="UK" Phone="(171)
555-1717"
Fax="(171) 555-5646"/><customers CustomerID="SIMOB" CompanyName="Simons
bistro" ContactName="Jytte Petersen" ContactTitle="Owner"
Address="Vinbæltet
34" City="Kobenhavn" PostalCode="1734" Country="Denmark" Phone="31 12 34
56"
Fax="31 13 35 57"/><customers CustomerID="SPECD"
CompanyName="Spécialités du
monde" ContactName="Dominique Perrier" ContactTitle="Marketing Manager"
Address="25, rue Lauriston" City="Paris" PostalCode="75016"
Country="France"
Phone="(1</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>) 47.55.60.10" Fax="(1)
47.55.60.20"/><customers CustomerID="SPLIR" CompanyName="Split Rail Beer
&amp; Ale" ContactName="Art Braunschweiger" ContactTitle="Sales Manager"
Address="P.O. Box 555" City="Lander" Region="WY" PostalCode="82520"
Country="USA" Phone="(307) 555-4680" Fax="(307) 555-6525"/><customers
CustomerID="SUPRD" CompanyName="Suprêmes délices" ContactName="Pascale
Cartrain" ContactTitle="Accounting Manager" Address="Boulevard Tirou,
255"
City="Charleroi" PostalCode="B-6000" Country="Belgium" Phone="(071) 23
67 22
20" Fax="(071) 23 67 22 21"/><customers CustomerID="THEBI"
CompanyName="The
Big Cheese" ContactName="Liz Nixon" ContactTitle="Marketing Manager"
Address="89 Jefferson Way Suite 2" City="Portland" Region="OR"
PostalCode="97201" Country="USA" Phone="(503) 555-3612"/><customers
CustomerID="THECR" CompanyName="The Cracker Box" ContactName="Liu Wong"
ContactTitle="Marketing Assistant" Address="55 Grizzly Peak Rd."
City="Butte" Region="MT" PostalCode="59801" Country="USA" Phone="(406)
555-5834" Fax="(406) 555-8083"/><customers CustomerID="TOMSP"
CompanyName="Toms Spezialitäten" ContactName="Karin Josephs"
ContactTitle="Marketing Manager" Address="Luisenstr. 48" City="Münster"
PostalCode="44087" Country="Germany" Phone="0251-031259"
Fax="0251-035695"/><customers CustomerID="TORTU" CompanyName="Tortuga
Restaurante" ContactName="Miguel Angel Paolino" ContactTitle="Owner"
Address="Avda. Azteca 123" City="México D.F." PostalCode="05033"
Country="Mexico" Phone="(5) 555-2933"/><customers CustomerID="TRADH"
CompanyName="Tradição Hipermercados" ContactName="Anabela Domingues"
ContactTitle="Sales Representative" Address="Av. Inês de Castro, 414"
City="Sao Paulo" Region="SP" PostalCode="05634-030" Country="Brazil"
Phone="(11) 555-2167" Fax="(11) 555-2168"/><customers CustomerID="TRAIH"
CompanyName="Trail&apos;s Head Gourmet Provisioners"
ContactName="Helvetius
Nagy" ContactTitle="Sales Associate" Address="722 DaVinci Blvd."
City="Kirkland" Region="WA" PostalCode="98034" Country="USA"
Phone="(20</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>6) 555-8257" Fax="(206)
555-2174"/><customers CustomerID="VAFFE" CompanyName="Vaffeljernet"
ContactName="Palle Ibsen" ContactTitle="Sales Manager"
Address="Smagsloget
45" City="Århus" PostalCode="8200" Country="Denmark" Phone="86 21 32 43"
Fax="86 22 33 44"/><customers CustomerID="VICTE"
CompanyName="Victuailles en
stock" ContactName="Mary Saveley" ContactTitle="Sales Agent" Address="2,
rue
du Commerce" City="Lyon" PostalCode="69004" Country="France"
Phone="78.32.54.86" Fax="78.32.54.87"/><customers CustomerID="VINET"
CompanyName="Vins et alcools Chevalier" ContactName="Paul Henriot"
ContactTitle="Accounting Manager" Address="59 rue de l&apos;Abbaye"
City="Reims" PostalCode="51100" Country="France" Phone="26.47.15.10"
Fax="26.47.15.11"/><customers CustomerID="WANDK" CompanyName="Die
Wandernde
Kuh" ContactName="Rita Müller" ContactTitle="Sales Representative"
Address="Adenauerallee 900" City="Stuttgart" PostalCode="70563"
Country="Germany" Phone="0711-020361" Fax="0711-035428"/><customers
CustomerID="WARTH" CompanyName="Wartian Herkku" ContactName="Pirkko
Koskitalo" ContactTitle="Accounting Manager" Address="Torikatu 38"
City="Oulu" PostalCode="90110" Country="Finland" Phone="981-443655"
Fax="981-443655"/><customers CustomerID="WELLI" CompanyName="Wellington
Importadora" ContactName="Paula Parente" ContactTitle="Sales Manager"
Address="Rua do Mercado, 12" City="Resende" Region="SP"
PostalCode="08737-363" Country="Brazil" Phone="(14)
555-8122"/><customers
CustomerID="WHITC" CompanyName="White Clover Markets" ContactName="Karl
Jablonski" ContactTitle="Owner" Address="305 - 14th Ave. S. Suite 3B"
City="Seattle" Region="WA" PostalCode="98128" Country="USA" Phone="(206)
555-4112" Fax="(206) 555-4115"/><customers CustomerID="WILMK"
CompanyName="Wilman Kala" ContactName="Matti Karttunen"
ContactTitle="Owner/Marketing Assistant" Address="Keskuskatu 45"
City="Helsinki" PostalCode="21240" Country="Finland" Phone="90-224 8858"
Fax="90-224 8858"/><customers CustomerID="WOLZA" CompanyName="Wolski
Zajazd"
Contac</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
- <Table>
<XML_F52E2B61-18A1-11d1-B105-00805F49916B>tName="Zbyszek
Piestrzeniewicz"
ContactTitle="Owner" Address="ul. Filtrowa 68" City="Warszawa"
PostalCode="01-012" Country="Poland" Phone="(26) 642-7012" Fax="(26)
642-7012"/></XML_F52E2B61-18A1-11d1-B105-00805F49916B>
</Table>
</NewDataSet>




*** Sent via Developersdex http://www.develop... ***
Don't just participate in USENET...get rewarded for it!
1 Answer

(David Yuan [MS])

12/31/2002 8:56:00 AM

0

Your code looks fine. I tested it reading some XML file, and it works fine.
By the way I am creating the XML with the code below:

string mypath;
mypath = "c:\\dd.xml";
DataSet dsdata = new DataSet();
SqlConnection con = new SqlConnection("Persist Security Info=True;User
ID=sa;pwd=MyPass;Initial Catalog=Northwind;Data Source=MyServer");
SqlCommand cmd = new SqlCommand("select top 20 * from orders", con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dsdata);
System.IO.FileStream fsWriteXml = new System.IO.FileStream (mypath,
System.IO.FileMode.CreateNew,FileAccess.ReadWrite);
StreamWriter wt = new StreamWriter(fsWriteXml);
dsdata.WriteXml(wt);
wt.Close();

David Yuan [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Got .Net? http://www.gotdotnet....