Connect Windows Store Apps to SQL Server Database Using WCF

return Emplist;

}

}

}

Step 6

After doing that, run WCF services and copy to the services URL.

Step 7

Now open Visual Studio 2012 in a new window and start a new "Windows Store apps" project.

Step 8

In this step, add a service reference. To do that right-click on the project and in Solution Explorer and select "Add Service Reference". Paste the Service URL and click on "Go". After finding the service click on "OK".

Step 9

Go to Solution Explorer and double-click on "MainPage.xaml". Your "MainPage.xaml" page is as in the following code:

<Page

x:Class="WindowsStoreToSql.MainPage"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:local="using:WindowsStoreToSql"

xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

mc:Ignorable="d">

<Grid Background="{StaticResource ApplicationPageBackgroundThemeBrush}" RenderTransformOrigin="0.508,0.484">

<TextBox HorizontalAlignment="Left" x:Name="IdTextbox" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Margin="352,249,0,0" Width="246"/>

<TextBox HorizontalAlignment="Left" x:Name="NameTextbox" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Margin="352,303,0,0" Width="246"/>

<TextBox HorizontalAlignment="Left" x:Name="AddTextBox" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Margin="352,358,0,0" Width="246"/>

<Button Content="ShowData" x:Name="ShowData" HorizontalAlignment="Left" VerticalAlignment="Top" Margin="496,422,0,0" Click="ShowData_Click"/>

<Button Content="InsertData" x:Name="InsertData" HorizontalAlignment="Left" VerticalAlignment="Top" Margin="352,422,0,0" Click="InsertData_Click"/>

<GridView HorizontalAlignment="Left" x:Name="EmpGridview" VerticalAlignment="Top" Width="150" Margin="646,162,0,0" />

</Grid>

</Page>

Step 10

Your "MainPage.xaml.cs" page is as in the following code:

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using Windows.Foundation;

using Windows.Foundation.Collections;

using Windows.UI.Xaml;

using Windows.UI.Xaml.Controls;

using Windows.UI.Xaml.Controls.Primitives;

using Windows.UI.Xaml.Data;

using Windows.UI.Xaml.Input;

using Windows.UI.Xaml.Media;

using Windows.UI.Xaml.Navigation;

using Windows.UI.Popups;

namespace WindowsStoreToSql

{

public sealed partial class MainPage : Page

{

ServiceReference1.Service1Client MyService;

public MainPage()

{

this.InitializeComponent();

}

protected override void OnNavigatedTo(NavigationEventArgs e)

{

MyService = new ServiceReference1.Service1Client();

}

private async void InsertData_Click(object sender, RoutedEventArgs e)

{

await MyService.InsertEmployeeAsync(new ServiceReference1.Employee { EmpId = IdTextbox.Text, EmpName = NameTextbox.Text, EmpAddress = AddTextBox.Text });

}

private async void ShowData_Click(object sender, RoutedEventArgs e)

{

var EmpList = await MyService.GetEmployeeAsync();

foreach (var Emp in EmpList)

{

GridViewItem EmpView = new GridViewItem();

StackPanel Spanel = new StackPanel();

Spanel.Children.Add(new TextBlock() { Text = Emp.EmpId });

Spanel.Children.Add(new TextBox() { Text = Emp.EmpName });

Spanel.Children.Add(new TextBlock() { Text = Emp.EmpAddress });

EmpView.Content = Spanel;

EmpGridview.Items.Add(EmpView);

}

}

}

}

Step 11

Now run project. Click on "ShowData" to show your table data and click on "InsertData" to insert data into the table.