Interaktif SMS Api

      if (!IsPostBack)
        {
            WebClient wc = new WebClient();
            string url = "http://api.smcollector.com/xmlapi.aspx";
            string XML = "<SMCollectorMain>";
            XML += " <UserName>----</UserName> ";
            XML += " <PassWord>-----</PassWord> ";
            XML += " <Action>0</Action> ";
            XML += " <List>ALL</List> ";
            XML += " </SMCollectorMain> ";

            byte[] buffer = Encoding.UTF8.GetBytes(XML);
            byte[] returnBuffer = wc.UploadData(url, buffer);

            string returnString = Encoding.UTF8.GetString(returnBuffer);

            XmlDocument document = new XmlDocument();
            document.LoadXml(returnString);
            XmlNodeList nodeList = document.SelectNodes("//row");

                OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("GelenSMS.accdb"));
                con.Open();
            foreach (XmlNode item in nodeList)
             {
                string id = item.SelectSingleNode("//id").InnerText;
                string msgDate = item.SelectSingleNode("//msgdate").InnerText;
                string msgbody = item.SelectSingleNode("//msgbody").InnerText;
                string gsmno = item.SelectSingleNode("//gsmno").InnerText;
                string status = item.SelectSingleNode("//status").InnerText;

                string kaydet = "insert into GelenSMS (id,msgDate,msgbody,gsmno,status) values('" + id + "','" + msgDate + "','" + msgbody + "','" + gsmno + "','" + status + "')";

                OleDbCommand cmdsay = new OleDbCommand(kaydet, con);

                cmdsay.ExecuteNonQuery();

                cmdsay.Dispose();  

            } 

        con.Close();

        }

      if (!IsPostBack)
        {
            WebClient wc = new WebClient();
            string url = "http://api.smcollector.com/xmlapi.aspx";
            string XML = "<SMCollectorMain>";
            XML += " <UserName>----</UserName> ";
            XML += " <PassWord>-----</PassWord> ";
            XML += " <Action>0</Action> ";
            XML += " <List>ALL</List> ";
            XML += " </SMCollectorMain> ";

            byte[] buffer = Encoding.UTF8.GetBytes(XML);
            byte[] returnBuffer = wc.UploadData(url, buffer);

            string returnString = Encoding.UTF8.GetString(returnBuffer);

            XmlDocument document = new XmlDocument();
            document.LoadXml(returnString);
            XmlNodeList nodeList = document.SelectNodes("//row");

                OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("GelenSMS.accdb"));
                con.Open();
            foreach (XmlNode item in nodeList)
             {
                string id = item.SelectSingleNode("//id").InnerText;
                string msgDate = item.SelectSingleNode("//msgdate").InnerText;
                string msgbody = item.SelectSingleNode("//msgbody").InnerText;
                string gsmno = item.SelectSingleNode("//gsmno").InnerText;
                string status = item.SelectSingleNode("//status").InnerText;

                string kaydet = "insert into GelenSMS (id,msgDate,msgbody,gsmno,status) values('" + id + "','" + msgDate + "','" + msgbody + "','" + gsmno + "','" + status + "')";
                OleDbCommand cmdsay = new OleDbCommand(kaydet, con);
                cmdsay.ExecuteNonQuery();
                cmdsay.Dispose();  
            } 
        con.Close();
        }

if (returnString.Substring(0, 3) != "err" && returnString!= "ok 08")
{
       StringReader strread = new StringReader(returnString);
       XmlDocument xmldoc = new XmlDocument();
       xmldoc.Load(strread);

       XmlNodeList ID = xmldoc.SelectNodes("/resultset/row/id");
       XmlNodeList MSGDATE = xmldoc.SelectNodes("/resultset/row/msgdate");
       XmlNodeList MSGBODY = xmldoc.SelectNodes("/resultset/row/msgbody");
       XmlNodeList GSMNO = xmldoc.SelectNodes("/resultset/row/gsmno");
       XmlNodeList STATUS = xmldoc.SelectNodes("/resultset/row/status");

       for (int i = 0; i < ID.Count; i++)
       {
ID.Item(i).InnerText.ToString();
MSGDATE.Item(i).InnerText.ToString();
MSGBODY.Item(i).InnerText.ToString();
GSMNO.Item(i).InnerText.ToString();
STATUS.Item(i).InnerText.ToString();
       }
}