[WebMethod(Description="這是一個WebService方法")] public XmlDataDocument GetSiteAData(string AssignName) { XmlDataDocument xd=new XmlDataDocument(); // DataSet ds=new DataSet(); CStoreProc cp=new CStoreProc("SearchAssign"); cp.AddParIn("@keywords",SqlDbType.VarChar,30,AssignName); cp.AddParOut("@res",SqlDbType.Int); if(cp.SelectProc()) //如果執行成功,預存程序 { cp.myData.EnforceConstraints=false; //不進行格式嚴格檢查 if((int)cp.GetReturnValue("@res")==-1) { string xml="<NewDataSet></NewDataSet>"; xd.LoadXml(xml); return xd; } xd=new XmlDataDocument(cp.myData); XmlNode root1=xd.DocumentElement; XmlNodeList roots=root1.SelectNodes("list"); foreach(XmlNode roota in roots) //為所有元素加上網站名稱標記 { XmlElement Link=xd.CreateElement("SiteName"); Link.InnerText=ConfigurationSettings.AppSettings["SiteName"].ToString(); roota.AppendChild(Link); } return xd; } else return null; }