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;

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。

总结

以上是内存溢出为你收集整理的Silverlight 3 关于数据添加，删除，修改，条件查询的一点代码全部内容，希望文章能够帮你解决Silverlight 3 关于数据添加，删除，修改，条件查询的一点代码所遇到的程序开发问题。

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