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

            client = new MobileServiceClient(ApplicationURL, ApplicationKey);

            TextView txtUsername = FindViewById<TextView>(Resource.Id.txtUsername);
            TextView txtPassword = FindViewById<TextView>(Resource.Id.txtPassword);
            TextView txtName = FindViewById<TextView>(Resource.Id.txtName);
            TextView txtEmail = FindViewById<TextView>(Resource.Id.txtEmail);
            TextView txtTel = FindViewById<TextView>(Resource.Id.txtTel);

            memberTable = client.GetTable<MyMember>();

            //*** Get Data Info ***//
            var info = await 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);

            //*** Get Data for Update ***//
            var update = await memberTable.Where(item => item.Username == strUsername).ToCollectionAsync();
            if (update.Count > 0)
            {
                TextView txtUsername = FindViewById<TextView>(Resource.Id.txtUsername);
                TextView txtPassword = FindViewById<TextView>(Resource.Id.txtPassword);
                TextView txtName = FindViewById<TextView>(Resource.Id.txtName);
                TextView txtEmail = FindViewById<TextView>(Resource.Id.txtEmail);
                TextView txtTel = FindViewById<TextView>(Resource.Id.txtTel);

                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 ***/
                await memberTable.UpdateAsync(member);

                AlertDialog.Builder builder = new AlertDialog.Builder(this);
                AlertDialog alert = builder.Create();
                alert.SetTitle("Result");
                alert.SetMessage("Update Data Successfully");
                alert.Show();
            }

<?xml version="1.0" encoding="utf-8"?>
<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/tableLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent">
    <TableRow
        android:id="@+id/tableRow1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content">
        <TextView
            android:id="@+id/textView1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:gravity="center"
            android:text="Update Form "
            android:layout_span="1"
            android:textAppearance="?android:attr/textAppearanceLarge" />
    </TableRow>
    <View
        android:layout_height="1dip"
        android:background="#CCCCCC" />
    <TableLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_weight="0.1"
        android:orientation="horizontal">
        <TableRow>
            <TextView
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="Username "
                android:textAppearance="?android:attr/textAppearanceMedium" />
            <TextView
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:gravity="center"
                android:text=" = " />
            <TextView
                android:id="@+id/txtUsername"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="Username" />
        </TableRow>
        <TextView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Input Password"
            android:textAppearance="?android:attr/textAppearanceMedium" />
        <EditText
            android:id="@+id/txtPassword"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:inputType="textPassword"
            android:ems="10" />
        <TextView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Input Name :"
            android:textAppearance="?android:attr/textAppearanceMedium" />
        <EditText
            android:id="@+id/txtName"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:ems="10" />
        <TextView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Input Email :"
            android:textAppearance="?android:attr/textAppearanceMedium" />
        <EditText
            android:id="@+id/txtEmail"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:inputType="textEmailAddress"
            android:ems="10" />
        <TextView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Input Tel :"
            android:textAppearance="?android:attr/textAppearanceMedium" />
        <EditText
            android:id="@+id/txtTel"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:inputType="phone"
            android:ems="10" />
        <Button
            android:id="@+id/btnSave"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Save" />
    </TableLayout>
</TableLayout>