Silverlight下的WCF服务之三：调用WCF服务从数据库中取出数据显示在datagrid中

本文在Silverlight中调用WCF服务，从sql server数据库中取出customers表格数据，并显示show在silverlight的datagrid控件中。

 

步骤1：创建StudentService wcf服务。

 

using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.Text; namespace WCFDemoService { public class StudentService : IStudentService { public List<Student> GetStudents(int NoOfRecords) { List<Student> studentList = new List<Student>(); Random rd = new Random(); for (int Idex = 1; Idex <= NoOfRecords; Idex++) { Student student = new Student(); student.StudentID = Idex; student.StudentName = "Student Name No." + Idex.ToString(); student.Score = (int) (60 + rd.NextDouble() * 40); student.EvaluationTime = System.DateTime.Now; studentList.Add(student); } return studentList; } } }  

 

实现IStudentService接口如下：

 

using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.Text; namespace WCFDemoService { [ServiceContract] public interface IStudentService { [OperationContract] List<Student> GetStudents(int NoOfRecords); } [DataContract] public class Student { private int studentID