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

大佬教程收集整理的这篇文章主要介绍了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; @H_197_14@ @H_820_18@mainPage.xaml.cs Code:

using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Collection<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Generi<a href="http://code.js-code.com/tag/c/" target="_blank" class="keywords">c;</a> using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Linq; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Net; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Windows; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Controls; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Documents; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Input; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Media; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Media.Animation; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Shapes; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Data.<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ce<a href="http://code.js-code.com/tag/sCLIEN/" target="_blank" class="keywords">s.CLIEN</a>t; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Collection<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ctModel; using Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Collection<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Specialized; using SilverlightApplication12.Northwind; namespace SilverlightApplication12 <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> public partial class MainPage : UserControl <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> ObservableCollection<Customers> CollectionCustomers; NorthwindEntities svcNorthwind; public MainPage() <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> InitializeComponent(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> CollectionCustomers = new ObservableCollection<Customers>(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> //事件<a href="http://code.js-code.com/tag/zhuce/" target="_blank" class="keywords">注册</a> this<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>tndelte.Click += new RoutedEventHandler(btndelte_Click<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> this<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>tnsave.Click += new RoutedEventHandler(btnsave_Click<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>DGGetCustomerByID.KeyDown += new KeyEventHandler(DGGetCustomerByID_KeyDown<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> this<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>tnAddCustomer.Click+=new RoutedEventHandler(btnAddCustomer_Click<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } void DGGetCustomerByID_KeyDown(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,KeyEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> svcNorthwind.<a href="http://code.js-code.com/tag/updat/" target="_blank" class="keywords">updat</a>eOb<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct(thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>DGGetCustomerByID.<a href="http://code.js-code.com/tag/SELE/" target="_blank" class="keywords">SELE</a>ctedItem<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a>//DataGrid KeyDown事件处理 } /// <sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// 保存每次<a href="http://code.js-code.com/tag/xiugai/" target="_blank" class="keywords">修改</a>，<a href="http://code.js-code.com/tag/shanchu/" target="_blank" class="keywords">删除</a>，<a href="http://code.js-code.com/tag/tianjia/" target="_blank" class="keywords">添加</a> /// </sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <param name="sender"></param> /// <param name="e"></param> void btnsave_Click(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,RoutedEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> svcNorthwind<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>eginSaveChanges(SaveChangesOptions<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>atch,On<a href="http://code.js-code.com/tag/succes/" target="_blank" class="keywords">succes</a>sChang,svcNorthwind<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } void On<a href="http://code.js-code.com/tag/succes/" target="_blank" class="keywords">succes</a>sChang(IAsyncResult result) <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Dispatcher<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>eginInvoke(() => <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> svcNorthwind= result.AsyncState as NorthwindEntities; try <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Data<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceResponse chang_result = svcNorthwin<a href="http://code.js-code.com/tag/den/" target="_blank" class="keywords">d.en</a>dSaveChanges(result<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> if (chang_result.IsBatchResponse == tru<a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> <a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng code="202"; thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = chang_result<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>atchStatusCode.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng() == code? "保存成功" : "保存失败"; } else <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = "Save Error!"; } } catch (Data<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ce<a href="http://code.js-code.com/tag/requ/" target="_blank" class="keywords">requ</a>estException e<a href="http://code.js-code.com/tag/X/" target="_blank" class="keywords">X)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = ex.<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>ge.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } catch (Invali<a href="http://code.js-code.com/tag/dop/" target="_blank" class="keywords">dop</a>erationException e<a href="http://code.js-code.com/tag/X/" target="_blank" class="keywords">X)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = ex.<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>ge.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } }<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } /// <sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <a href="http://code.js-code.com/tag/shanchu/" target="_blank" class="keywords">删除</a> /// </sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <param name="sender"></param> /// <param name="e"></param> void btndelte_Click(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,RoutedEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Customers customeritem = (Customers)DGGetCustomerByID.<a href="http://code.js-code.com/tag/SELE/" target="_blank" class="keywords">SELE</a>ctedItem; if (customeritem == null) return; svcNorthwind.<a href="http://code.js-code.com/tag/delet/" target="_blank" class="keywords">delet</a>eOb<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct(customeritem<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> try <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> bool b = CollectionCustomer<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Remove(customeritem<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = b == true ? "<a href="http://code.js-code.com/tag/shanchu/" target="_blank" class="keywords">删除</a>成功!" : "<a href="http://code.js-code.com/tag/shanchu/" target="_blank" class="keywords">删除</a>失败！"; } catch(Exception e<a href="http://code.js-code.com/tag/X/" target="_blank" class="keywords">X)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = ex.<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>ge.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } } private void ResetDataBinding() <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> svcNorthwind = new NorthwindEntities(new Uri("NorthwindWebData<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ce.svc",UriKind.Relativ<a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a><a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>CollectionCustomer<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Clear(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } /// <sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// 条件<a href="http://code.js-code.com/tag/chaxun/" target="_blank" class="keywords">查询</a> /// </sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <param name="sender"></param> /// <param name="e"></param> private void Getcustomer_Click(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,RoutedEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> ResetDataBinding(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> <a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng filter_query = "CustomerID eq '"+thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tbcustomervalue.Text+"'"; try <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Data<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceQuery<Customers> query = svcNorthwind.Customer<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>AddQueryOption("$filter",filter_query<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> query<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>eginExecute(On<a href="http://code.js-code.com/tag/succes/" target="_blank" class="keywords">succes</a>sLoadCustomerById,query<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } catch(Exception e<a href="http://code.js-code.com/tag/X/" target="_blank" class="keywords">X)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = ex.<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>ge.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } } private void On<a href="http://code.js-code.com/tag/succes/" target="_blank" class="keywords">succes</a>sLoadCustomerById(IAsyncResult result) <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Dispatcher<a href="http://code.js-code.com/tag/b/" target="_blank" class="keywords">.b</a>eginInvoke(() => <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Data<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceQuery<Customers> query = result.AsyncState as Data<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceQuery<Customers>; try <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> Customers customer = query.EndExecute(result).FirstOrDefault(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> if (customer <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">!=</a> null) <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> CollectionCustomer<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Add(customer<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>DGGetCustomerByID.DataCo<a href="http://code.js-code.com/tag/ntex/" target="_blank" class="keywords">ntex</a>t = CollectionCustomers; thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>DGGetCustomerByID.<a href="http://code.js-code.com/tag/updat/" target="_blank" class="keywords">updat</a>eLayout(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } } catch(Exception e<a href="http://code.js-code.com/tag/X/" target="_blank" class="keywords">X)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow.Text = ex.<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>ge.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } } <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } /// <sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <a href="http://code.js-code.com/tag/tianjia/" target="_blank" class="keywords">添加</a> /// </sum<a href="http://code.js-code.com/tag/Mary/" target="_blank" class="keywords">Mary</a>> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddCustomer_Click(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,RoutedEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> ResetDataBinding(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> Customers customer = new Customers(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> Random rm = new Random(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> customer.CustomerID = thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tbcustomerid.Text.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> customer.CompanyName = thi<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>tbCompanyName.Text.To<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> customer.Address = "<a href="http://code.js-code.com/tag/http/" target="_blank" class="keywords">http</a>://blog.csdn.net/ChinaHuN<a href="http://code.js-code.com/tag/Ann/" target="_blank" class="keywords">Ann</a>et"; svcNorthwind.AddToCustomers(customer<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> } } }

@H_820_18@mainPage.xaml Code:

<UserControl xmlns:data="clr-namespace:Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Controls;assembly=Sy<a href="http://code.js-code.com/tag/stem/" target="_blank" class="keywords">stem</a>.Window<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Control<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>Data" x:Class="SilverlightApplication12.MainPage" xmlns="<a href="http://code.js-code.com/tag/http/" target="_blank" class="keywords">http</a>://<a href="http://code.js-code.com/tag/sche/" target="_blank" class="keywords">sche</a>R_633_11845@a<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>microsoft.com/winfx/2006/xaml/presentation" xmlns:x="<a href="http://code.js-code.com/tag/http/" target="_blank" class="keywords">http</a>://<a href="http://code.js-code.com/tag/sche/" target="_blank" class="keywords">sche</a>R_633_11845@a<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>microsoft.com/winfx/2006/xaml" xmlns:d="<a href="http://code.js-code.com/tag/http/" target="_blank" class="keywords">http</a>://<a href="http://code.js-code.com/tag/sche/" target="_blank" class="keywords">sche</a>R_633_11845@a<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>microsoft.com/expression/blend/2008" xmlns:mc="<a href="http://code.js-code.com/tag/http/" target="_blank" class="keywords">http</a>://<a href="http://code.js-code.com/tag/sche/" target="_blank" class="keywords">sche</a>R_633_11845@a<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>openxmlformat<a href="http://code.js-code.com/tag/s/" target="_blank" class="keywords">s.</a>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.RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>ns> <RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n></RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n> <RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n></RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n> <RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n></RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n> <RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n></RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>n> </Grid.RowDe<a href="http://code.js-code.com/tag/Finitio/" target="_blank" class="keywords">Finitio</a>ns> <StackPanel Orientation="Horizontal" Width="800" Grid.Row="0"> <TextBlock Text="Customer ID:" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="0"></TextBlock> <Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a> Text="" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="1" x:Name="tbcustomervalue" Width="150"></Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a>> <Button Content="获得资料" x:Name="Getcustomer" Click="Getcustomer_Click" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="2"></Button> <Button x:Name="btn<a href="http://code.js-code.com/tag/updat/" target="_blank" class="keywords">updat</a>e" Content="<a href="http://code.js-code.com/tag/xiugai/" target="_blank" class="keywords">修改</a>资料" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="3"></Button> <Button x:Name="btndelte" Content="<a href="http://code.js-code.com/tag/shanchu/" target="_blank" class="keywords">删除</a>资料" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="4"></Button> <Button x:Name="btnsave" Content="保存更改" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="5"></Button> </StackPanel> <data:DataGrid Grid.Row="1" Items<a href="http://code.js-code.com/tag/sourc/" target="_blank" class="keywords">sourc</a>e="<a href="http://code.js-code.com/tag/B/" target="_blank" class="keywords">{B</a>inding}" x:Name="DGGetCustomerByID" Width="800" Height="100"></data:DataGrid> <TextBlock x:Name="tb<a href="http://code.js-code.com/tag/messa/" target="_blank" class="keywords">messa</a>geshow" Grid.Row="2"></TextBlock> <StackPanel Orientation="Horizontal" Grid.Row="3"> <TextBlock Text="CustomerID :" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="0"></TextBlock> <Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a> Text="" x:Name="tbcustomerid" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="1" Width="150"></Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a>> <TextBlock Text="Company Name :" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="2"></TextBlock> <Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a> Text="" x:Name="tbCompanyName" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="3" Width="150"></Text<a href="http://code.js-code.com/tag/Box/" target="_blank" class="keywords">Box</a>> <Button x:Name="btnAddCustomer" Grid.<a href="http://code.js-code.com/tag/colum/" target="_blank" class="keywords">colum</a>n="4" Content="<a href="http://code.js-code.com/tag/tianjia/" target="_blank" class="keywords">添加</a>资料"></Button> </StackPanel> </Grid> </UserControl>

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

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