SilverLight 3.0 WCF连接数据库

概述1.首先在Silverlight网站项目中添加一个Linq To Sql类,命名为student：   2.在silverLight网站项目中添加一个WCF服务,就会产生一个IStudentService文件和StudentService文件。   IService文件中的代码如下： using System;using System.Collections.Generic;using S

1.首先在Silverlight网站项目中添加一个linq To sql类,命名为student：

 

2.在silverlight网站项目中添加一个WCF服务,就会产生一个IStudentService文件和StudentService文件。

 

IService文件中的代码如下：

using System;using System.Collections.Generic;using System.linq;using System.Runtime.Serialization;using System.ServiceModel;using System.Text;namespace Sample.Web{ // 注意: 使用“重构”菜单上的“重命名”命令，可以同时更改代码和配置文件中的接口名“IStudentService”。 [ServiceContract] public interface IStudentService { [OperationContract] List<student> getStudents(); [OperationContract] List<student> getStudentByStuID(string stuID); [OperationContract] int Update(student stu1); [OperationContract] int Add(student stu); [OperationContract] voID DeleteStudent(string stuID); }}

 

3.StudentService文件中的代码如下：

using System;using System.Collections.Generic;using System.linq;using System.Runtime.Serialization;using System.ServiceModel;using System.Text;using System.ServiceModel.Activation;namespace Sample.Web{ // 注意: 使用“重构”菜单上的“重命名”命令，可以同时更改代码、svc 和配置文件中的类名“StudentService”。 //这是自己加的。 不加则会报错，对应的命名空间为 //using System.ServiceModel.Activation; [AspNetCompatibilityRequirements(RequirementsMode=AspNetCompatibilityRequirementsMode.required)] public class StudentService : IStudentService { public List<student> getStudents() { StudentDataContext stu = new StudentDataContext(); var query = from p in stu.student select p; return query.ToList<student>(); } public List<student> getStudentByStuID(string stuID) { StudentDataContext dc = new StudentDataContext(); var query = from p in dc.student where p.stuID == stuID select p; return query.ToList<student>(); } public int Update(student stu1) { StudentDataContext service = new StudentDataContext(); student stu = (from s in service.student where s.stuID == stu1.stuID select s).First(); stu.stuID = stu1.stuID; stu.stuname = stu1.stuname; stu.tel = stu1.tel; service.submitChanges(); return 1; } public int Add(student stu) { StudentDataContext dc = new StudentDataContext(); dc.student.InsertOnsubmit(stu); dc.submitChanges(); return 1; } public voID DeleteStudent(string stuID) { StudentDataContext dc = new StudentDataContext(); var stu = from p in dc.student where p.stuID == stuID select p; dc.student.DeleteOnsubmit(stu.First()); dc.submitChanges(); } }}

 

4.在Silverlight项目中添加一个服务引用，命名为ServiceRefences2；

 

在项目中添加一个BindStudent的XamlUserControl，命名为BindStudent：

 

BindStudent的Xaml代码为：

 

<UserControl xmlns:my="clr-namespace:System.windows.Controls;assembly=System.windows.Controls.Data" x:Class="Sample.BindStudent" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d="http://schemas.microsoft.com/Expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d" d:DesignHeight="300" d:DesignWIDth="400"> <GrID x:name="LayoutRoot" Background="White"> <GrID.Resources> <Style x:Key="myTextBox" targettype="TextBox"> <Setter Property="WIDth" Value="300"/> <Setter Property="Height" Value="30"/> <Setter Property="margin" Value="5 -15 0 0"/> </Style> <Style x:Key="myTextBlock" targettype="TextBlock"> <Setter Property="margin" Value="50 5 0 0"/> </Style> </GrID.Resources> <my:DataGrID x:name="dg_student" LoadingRow="dg_student_LoadingRow"> <my:DataGrID.Columns> <my:DataGrIDTemplateColumn header=" *** 作" WIDth="120"> <my:DataGrIDTemplateColumn.CellTemplate> <DataTemplate> <StackPanel OrIEntation="Horizontal"> <button x:name="btnUpdate" WIDth="50" Height="30" Click="btnUpdate_Click" Content="修改" margin="5"/> <button x:name="btnDelete" WIDth="50" Height="30" Click="btnDelete_Click" Content="删除" margin="5"/> </StackPanel> </DataTemplate> </my:DataGrIDTemplateColumn.CellTemplate> </my:DataGrIDTemplateColumn> </my:DataGrID.Columns> </my:DataGrID> <border x:name="bdDetail" WIDth="600" Height="400" borderThickness="2" borderBrush="Gray" CornerRadius="5" Visibility="Collapsed"> <StackPanel> <TextBlock x:name="txtBStuID" Style="{StaticResource myTextBlock}" mce_Style="{StaticResource myTextBlock}"/> <TextBox x:name="txtStuID" Style="{StaticResource myTextBox}" mce_Style="{StaticResource myTextBox}"/> <TextBlock x:name="txtBStuname" Style="{StaticResource myTextBlock}" mce_Style="{StaticResource myTextBlock}"/> <TextBox x:name="txtStuname" Style="{StaticResource myTextBox}" mce_Style="{StaticResource myTextBox}"/> <TextBlock x:name="txtBTel" Style="{StaticResource myTextBlock}" mce_Style="{StaticResource myTextBlock}"/> <TextBox x:name="txtTel" Style="{StaticResource myTextBox}" mce_Style="{StaticResource myTextBox}"/> <StackPanel WIDth="200" margin="10" OrIEntation="Horizontal"> <button x:name="btnSave" WIDth="80" Height="30" Content="保存" Click="btnSave_Click"/> <button x:name="btnCancel" WIDth="80" Height="30" Content="取消" Click="btnCancel_Click"/> </StackPanel> </StackPanel> </border> </GrID></UserControl>

 

bindStudent的后台代码为：

 

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 Sample.ServiceReference2;namespace Sample{ public enum State { Add,Update } public partial class BindStudent : UserControl { private static student data = new student(); //该Student就是在网站项目中声明的名为student的linq to sql 类 private ServiceReference2.StudentServiceClIEnt sc = new StudentServiceClIEnt(); public State state; public BindStudent() { InitializeComponent(); //BindData(); AddEvents(); sc.getStudentsAsync(); } //public voID BindData() //{ // ServiceReference2.StudentServiceClIEnt stu = new ServiceReference2.StudentServiceClIEnt(); // stu.getStudentsCompleted+=new EventHandler<ServiceReference2.getStudentsCompletedEventArgs>(stu_getStudentsCompleted); // stu.getStudentsAsync(); //} public voID AddEvents() { sc.getStudentsCompleted+=new EventHandler<getStudentsCompletedEventArgs>(sc_getStudentsCompleted); sc.AddCompleted+=new EventHandler<AddCompletedEventArgs>(sc_AddCompleted); //sc.DeleteStudentCompleted+=new EventHandler<>(sc_DeleteStudentCompleted); sc.UpdateCompleted+=new EventHandler<UpdateCompletedEventArgs>(sc_UpdateCompleted); } voID sc_getStudentsCompleted(object sender,getStudentsCompletedEventArgs e) { List<student> student = new List<student>(e.Result); dg_student.ItemsSource = student; } voID sc_AddCompleted(object sender,AddCompletedEventArgs e) { sc.getStudentsAsync(); bdDetail.Visibility = Visibility.Collapsed; } //voID sc_DeleteStudentCompleted(Object sende,DataGrIDRowDetailsEventArgs e) //{ // sc.getStudentsAsync(); //} voID sc_UpdateCompleted(object sender,UpdateCompletedEventArgs e) { sc.getStudentsAsync(); bdDetail.Visibility = Visibility.Collapsed; } private voID btnUpdate_Click(object sender,RoutedEventArgs e) { state = State.Update; button mybutton = sender as button; student tempuser = mybutton.Tag as student; if(tempuser!=null) { data = tempuser; txtStuID.Text = data.stuID; txtStuname.Text = data.stuname; txtTel.Text = data.tel; bdDetail.Visibility = Visibility.Visible; } } private voID btnDelete_Click(object sender,RoutedEventArgs e) { MessageBox.Show("您确定要删除吗？"); } private voID btnSave_Click(object sender,RoutedEventArgs e) { data.stuID = txtStuID.Text; data.stuname = txtStuname.Text; data.tel = txtTel.Text; if(state==State.Update) { sc.UpdateAsync(data); } } private voID btnCancel_Click(object sender,RoutedEventArgs e) { bdDetail.Visibility = Visibility.Collapsed; } private voID dg_student_LoadingRow(object sender,DataGrIDRowEventArgs e) { student stu = (student)e.Row.DataContext; button btn_Update = dg_student.Columns[0].GetCellContent(e.Row).Findname("btnUpdate") as button; button btn_Delete = dg_student.Columns[0].GetCellContent(e.Row).Findname("btnDelete") as button; btn_Update.Tag = stu; btn_Delete.Tag = stu.stuID; } }}

 

 

OK. 效果如下 ： 修改做好了， 删除就没做了。

 

总结

以上是内存溢出为你收集整理的SilverLight 3.0 WCF连接数据库全部内容，希望文章能够帮你解决SilverLight 3.0 WCF连接数据库所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。