I have the following webservice which i downloaded and saved as xml file , i bind it with my gridview . how do i display all Data as column in my gridview? Following is my databinding code:
- XmlReader myxmlFile = XmlReader.Create("C:/test.xml", new XmlReaderSettings());
-
- DataSet dss = new DataSet();
- DataTable dt = new DataTable();
-
- dss.ReadXml(myxmlFile);
-
- GridView1.DataSource = dss.Tables["Attribute"];
-
- GridView1.DataBind();
- <?xml version="1.0" encoding="utf-8"?>
- <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <soap:Body>
- <SingletonCD xmlns="mywebservice">
- <SingletonCR>
- <TS>OK</TS>
- <ErrorCode>0</ErrorCode>
- <ErrorDescription />
- <WebserviceContent>
- <data xmlns="">
- <AS xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <Singleton>
- <N1>000000000000</N1>
- <MI>40000000000000</MI>
- <TS>OK</TS>
- <Gr>Neull</Gr>
- <Ad>
- <Attribute Name="N" Group="AB">NATIVE</Attribute>
- <Attribute Name="C" Group="AB">JUIIN</Attribute>
- <Attribute Name="T " Group="AB">9.00</Attribute>
- <Attribute Name="P 1" Group="AB">GHD67</Attribute>
- <Attribute Name="P 2" Group="AB">GH678</Attribute>
- <Attribute Name="C" Group="AB">EXXA</Attribute>
- <Attribute Name="T" Group="AB">MaH</Attribute>
- <Attribute Name="P" Group="AB">0.00</Attribute>
- <Attribute Name="D" Group="AB">Dest name</Attribute>
- <Attribute Name="A" Group="AB">Agent name</Attribute>
- </Ad>
- </Singleton>
- <Singleton>
- <N1>000000000300</N1>
- <MI>40000055000000</MI>
- <TS>OK</TS>
- <Gr>NULL</Gr>
- <Ad>
- <Attribute Name="N" Group="AB">BAN</Attribute>
- <Attribute Name="C" Group="AB">SZEYDOU</Attribute>
- <Attribute Name="T " Group="AB">9U00</Attribute>
- <Attribute Name="P1" Group="AB">GD67</Attribute>
- <Attribute Name="P2" Group="AB">G678</Attribute>
- <Attribute Name="C" Group="AB">EXUA</Attribute>
- <Attribute Name="T" Group="AB">MaH</Attribute>
- <Attribute Name="P" Group="AB">0.00</Attribute>
- <Attribute Name="D" Group="AB">Dest CO</Attribute>
- <Attribute Name="A" Group="AB">Agent CO</Attribute>
- </Ad>
- </Singleton>
- </AS>
- </data>
- </WebserviceContent>
- </SingletonCR>
- </SingletonCD>
- </soap:Body>
- </soap:Envelope>