CODEWITHSUNDEEP
c#web-servicessoapcomboboxwsdl
Salman Mushtaq
Salman Mushtaq

Reputation: 341

Fill ComboBox with WSDL WebService

I use this web service http://www.webservicex.com/globalweather.asmx?WSDL to get all cities name by country name. I use below code to get response

GlobalWeatherReference.GlobalWeatherSoapClient weather = new GlobalWeatherReference.GlobalWeatherSoapClient("GlobalWeatherSoap12");
            cities_cb.DataSource = weather.GetCitiesByCountry("Chad").ToList();

This returns 

string

<NewDataSet>
  <Table>
    <Country>Chad</Country>
    <City>Sarh</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Abeche</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Moundou</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Ndjamena</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Bokoro</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Bol-Berim</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Am-Timan</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Pala</City>
  </Table>
  <Table>
    <Country>Chad</Country>
    <City>Faya</City>
  </Table>
</NewDataSet>

Now I need to fill combo box by cities name. Please help.

Upvotes: 0

Views: 417

Answers (2)

Z.R.T.
Z.R.T.

Reputation: 1603

you can generate C# classes based on XML Schema , for example using this web resource : http://xmltocsharp.azurewebsites.net/ after you get these classes :

[XmlRoot(ElementName = "Table")]
public class Table
{
    [XmlElement(ElementName = "Country")]
    public string Country { get; set; }
    [XmlElement(ElementName = "City")]
    public string City { get; set; }
}

[XmlRoot(ElementName = "NewDataSet")]
public class NewDataSet
{
    [XmlElement(ElementName = "Table")]
    public List<Table> Table { get; set; }
}

then you need to deserialize response from WS using type of NewDataSet

        GlobalWeatherSoapClient gwsc = new GlobalWeatherSoapClient("GlobalWeatherSoap12");
        var response = gwsc.GetCitiesByCountry("Chad");
        XmlSerializer xmlSerializer = new XmlSerializer(typeof(NewDataSet));
        var dataSet = xmlSerializer.Deserialize(new MemoryStream(Encoding.UTF8.GetBytes(response))) as NewDataSet;
        if (dataSet != null)
        {
            var cities = dataSet.Table.Select(x => x.City).ToList();
        }

Upvotes: 1

Sajeetharan
Sajeetharan

Reputation: 222692

You need to get the response and use StringReader as below,

List<string> cityNames = new List<string>();
GlobalWeatherReference.GlobalWeatherSoapClient client = new GlobalWeatherReference.GlobalWeatherSoapClient("GlobalWeatherSoap12");
var allCountryCities = client.GetCitiesByCountry("Chad");
if (allCountryCities.ToString() == "Data Not Found")
{

}
DataSet ds = new DataSet();
//Creating a stringReader object with Xml Data
StringReader stringReader = new StringReader(allCountryCities);
// Xml Data is read and stored in the DataSet object
ds.ReadXml(stringReader);
//Adding all city names to the List objects
foreach (DataRow item in ds.Tables[0].Rows)
{
    cityNames.Add(item["City"].ToString());
}    
cities_cb.DataSource = cityNames;

Upvotes: 2

Related Questions