Creating a Windows Phone 7 Application Consuming Data Using a WCF Service

Urmimala Pal

54 Comments

Join the conversation! Your thoughts help the community grow.

Suresh M12y ago
please help me how to insert data to SQL server
Nasurudeen Yasu12y ago
please do need full
- Suresh M12y ago
  hi u cannot connect the WCF service to windows phone emulator see this link
- Suresh M12y ago
  http://msdn.microsoft.com/en-us/library/windowsphone/develop/jj684580(v=vs.105).aspx
Nasurudeen Yasu12y ago
i try to this article i will get an error
Nasurudeen Yasu12y ago
An exception of type 'System.ServiceModel.CommunicationException' occurred in System.ServiceModel.ni.dll but was not handled in user code If there is a handler for this exception, the program may be safely continued.
Raj Kumar13y ago
This article will be very helful to you. http://www.c-sharpcorner.com/uploadfile/raj1979/silverlight-crud-operations-using-wcf-service/
sajid raja13y ago
can you please tell me how can i insert values to database in windowsphone 7 by using a Web services
sajid raja13y ago
Hello I want to to show some records from DB to Windows phone using WCF but issue is it is showing Only last records many times in win app. can you please tell me how can i show multiple records in multiple lines. My code is try { Service1SoapClient proxy = new Service1SoapClient(); for(int i=1; i<=10; i++) { proxy.GetAllAccountsCompleted += new EventHandler<GetAllAccountsCompletedEventArgs>(proxy_GetAllAccountsCompleted); proxy.GetAllAccountsAsync(); } //Service1Client proxy = new Service1Client(); //proxy.FindEmployeeCompleted += new EventHandler<FindEmployeeCompletedEventArgs>(proxy_FindEmployeeCompleted); // proxy.FindEmployeeAsync(); } catch { }
B-Abbasi13y ago
Thanks a lot...
Tamas14y ago
Hi! I have three table not only one, with foreign keys. How can I use this solution for an insert or an update?
Former member14y ago
I have the same problem " Hi, I can get this to run fine on the emulator but when I debug this on the windows phone device I get the following error: $exception {"There was no endpoint listening at http://localhost:3309/Service1.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details."} System.Exception {System.ServiceModel.EndpointNotFoundException}Any help much appreciated", so How can I solve it ?
- isavella chr11y ago
  hi i have the same problem .. do you solve it?
Junior De Santi14y ago
public Service1Client() KeyNotFoundException Please, how can I solve? Sorry, but I am Brazilian and I can not write English very well. I appreciate everyone's help. Thank you.
Kyle14y ago
Ok... He's clearly returning a List<T> via WCF and it's a .NET specific data type. How am I supposed to send it via WCF when it's meant to be used by other clients, not just .NET ones? The author of this article clearly overlooked that and he doesn't cover the configuration for that.
Joe Murphy14y ago
Hi, I can get this to run fine on the emulator but when I debug this on the windows phone device I get the following error: $exception {"There was no endpoint listening at http://localhost:3309/Service1.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details."} System.Exception {System.ServiceModel.EndpointNotFoundException} Any help much appreciated
Systems Administrator14y ago
Would you be able to zip the WCF and WP7 projects. I think I have then right, but keep getting a KeyNotFoundException.
John15y ago
I'm getting the following error: {"The remote server returned an error: NotFound."} at the below line of code in Reference.cs, and I'm not sure why, because I can browse to the service running...any ideas? System.Collections.ObjectModel.ObservableCollection<DataBoundApp1.ServiceReference1.Appointment> _result = ((System.Collections.ObjectModel.ObservableCollection<DataBoundApp1.ServiceReference1.Appointment>)(base.EndInvoke("SelectAllUnapproved", _args, result)));
Omar Abdulah15y ago
Hi, I have error on this line ( public Service1Client() { } ) the error say "KeyNoteFoundException" any idea what thats mean. Regards Omar
Omar Abdulah15y ago
Hi, I have error on using System.ServiceModel.Web; any idea why. Regards Omar
Chin Xiao Yuan15y ago
Test
Chin Xiao Yuan15y ago
Hey, thanks for the step by step tutorial. It works ! May I know if it is possible to show an article about retrieving image from the database and display it on WP7 ? I'm currently working on it...
tan james15y ago
For example: [OperationContract] bool Employee(string nm, stringuid)
Khairuneesha Shaik15y agoedited
Hey! I have a problem.. so instead of using a portrait page for the 'page1' i used the pivot page.. and I have an error when adding the MyClientWin7.ServiceReference1 the error: the type or namespace 'ServiceReference1' does not exist in the namespace 'MyClientWin7' (are you missing an assembly reference?) I tried MyClientWin7.ServiceReference1.ServiceReference1 as well but its still not working :( oh and yes! instead of using text blocks in the listbox, i used text box.. helpppp me pleaseee :) :) and just wanted to tell you..This is FABBBB! and you did an amazingggg job! :)))
- Khairuneesha Shaik15y ago
  Yes the service is running fine..but there are errors on the pivotpage.xaml.cs The ServiceReference1 error as well as the Service1Client... I have checked and double checked the names and everything..not sure where the error is.. but thanks alot :)
