SOAP mysql

Hi i need some help getting data from a remote server. I have been given a sample code in C# and password but i am unable to get the data. I need this urgently and am willing to pay for the service. letter and sample code below ###################### Hello, I am sending sample of code presenting how to use our web service. To use it you'd have to give your credentials plus the usercode, which is XXXXXXX for you. Direct address to registration number lookup service is [login to view URL] If you have any troubles with the usage, please let me know. Kind regards, Maj using System; using [login to view URL]; using [login to view URL]; using [login to view URL]; namespace SupplierPubUsageExample { class Program { static private string sUsername = "username"; static string sPassword = "password"; static int iLastRefNum = 0; //static string wsUrl = "http://localhost:3906/1stChoiceServices/[login to view URL]"; static string wsUrl = "[login to view URL]"; static void Main(string[] args) { //GetOrders(sUsername, sPassword, iLastRefNum); MakeQuote(sUsername, sPassword); } static void GetOrders(string Username, string Password, int LastRefNum) { string ReturnString = ""; [login to view URL] ws = new [login to view URL](); [login to view URL] = wsUrl; ReturnString = [login to view URL](Username, Password, LastRefNum); List lOrders = ParseGetOrdersResult(ReturnString); } private class PartDetails { public string pid; public string pdsc; public string pcmt; public PartDetails(string pid, string pdsc, string pcmt) { [login to view URL] = pid; [login to view URL] = pdsc; [login to view URL] = pcmt; } } private class OrderDetails { public string rfno; public string date; public string cdes; public string cmak; public string cran; public string cyer; public string cbdy; public string cbdt; public string cgbx; public string cfue; public string cvin; public string cenn; public string cccs; public string cclr; public string creg; public string unam; public string uloc; public string upos; public string uphn; public string umob; public string ueml; public List lParts = new List(); } static List ParseGetOrdersResult(string ReturnString) { List lRet = new List(); XmlDocument document = new XmlDocument(); try { ReturnString = [login to view URL]("&", "&"); [login to view URL](ReturnString); XmlNode root = [login to view URL]; XmlNodeList xmlOrders = [login to view URL]("descendant::rq"); foreach (XmlNode order in xmlOrders) { [login to view URL](ParseOrderXML(order)); } } catch (Exception ex) { string str = [login to view URL]; //return error } return lRet; } static OrderDetails ParseOrderXML(XmlNode xmlOrder) { OrderDetails oRet = new OrderDetails(); XmlNode xmlOrDet01 = [login to view URL]("descendant::rfno"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet02 = [login to view URL]("descendant::date"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet03 = [login to view URL]("descendant::cdes"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet04 = [login to view URL]("descendant::cmak"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet05 = [login to view URL]("descendant::cran"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet06 = [login to view URL]("descendant::cyer"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet07 = [login to view URL]("descendant::cbdy"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet08 = [login to view URL]("descendant::cbdt"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet09 = [login to view URL]("descendant::cgbx"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet10 = [login to view URL]("descendant::cfue"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet11 = [login to view URL]("descendant::cvin"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet12 = [login to view URL]("descendant::cenn"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet13 = [login to view URL]("descendant::cccs"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet14 = [login to view URL]("descendant::cclr"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet15 = [login to view URL]("descendant::creg"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet16 = [login to view URL]("descendant::unam"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet17 = [login to view URL]("descendant::uloc"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet18 = [login to view URL]("descendant::upos"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet19 = [login to view URL]("descendant::uphn"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet20 = [login to view URL]("descendant::umob"); [login to view URL] = [login to view URL]; XmlNode xmlOrDet21 = [login to view URL]("descendant::ueml"); [login to view URL] = [login to view URL]; XmlNodeList xmlParts = [login to view URL]("descendant::part"); foreach (XmlNode xmlPart in xmlParts) { XmlNode xmlOrDet22 = [login to view URL]("descendant::pid"); XmlNode xmlOrDet23 = [login to view URL]("descendant::pdsc"); XmlNode xmlOrDet24 = [login to view URL]("descendant::pcmt"); [login to view URL](new PartDetails([login to view URL], [login to view URL], [login to view URL])); } return oRet; } static void MakeQuote(string Username, string Password) { string request = ""; string ReturnString = ""; [login to view URL] ws = new [login to view URL](); [login to view URL] = wsUrl; ; ReturnString = [login to view URL](Username, Password, request); } } }