Silverlight 3 关于数据添加，删除，修改，条件查询的一点代码

MainPage.xaml.cs 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 System.Data.Services.Client;using System.Collections.ObjectModel;using System.Collections.Specialized;using SilverlightApplication12.Northwind;namespace SilverlightApplication12{ public partial class MainPage : UserControl { ObservableCollection<Customers> CollectionCustomers; NorthwindEntities svcNorthwind; public MainPage() { InitializeComponent(); CollectionCustomers = new ObservableCollection<Customers>(); //事件注册 this.btndelte.Click += new RoutedEventHandler(btndelte_Click); this.btnsave.Click += new RoutedEventHandler(btnsave_Click); this.DGGetCustomerByID.KeyDown += new KeyEventHandler(DGGetCustomerByID_KeyDown); this.btnAddCustomer.Click+=new RoutedEventHandler(btnAddCustomer_Click); } void DGGetCustomerByID_KeyDown(object sender, KeyEventArgs e) { svcNorthwind.UpdateObject(this.DGGetCustomerByID.SelectedItem);//DataGrid KeyDown事件处理 } /// <summary> /// 保存每次修改，删除，添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnsave_Click(object sender, RoutedEventArgs e) { svcNorthwind.BeginSaveChanges(SaveChangesOptions.Batch,OnSuccessChang,svcNorthwind); } void OnSuccessChang(IAsyncResult result) { Dispatcher.BeginInvoke(() => { svcNorthwind= result.AsyncState as NorthwindEntities; try { DataServiceResponse chang_result = svcNorthwind.EndSaveChanges(result); if (chang_result.IsBatchResponse == true) { string code="202"; this.tbmessageshow.Text = chang_result.BatchStatusCode.ToString() == code? "保存成功" : "保存失败"; } else { this.tbmessageshow.Text = "Save Error!"; } } catch (DataServiceRequestException ex) { this.tbmessageshow.Text = ex.Message.ToString(); } catch (InvalidOperationException ex) { this.tbmessageshow.Text = ex.Message.ToString(); } }); } /// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btndelte_Click(object sender, RoutedEventArgs e) { Customers customeritem = (Customers)DGGetCustomerByID.SelectedItem; if (customeritem == null) return; svcNorthwind.DeleteObject(customeritem); try { bool b = CollectionCustomers.Remove(customeritem); this.tbmessageshow.Text = b == true ? "删除成功!" : "删除失败！"; } catch(Exception ex) { this.tbmessageshow.Text = ex.Message.ToString(); } } private void ResetDataBinding() { svcNorthwind = new NorthwindEntities(new Uri("NorthwindWebDataService.svc", UriKind.Relative)); this.CollectionCustomers.Clear(); } /// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Getcustomer_Click(object sender, RoutedEventArgs e) { ResetDataBinding(); string filter_query = "CustomerID eq '"+this.tbcustomervalue.Text+"'"; try { DataServiceQuery<Customers> query = svcNorthwind.Customers.AddQueryOption("$filter", filter_query); query.BeginExecute(OnSuccessLoadCustomerById,query); } catch(Exception ex) { this.tbmessageshow.Text = ex.Message.ToString(); } } private void OnSuccessLoadCustomerById(IAsyncResult result) { Dispatcher.BeginInvoke(() => { DataServiceQuery<Customers> query = result.AsyncState as DataServiceQuery<Customers>; try { Customers customer = query.EndExecute(result).FirstOrDefault(); if (customer != null) { CollectionCustomers.Add(customer); this.DGGetCustomerByID.DataContext = CollectionCustomers; this.DGGetCustomerByID.UpdateLayout(); } } catch(Exception ex) { this.tbmessageshow.Text = ex.Message.ToString(); } } ); } /// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddCustomer_Click(object sender, RoutedEventArgs e) { ResetDataBinding(); Customers customer = new Customers(); Random rm = new Random(); customer.CustomerID = this.tbcustomerid.Text.ToString(); customer.CompanyName = this.tbCompanyName.Text.ToString(); customer.Address = "http://blog.csdn.net/ChinaHuNannet"; svcNorthwind.AddToCustomers(customer); } }}

MainPage.xaml Code:

<UserControl xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data" x:Class="SilverlightApplication12.MainPage" 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:DesignWidth="640" d:DesignHeight="480"> <Grid x:Name="LayoutRoot" HorizontalAlignment="Left" Margin="20" VerticalAlignment="Top" Width="800"> <Grid.RowDefinitions> <RowDefinition></RowDefinition> <RowDefinition></RowDefinition> <RowDefinition></RowDefinition> <RowDefinition></RowDefinition> </Grid.RowDefinitions> <StackPanel Orientation="Horizontal" Width="800" Grid.Row="0"> <TextBlock Text="Customer ID:" Grid.Column="0"></TextBlock> <TextBox Text="" Grid.Column="1" x:Name="tbcustomervalue" Width="150"></TextBox> <Button Content="获得资料" x:Name="Getcustomer" Click="Getcustomer_Click" Grid.Column="2"></Button> <Button x:Name="btnupdate" Content="修改资料" Grid.Column="3"></Button> <Button x:Name="btndelte" Content="删除资料" Grid.Column="4"></Button> <Button x:Name="btnsave" Content="保存更改" Grid.Column="5"></Button> </StackPanel> <data:DataGrid Grid.Row="1" ItemsSource="{Binding}" x:Name="DGGetCustomerByID" Width="800" Height="100"></data:DataGrid> <TextBlock x:Name="tbmessageshow" Grid.Row="2"></TextBlock> <StackPanel Orientation="Horizontal" Grid.Row="3"> <TextBlock Text="CustomerID :" Grid.Column="0"></TextBlock> <TextBox Text="" x:Name="tbcustomerid" Grid.Column="1" Width="150"></TextBox> <TextBlock Text="Company Name :" Grid.Column="2"></TextBlock> <TextBox Text="" x:Name="tbCompanyName" Grid.Column="3" Width="150"></TextBox> <Button x:Name="btnAddCustomer" Grid.Column="4" Content="添加资料"></Button> </StackPanel> </Grid></UserControl>

注：添加，删除，修改操作后，需点击保存按钮生效，没有对修改，添加时候输入数据进行有效性非空进行验证。

数据库：Northwind 开发环境：Microsoft Visual Studio 2008， Silverlight3。