- Urmimala Pal15y ago
  Hi, I have not tried out the pivot page. But I think u can add the reference. Check out the names of the service and your client page. Are you sure the service is running fine?
GERASIMOS VONITSANOS15y ago
how can we update the textblocks in the listbox? thank you in advance
- Urmimala Pal15y ago
  Hi, The textblocks are associated with the database. If the database got changed, the textblock values will get changed. Do you need any other clarification ? I didnt get your question properly.
Marco Almeida15y ago
i having one error wend add using MyClientWin7.ServiceReference1 error: the type or namespace 'ServiceReference1' does not exist in the namespace 'MyClientWin7' (are you missing an assembly reference?) helppppp :)
- Enrique Serra15y ago
  Try MyClientWin7.ServiceReference1.ServiceReference1
wahbi tralecy15y ago
Sorry...i have a problem and i dont know why????a error KeyNotFoundException,,pplease help ;-(
Raj Kumar15y ago
hey Urmimala, I found this article very useful and very clear. Thanks alot for providing such a good article. looking more articles from you. RAJ
Tanmay Sonawane16y ago
I'm having an Issue getting the values from the database. I get 1 Warning message : "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information" Clicking on the Find button doesn't do anything. I have the service running properly. Im not able to find any solution. Any ideas?
Enrique Serra16y ago
Solved in this post http://social.msdn.microsoft.com/Forums/en-US/wcf/thread/1f52439a-7ac1-4a56-a6cb-2b21dacc1269
- Enrique Serra16y ago
  Hi Would you mind to post a ZIP with the whole MyClientWin7? I'm getting errors when I typed <phone:PhoneApplicationpage .... Do i have to add a reference? Thanks
- Enrique Serra16y ago
  Hi again How do i make this example with three database tables? How do i make this example with a stored procedure? Thanks a lot
Enrique Serra16y agoedited
I'm on a course at the moment <a href=" http://www.joomx.com ">neurontin 100mg price</a> (462-EV) field must contain the eleven-digit Prior Approval number. If reporting
- Enrique Serra16y ago
  Hi I have translated the c# code to Vb SERVICE1.svc.vb Imports System.Collections.Generic Imports System.Linq Imports System.Runtime.Serialization Imports System.ServiceModel Imports System.ServiceModel.Web Imports System.Text Namespace MyService Public Class Service1 Implements IService1 Public Function FindEmployee(ByVal uid As String) As List(Of PERSONAS) Implements IService1.FindEmployee Dim context As New DataClasses1DataContext() Dim res = From r In context.PERSONAS Where r.NIF = uid Select r Return res.ToList() End Function End Class End Namespace ISERVICE1.vb Imports System Imports System.Collections.Generic Imports System.Linq Imports System.Runtime.Serialization Imports System.ServiceModel Imports System.ServiceModel.Web Imports System.Text Namespace MyService <ServiceContract()> Public Interface IService1 <OperationContract()> _ Function FindEmployee(ByVal uid As String) As List(Of PERSONAS) End Interface End Namespace I'm still having the error ¿May you help me?
- Enrique Serra16y ago
  Hi i'm trying to do your WCF example in C# I'm getting errors. this is the code. PERSONAS is a TABLE SERVICE1.svc.CS using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.ServiceModel.Web; using System.Text; using WcfService2; namespace MyService { public class Service1 : IService1 { public List<PERSONAS> FindEmployee(string uid) { DataClasses1DataContext context = new DataClasses1DataContext(); var res = from r in context.PERSONAS where r.NIF == uid select r; return res.ToList(); } } } ISERVICE1.CS using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.ServiceModel.Web; using System.Text; using System.Collections.Generic; namespace MyService { [ServiceContract] public interface IService1 { [OperationContract] List<WcfService2.PERSONAS> FindEmployee(string uid); } } I'm gettin this error http://i54.tinypic.com/68a9zn.jpg SERVER ERROR ON APPLICATION / WCFSERVICE2.SERVICE1 NOT FOUND Please, help me! Thanks!
- Urmimala Pal16y ago
  Hi, Thanks for ur comment:) I don't think u have to install any server. The service runs in asp.net cassini server. What i felt,there might be some error in service class itself. Please check that out.
