[WebMethod]
public XmlDataDocument GetPersonAddress(string cityNameID)
{
//
// 定义一些变量
//   
   StringBuilder   myQuery           = new StringBuilder();
XmlDataDocument resultXMLDocument = new XmlDataDocument();
SqlConnection   myConnection      = new SqlConnection();
SqlCommand      myCommand         = new SqlCommand();
SqlDataAdapter  myDA              = new SqlDataAdapter();
DataSet         myDS              = new DataSet();
//
// 根据参数的不同准备不同的查询语句
//   
   if ((cityNameID != null) && (cityNameID.Trim() != ""))
{
myQuery.Append("Select City as City, " +
"AddressLine1 as Address, " +
"PostalCode From Address ");
myQuery.Append("Where City Like '" +
cityNameID.Trim().Replace("%", "") +
"%' Order By City");
}
else
{
myQuery.Append("Select City as City, AddressLine1" +
" as Address, PostalCode From Address" +
" Order By City");
}
//
// 得到连接字符串并建立到服务器的连接
//   
   myConnection.ConnectionString = ReadSetting("ConnectionString", "");
myCommand.Connection          = myConnection;
myCommand.CommandText         = myQuery.ToString();
myCommand.CommandType         = CommandType.Text;
myDA.SelectCommand            = myCommand;
//
// 返回一个DataSet数据
//   
   try
{
myDA.Fill(myDS, "Address");
//
// 转换我们的DataSet到XmlDataDocument
//
      XmlDataDocument temporaryXMLDoc = new XmlDataDocument(myDS);
resultXMLDocument = temporaryXMLDoc;
temporaryXMLDoc = null;
}
catch
{
resultXMLDocument = null;
}
finally
{
myDS.Dispose();
myDA.Dispose();
myCommand.Dispose();
myConnection.Dispose();
myQuery = null;
}
return resultXMLDocument;
}