在Silverlight中使用WCF服务之二

步骤一：创建WCF服务

sql server express 连接字符串如下：

<connectionStrings> <add name="ConnStr" connectionString="Data Source=PC1010/SQLEXPRESS;Initial Catalog=AdventureWorksDW2008R2;Persist Security Info=True;User ID=sa;Password=FlexMapServer2010" providerName="System.Data.SqlClient"/> </connectionStrings>

WCF Service内容如下：

namespace WCFDatabaseService { // NOTE: If you change the class name "Service1" here, you must also update the reference to "Service1" in Web.config and in the associated .svc file. public class ServiceCustomer : IServiceCustomer { public clsCustomer getCustomer(int intCustomer) { SqlConnection objConnection = new SqlConnection(); DataSet ObjDataset = new DataSet(); SqlDataAdapter objAdapater = new SqlDataAdapter(); //SELECT EmployeeKey, FirstName, LastName, MiddleName FROM DimEmployee //SqlCommand objCommand = new SqlCommand("Select * from Customer where CustomerId=" + intCustomer.ToString()); SqlCommand objCommand = new SqlCommand("SELECT EmployeeKey, FirstName, LastName, MiddleName FROM DimEmployee where EmployeeKey=" + intCustomer.ToString()); objConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ToString(); objConnection.Open(); objCommand.Connection = objConnection; objAdapater.SelectCommand = objCommand; objAdapater.Fill(ObjDataset); clsCustomer objCustomer = new clsCustomer(); objCustomer.CustomerCode = ObjDataset.Tables[0].Rows[0][0].ToString(); objCustomer.Customer = ObjDataset.Tables[0].Rows[0][2].ToString(); objConnection.Close(); return objCustomer; } } }

 

步骤二：修改IService1.cs如下：

using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.Text; namespace WCFDatabaseService { // NOTE: If you change the interface name "IService1" here, you must also update the reference to "IService1" in Web.config. [ServiceContract] public interface IServiceCustomer { [OperationContract] clsCustomer getCustomer(int intCustomer); } // Customer data contract [DataContract] public class clsCustomer { private string _strCustomer; private string _strCustomerCode; [DataMember] public string Customer { get { return _strCustomer; } set { _strCustomer = value; } } [DataMember] public string CustomerCode { get { return _strCustomerCode; } set { _strCustomerCode = value; } } //SELECT EmployeeKey, FirstName, LastName, MiddleName FROM DimEmployee } }

 

步骤三：创建silverlight项目，并添加刚才创建的WCF服务。

修改xaml文件如下：

<UserControl x:Class="SilverLightDatabaseExample.Page" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data" Width="400" Height="300"> <Grid x:Name="LayoutRoot" Background="White"> <Grid.ColumnDefinitions> <ColumnDefinition></ColumnDefinition> <ColumnDefinition></ColumnDefinition> </Grid.ColumnDefinitions> <Grid.RowDefinitions> <RowDefinition Height="20"></RowDefinition> <RowDefinition Height="20"></RowDefinition> </Grid.RowDefinitions> <TextBlock x:Name="LblCustomerCode" Grid.Column="0" Grid.Row="0" Text="Customer Code"></TextBlock> <TextBlock x:Name="TxtCustomerCode" Grid.Column="1" Grid.Row="0" Text="{Binding Path=CustomerCode}"></TextBlock> <TextBlock x:Name="LblCustomerName" Grid.Column="0" Grid.Row="1" Text="Customer Name"></TextBlock> <TextBlock x:Name="TxtCustomerName" Grid.Column="1" Grid.Row="1" Text="{Binding Path=Customer}"></TextBlock> </Grid> </UserControl>

 

xaml后台C#代码如下：

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 SilverLightDatabaseExample.ServiceReference1; namespace SilverLightDatabaseExample { public partial class Page : UserControl { public Page() { InitializeComponent(); ServiceCustomerClient obj = new ServiceCustomerClient(); obj.getCustomerCompleted += new EventHandler<getCustomerCompletedEventArgs>(DisplayResults); obj.getCustomerAsync(2); } void DisplayResults(object sender, getCustomerCompletedEventArgs e) { LayoutRoot.DataContext = e.Result; } } }

 

步骤四：结果如下：