sella durai16y ago
hi, thanks lot yaar. i have to know about 1)How to insert , delete, update a value in LINQ to SQL? 2)How to display the all rows and column values in kist box or other controls in windows phone?
Gino Cui16y ago
Thanks a lot for your effort. Pretty more details in this article. Looking forward to your next nice article :D
Hector Cubillos16y ago
just what I wanted Excellent work. very good.
Ibrahim Ersoy16y ago
Well done,Keep up the awesome work ;)
- Praveen Kumar v16y ago
  Nice Article. Explanations are very helpful. Thanks for posting this article.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
- Urmimala Pal16y ago
  Thanks Praveen :)
- Urmimala Pal16y ago
  Thank you Ibrahim :)
Mahesh Chand16y ago
Good and clear article Urmimala. Thank you for sharing it. Keep up the good work! Cheers!
- Urmimala Pal16y ago
  Thank you Mahesh :)
- guna s15y ago
  1.How to insert , delete, update a value in LINQ to SQL? 2.How to display the all rows and column values in list box or other controls in windows phone 7?
Dennis Thomas16y ago
Great Work Urmimala. Your narration i simple, so easy to understand. Waiting for your new article!
- Urmimala Pal16y ago
  Thanks Dennis :)
Former member16y ago
First article and this is so great :) Really fine Long to go ...... keep it up ..
- Urmimala Pal16y ago
  Thank u so much dhananjay :)

Creating the Windows Phone 7 application that consumes the WCF service

Open the Microsoft Visual Studio 2010 Express for Windows Phone and create a Windows Phone Application. (In our case the name of the Windows Phone 7 application is MyClientWin7)

In MainPage.xaml drag and drop a TextBox and a Button as shown below.

The XAML code for MainPage.xaml is given below

<phoneNavigation:PhoneApplicationPage
x:Class="MyClientWin7.MainPage"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:phoneNavigation="clr- namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone.Controls.Navigation"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="d" d:DesignWidth="480" d:DesignHeight="800"
FontFamily="{StaticResource PhoneFontFamilyNormal}"
FontSize="{StaticResource PhoneFontSizeNormal}"
Foreground="{StaticResource PhoneForegroundBrush}">

<Grid x:Name="LayoutRoot" Background="{StaticResource PhoneBackgroundBrush}">
<Grid.RowDefinitions>
<RowDefinition Height="Auto"/>
<RowDefinition Height="*"/>
</Grid.RowDefinitions>


<Grid x:Name="TitleGrid" Grid.Row="0">
<TextBlock Text="MY APPLICATION" x:Name="textBlockPageTitle" Style="{StaticResource PhoneTextPageTitle1Style}"/>
<TextBlock Text="page title" x:Name="textBlockListTitle" Style="{StaticResource PhoneTextPageTitle2Style}"/>
</Grid>

<Grid x:Name="ContentGrid" Grid.Row="1">
<TextBox Height="32" HorizontalAlignment="Left" Margin="40,87,0,0" Name="textBox1" Text="" VerticalAlignment="Top" Width="401" />
<Button Height="70" HorizontalAlignment="Left" Margin="152,304,0,0" Name="button1" VerticalAlignment="Top" Width="160" Content="Find" Click="button1_Click" />
</Grid>
</Grid>

