C#

d@nish wrote:

If it is a small application dealing with less amount of data, XML files or MS Access could do. Or else, SQL Express should be installed on those computers.

If all the computers are on internet, you can connect to SQL server over internet also. Check that out.

DataSet t = new DataSet();
t.Tables.Add(someTable);

t.WriteXmlSchema("Filename");
t.WriteXml("Filename");


//...
//...

DataSet loaded = new DataSet();
loaded.ReadXmlSchema("Filename");
loaded.ReadXml("Filename");

XElement element = Results.Elements("NewDataSet").Element("Table");
string city = element.Element("CITY").Value;
string state = element.Element("STATE").Value;
... blah blah

XDocument doc = XDocument.Load(ws.GetInfoByZIP(txtZip.Text).ToString());

private void btnZipWS_Click(object sender, EventArgs e)
        {
                        
            Bank.net.webservicex.www.USZip ws = new Bank.net.webservicex.www.USZip();

           
            XDocument doc = XDocument.Load(ws.GetInfoByZIP(txtZip.Text).ToString());
                     XElement element = Results.Elements("NewDataSet").Element("Table"); 
            string city = element.Element("CITY").Value; 
            string state = element.Element("STATE").Value;

XDocument doc = XDocument.Parse(textZip.Text);

XDocument doc = XDocument.Parse(ws.GetInfoByZIP(txtZip.Text).ToString());

Bank.net.webservicex.www.USZip ws = new Bank.net.webservicex.www.USZip();


           XmlNode cityNode = ws.GetInfoByZIP(txtZip.Text);

           string cityName = "UNKNOWN";
           string stateName = "UNKNOWN";
           foreach (XmlNode node in cityNode)
           {
               foreach (XmlElement elem in node)
               {
                   if (elem != null && elem.Name.Equals("CITY"))
                   {
                       cityName = elem.FirstChild.InnerText;
                   }
                   if (elem != null && elem.Name.Equals("STATE"))
                   {
                       stateName = elem.FirstChild.InnerText;
                   }
               }
           }
           txtCity.Text = cityName;
           txtState.Text = stateName;