Example 6 : Windows Store App and Register Data (Web Services) - C#

CREATE TABLE `member` (
  `MemberID` int(2) NOT NULL auto_increment,
  `Username` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Tel` varchar(50) NOT NULL,
  `Email` varchar(150) NOT NULL,
  PRIMARY KEY  (`MemberID`),
  UNIQUE KEY `Username` (`Username`),
  UNIQUE KEY `Email` (`Email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


INSERT INTO `member` VALUES (1, 'weerachai', 'weerachai@1', 'Weerachai Nukitram', '0819876107', '[email protected]');
INSERT INTO `member` VALUES (2, 'adisorn', 'adisorn@2', 'Adisorn Bunsong', '021978032', '[email protected]');
INSERT INTO `member` VALUES (3, 'surachai', 'surachai@3', 'Surachai Sirisart', '0876543210', '[email protected]');

using System.Data;
using Newtonsoft.Json;
using MySql.Data.MySqlClient;

        [WebMethod]
        public string AddData(string sUsername,
            string sPassword,
            string sName,
            string sTel,
            string sEmail)
        {

            try
            {
                MySqlConnection objConn = new MySqlConnection();
                MySqlCommand objCmd = new MySqlCommand();

                String strConnString, strSQL;

                strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false";

                objConn.ConnectionString = strConnString;
                objConn.Open();

                strSQL = "INSERT INTO member (Username,Password,Name,Tel,Email) VALUES " +
                " ('" + sUsername + "' " +
                " ,'" + sPassword + "' " +
                " ,'" + sName + "' " +
                " ,'" + sTel + "' " +
                " ,'" + sEmail + "') ";

                objCmd = new MySqlCommand();
                objCmd.Connection = objConn;
                objCmd.CommandText = strSQL;
                objCmd.CommandType = CommandType.Text;
                objCmd.ExecuteNonQuery();

                return "1"; // return sccess.

            }
            catch (Exception ex)
            {
                return "0"; // return failed.
            }
        }

            var client = new myWebServices.myWSVSoapClient();
            var result = await client.AddDataAsync(this.txtUsername.Text, 
                this.txtPassword.Text,
                this.txtName.Text,
                this.txtTel.Text,
                this.txtEmail.Text);

            string jsonData = result.Body.AddDataResult;

            if (jsonData == "0")
            {
                MessageDialog msgDialog = new MessageDialog("Username or Password Incorrect!", "Error");
                await msgDialog.ShowAsync();
            }
            else
            {
                MessageDialog msgDialog = new MessageDialog("Register Data Success.", "Success");
                await msgDialog.ShowAsync();
            }

<Page
    x:Class="WindowsStoreApps.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:local="using:WindowsStoreApps"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d">


    <Grid Background="{ThemeResource ApplicationPageBackgroundThemeBrush}">

        <TextBlock HorizontalAlignment="Left" Margin="524,98,0,0" TextWrapping="Wrap" Text="Register Form" VerticalAlignment="Top" FontSize="25"/>

        <TextBlock HorizontalAlignment="Left" Margin="362,182,0,0" TextWrapping="Wrap" Text="Username :" VerticalAlignment="Top" FontSize="20"/>
        <TextBox x:Name="txtUsername" HorizontalAlignment="Left" Height="36" Margin="667,176,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="319" FontSize="20" FontFamily="Global User Interface"/>

        <TextBlock HorizontalAlignment="Left" Margin="362,237,0,0" TextWrapping="Wrap" Text="Password :" VerticalAlignment="Top" FontSize="20"/>
        <TextBox x:Name="txtPassword" HorizontalAlignment="Left" Height="36" Margin="667,235,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="326" FontSize="20" FontFamily="Global User Interface"/>

        <TextBlock HorizontalAlignment="Left" Margin="362,303,0,0" TextWrapping="Wrap" Text="Name :" VerticalAlignment="Top" FontSize="20"/>
        <TextBox x:Name="txtName" HorizontalAlignment="Left" Height="36" Margin="667,299,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="326" FontSize="20" FontFamily="Global User Interface"/>

        <TextBlock HorizontalAlignment="Left" Margin="362,369,0,0" TextWrapping="Wrap" Text="Tel :" VerticalAlignment="Top" FontSize="20"/>
        <TextBox x:Name="txtTel" HorizontalAlignment="Left" Height="36" Margin="667,365,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="326" FontSize="20" FontFamily="Global User Interface"/>

        <TextBlock HorizontalAlignment="Left" Margin="364,433,0,0" TextWrapping="Wrap" Text="Email :" VerticalAlignment="Top" FontSize="20"/>
        <TextBox x:Name="txtEmail" HorizontalAlignment="Left" Height="36" Margin="669,434,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="326" FontSize="20" FontFamily="Global User Interface"/>

        <Button x:Name="btnSave" Content="Save" HorizontalAlignment="Left" Margin="554,522,0,0" VerticalAlignment="Top" FontSize="20" Width="120" FontFamily="Global User Interface" Click="btnSave_Click"/>


    </Grid>

</Page>