</phoneNavigation:PhoneApplicationPage>

Right click on the project name (MyClientWin7) and add a new item. Then select a Windows Phone Portrait Page and add it to the project.

In Page1.xaml, drag and drop a list box.

The XAML code for Page1.xaml is given below

<navigation:PhoneApplicationPage
x:Class="MyClientWin7.Page1"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:navigation="clr-namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone.Controls.Navigation"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
SupportedOrientations="Portrait"
mc:Ignorable="d" d:DesignHeight="800" d:DesignWidth="480">

<Grid Grid.Row="0" x:Name="TitleGrid">
<TextBlock x:Name="ApplicationName" Text="MY APPLICATION" Style="{StaticResource PhoneTextPageTitle1Style}"/>
<TextBlock x:Name="ListName" Text="page title" Style="{StaticResource PhoneTextPageTitle2Style}"/>
</Grid>

<Grid Grid.Row="1" x:Name="ContentGrid">
<ListBox Height="444" HorizontalAlignment="Left" Margin="20,81,0,0" Name="listBox1" VerticalAlignment="Top" Width="434" />
</Grid>
</Grid>
</navigation:PhoneApplicationPage>

Now right click on the References and add a Service Reference.

In the Address paste the URL of the WCF service which is running and click Go. Then click OK.

Now open the MainPAge.xaml.cs (Double click on the button "Find") and write down the follwing code.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

using Microsoft.Phone.Controls;

namespace MyClientWin7

{

public partial class MainPage : PhoneApplicationPage

{

public MainPage()

{

InitializeComponent();

SupportedOrientations = SupportedPageOrientation.Portrait | SupportedPageOrientation.Landscape;

}

private void button1_Click(object sender, RoutedEventArgs e)

{

string s = textBox1.Text;

this.Content = new Page1(s);

}
}
}

Explanation of the code:

In the button click event (button1_Click), we have stored the textbox entry in a string and move to a new page (Page1) . In the Page1 constructor, we have passed the textbox entry.
(Here we will find an error in new Page1(s) as the constructor defined in Page1.xaml.cs has no arguments. But we will change the constructor in the next step. Then the error will be removed.)

Open Page1.xaml.cs and write down the code.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

using Microsoft.Phone.Controls;

using MyClientWin7.ServiceReference1;

namespace MyClientWin7

{

public partial class Page1 : PhoneApplicationPage

{

public Page1(string s)

{

InitializeComponent();

Service1Client proxy = new Service1Client();

proxy.FindEmployeeCompleted += new EventHandler<FindEmployeeCompletedEventArgs>(proxy_FindEmployeeCompleted);

proxy.FindEmployeeAsync(s);

}

void proxy_FindEmployeeCompleted(object sender, FindEmployeeCompletedEventArgs e)

{
listBox1.ItemsSource = e.Result;
}
}
}

Explanation of the code:

In the Page1 constructor, we have created a proxy object of the service. Now all WCF service calls from Silverlight are made through asynchronous communications. The FindEmployee contract is implemented in the generated proxy with an asynchronous method FindEmployeeAsync and an event proxy_FindEmployeeCompleted that is raised when the operation has completed.
The proxy_ FindEmployeeCompleted event sets the ItemSource property of the list box with the return value of the operation contract.

Replace the code for the ListBox in the Page1.xaml in the following way.

<ListBox.ItemTemplate>

</StackPanel>

</DataTemplate>

</ListBox.ItemTemplate>

</ListBox>
Explanation of the code:

In this code we have overriden the ListBox control's ItemTemplate and supplied a custom DataTemplate. This DataTemplate uses one StackPanel to stack some textblocks together horizontally. These textblocks are used to bind to the data from the table in a readable manner.

Rebuild the solution and start debugging. The following screen will appear in the emulator.

Enter some Employee ID in the textbox and click the Find button. (Here I have entered U22975 in the text box )The following screen will appear then showing the details of the employee whose ID was entered in the textbox.