ตอนที่ 7 : Show Case 3 : Update Data (iOS C# (Xamarin.iOS) and Mobile Services)

            client = new MobileServiceClient(ApplicationURL, ApplicationKey);

            memberTable = client.GetTable<MyMember>();

            //*** Get Data Info ***//
            var info = memberTable.Where(item => item.Username == strUsername).ToCollectionAsync();
            if (info.Count > 0)
            {
                MyMember member = info[0];
                txtUsername.Text = member.Username.ToString();
                txtPassword.Text = member.Password.ToString();
                txtName.Text = member.Name.ToString();
                txtEmail.Text = member.Email.ToString();
                txtTel.Text = member.Tel.ToString();
            }

                client = new MobileServiceClient(ApplicationURL, ApplicationKey);
                memberTable = client.GetTable<MyMember>();

                //*** Get Data for Update ***//
                var update = memberTable.Where(item => item.Username == strUsername).ToCollectionAsync();

                if (update.Count > 0)
                {
                    MyMember member = update[0];
                    member.Name = txtName.Text;
                    member.Password = txtPassword.Text;
                    member.Name = txtName.Text;
                    member.Email = txtEmail.Text;
                    member.Tel = txtTel.Text;

                    //*** Update Record ***/
                    memberTable.UpdateAsync(member);
                    new UIAlertView("Result", "Update Data Successfully.", null, "OK", null).Show();
                }

using System;
using System.Drawing;
using System.Collections.Generic;

using MonoTouch.Foundation;
using MonoTouch.UIKit;

using Microsoft.WindowsAzure.MobileServices;
using Newtonsoft.Json;

namespace iOSApp
{

    public class MyMember
    {
        public int Id { get; set; }

        [JsonProperty(PropertyName = "username")]
        public string Username { get; set; }

        [JsonProperty(PropertyName = "password")]
        public string Password { get; set; }

        [JsonProperty(PropertyName = "name")]
        public string Name { get; set; }

        [JsonProperty(PropertyName = "email")]
        public string Email { get; set; }

        [JsonProperty(PropertyName = "tel")]
        public string Tel { get; set; }
    }

    public partial class RootViewController : UIViewController
    {

        public const string ApplicationURL = @"https://thaicreate.azure-mobile.net/";
        public const string ApplicationKey = @"IqeWShAjBflTUrTaaGUNJRyZDpcyeh72";

        private MobileServiceClient client; // Mobile Service Client references
        private IMobileServiceTable<MyMember> memberTable; // Mobile Service Table used to access data  

        string strUsername = "surachai";

        public RootViewController(IntPtr handle)
            : base(handle)
        {
        }

        public override void ViewDidLoad()
        {
            base.ViewDidLoad();

            this.LoadInfo();
        }

        public override void DidReceiveMemoryWarning()
        {
            // Releases the view if it doesn't have a superview.
            base.DidReceiveMemoryWarning();
        }

        private void LoadInfo()
        {
            client = new MobileServiceClient(ApplicationURL, ApplicationKey);

            memberTable = client.GetTable<MyMember>();

            //*** Get Data Info ***//
            var info = memberTable.Where(item => item.Username == strUsername).ToCollectionAsync();
            if (info.Count > 0)
            {
                MyMember member = info[0];
                txtUsername.Text = member.Username.ToString();
                txtPassword.Text = member.Password.ToString();
                txtName.Text = member.Name.ToString();
                txtEmail.Text = member.Email.ToString();
                txtTel.Text = member.Tel.ToString();
            }

        }

        partial void btnSave_TouchUpInside(UIButton sender)
        {
            try
            {
                client = new MobileServiceClient(ApplicationURL, ApplicationKey);
                memberTable = client.GetTable<MyMember>();

                //*** Get Data for Update ***//
                var update = memberTable.Where(item => item.Username == strUsername).ToCollectionAsync();

                if (update.Count > 0)
                {
                    MyMember member = update[0];
                    member.Name = txtName.Text;
                    member.Password = txtPassword.Text;
                    member.Name = txtName.Text;
                    member.Email = txtEmail.Text;
                    member.Tel = txtTel.Text;

                    //*** Update Record ***/
                    memberTable.UpdateAsync(member);
                    new UIAlertView("Result", "Update Data Successfully.", null, "OK", null).Show();
                }
            }
            catch (Exception ex)
            {
                new UIAlertView("Result", "Error : " + ex.Message, null, "OK", null).Show();
            }

        }

    }

}

 string strUsername = "surachai";