日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

RELATEED CONSULTING
相關(guān)咨詢
選擇下列產(chǎn)品馬上在線溝通
服務(wù)時(shí)間：8:30-17:00
你可能遇到了下面的問(wèn)題
關(guān)閉右側(cè)工具欄

新聞中心

這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
詳解Silverlight與Access互操作的具體實(shí)現(xiàn)

Silverlight與Access互操作是一個(gè)很基礎(chǔ)的問(wèn)題，主要涉及到數(shù)據(jù)庫(kù)的操作。Access屬于輕量級(jí)的數(shù)據(jù)庫(kù)，應(yīng)用起來(lái)還是比較方便的。創(chuàng)新互聯(lián)推薦《
走向銀光 —— 一步一步學(xué)Silverlight》

成都創(chuàng)新互聯(lián)自2013年起，先為寶興等服務(wù)建站，寶興等地企業(yè)，進(jìn)行企業(yè)商務(wù)咨詢服務(wù)。為寶興企業(yè)網(wǎng)站制作PC+手機(jī)+微官網(wǎng)三網(wǎng)同步一站式服務(wù)解決您的所有建站問(wèn)題。

在開發(fā)一些小型應(yīng)用程序時(shí)，我們就需要使用一些小巧的輕量級(jí)的數(shù)據(jù)庫(kù)，比如Access數(shù)據(jù)庫(kù)。由于Visual Studio中并沒(méi)有直接提供Silverlight與Access互操作的系列方法。于是本文就將為大家介紹如何讓Silverlight使用Access作為后臺(tái)數(shù)據(jù)庫(kù)。

準(zhǔn)備工作

1）建立起測(cè)試項(xiàng)目

細(xì)節(jié)詳情請(qǐng)見(jiàn)強(qiáng)大的DataGrid組件[2]_數(shù)據(jù)交互之ADO.NET Entity Framework——Silverlight學(xué)習(xí)筆記[10]。

2）創(chuàng)建測(cè)試用數(shù)據(jù)庫(kù)

如下圖所示，創(chuàng)建一個(gè)名為Employees.mdb的Access數(shù)據(jù)庫(kù)，建立數(shù)據(jù)表名稱為Employee。將該數(shù)據(jù)庫(kù)置于作為服務(wù)端的項(xiàng)目文件夾下的App_Data文件夾中，便于操作管理。

建立數(shù)據(jù)模型

EmployeeModel.cs文件（放置在服務(wù)端項(xiàng)目文件夾下）

 
 
 
 
    
  
  
  
  
  1. using System; 
    2. 
  
  
  
  
  2. using System.Collections.Generic; 
    3. 
  
  
  
  
  3. using System.Linq; 
    4. 
  
  
  
  
  4. namespace datagridnaccessdb 
    5. 
  
  
  
  
  5. { 
    6. 
  
  
  
  
  6.     public class EmployeeModel 
    7. 
  
  
  
  
  7.     { 
    8. 
  
  
  
  
  8.         public int EmployeeID { get; set; } 
    9. 
  
  
  
  
  9.         public string EmployeeName { get; set; } 
    10. 
  
  
  
  
  10.         public int EmployeeAge { get; set; } 
    11. 
  
  
  
  
  11.     } 
    12. 
  
  
  
  
  12. }
    13.

建立服務(wù)端Web Service

右擊服務(wù)端項(xiàng)目文件夾，選擇Add->New Item....，按下圖所示建立一個(gè)名為EmployeesInfoWebService.asmx的Web Service，作為Silverlight與Access數(shù)據(jù)庫(kù)互操作的橋梁。

創(chuàng)建完畢后，雙擊EmployeesInfoWebService.asmx打開該文件。將里面的內(nèi)容修改如下：

 
 
 
 
    
  
  
  
  
  1. using System; 
    2. 
  
  
  
  
  2. using System.Collections.Generic; 
    3. 
  
  
  
  
  3. using System.Linq; 
    4. 
  
  
  
  
  4. using System.Web; 
    5. 
  
  
  
  
  5. using System.Web.Services; 
    6. 
  
  
  
  
  6. using System.Data.OleDb;//引入該命名空間為了操作Access數(shù)據(jù)庫(kù) 
    7. 
  
  
  
  
  7. using System.Data; 
    8. 
  
  
  
  
  8. namespace datagridnaccessdb 
    9. 
  
  
  
  
  9. { 
    10. 
  
  
  
  
  10.     /// 
    11. 
  
  
  
  
  11.     /// Summary description for EmployeesInfoWebService 
    12. 
  
  
  
  
  12.     /// 
    13. 
  
  
  
  
  13.     [WebService(Namespace = "http://tempuri.org/")] 
    14. 
  
  
  
  
  14.     [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] 
    15. 
  
  
  
  
  15.     [System.ComponentModel.ToolboxItem(false)] 
    16. 
  
  
  
  
  16.     // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.  
    17. 
  
  
  
  
  17.     // [System.Web.Script.Services.ScriptService] 
    18. 
  
  
  
  
  18.     public class EmployeesInfoWebService : System.Web.Services.WebService 
    19. 
  
  
  
  
  19.     { 
    20. 
  
  
  
  
  20.         [WebMethod]//獲取雇員信息 
    21. 
  
  
  
  
  21.         public List GetEmployeesInfo() 
    22. 
  
  
  
  
  22.         { 
    23. 
  
  
  
  
  23.             List returnedValue = new List(); 
    24. 
  
  
  
  
  24.             OleDbCommand Cmd = new OleDbCommand(); 
    25. 
  
  
  
  
  25.             SQLExcute("SELECT * FROM Employee", Cmd); 
    26. 
  
  
  
  
  26.             OleDbDataAdapter EmployeeAdapter = new OleDbDataAdapter(); 
    27. 
  
  
  
  
  27.             EmployeeAdapter.SelectCommand = Cmd; 
    28. 
  
  
  
  
  28.             DataSet EmployeeDataSet = new DataSet(); 
    29. 
  
  
  
  
  29.             EmployeeAdapter.Fill(EmployeeDataSet); 
    30. 
  
  
  
  
  30.             foreach (DataRow dr in EmployeeDataSet.Tables[0].Rows) 
    31. 
  
  
  
  
  31.             { 
    32. 
  
  
  
  
  32.                 EmployeeModel tmp = new EmployeeModel(); 
    33. 
  
  
  
  
  33.                 tmp.EmployeeID = Convert.ToInt32(dr[0]); 
    34. 
  
  
  
  
  34.                 tmp.EmployeeName = Convert.ToString(dr[1]); 
    35. 
  
  
  
  
  35.                 tmp.EmployeeAge = Convert.ToInt32(dr[2]); 
    36. 
  
  
  
  
  36.                 returnedValue.Add(tmp); 
    37. 
  
  
  
  
  37.             } 
    38. 
  
  
  
  
  38.             return returnedValue; 
    39. 
  
  
  
  
  39.         } 
    40. 
  
  
  
  
  40.        [WebMethod] //添加雇員信息 
    41. 
  
  
  
  
  41.         public void Insert(List employee) 
    42. 
  
  
  
  
  42.         { 
    43. 
  
  
  
  
  43.             employee.ForEach( x =>  
    44. 
  
  
  
  
  44.            { 
    45. 
  
  
  
  
  45.                 string CmdText = "INSERT INTO Employee(EmployeeName,EmployeeAge) VALUES('"+x.EmployeeName+"',"+x.EmployeeAge.ToString()+")"; 
    46. 
  
  
  
  
  46.                 SQLExcute(CmdText); 
    47. 
  
  
  
  
  47.             }); 
    48. 
  
  
  
  
  48.         } 
    49. 
  
  
  
  
  49.         [WebMethod] //更新雇員信息 
    50. 
  
  
  
  
  50.        public void Update(List employee) 
    51. 
  
  
  
  
  51.         { 
    52. 
  
  
  
  
  52.            employee.ForEach(x =>
    53. 
  
  
  
  
  53.             { 
    54. 
  
  
  
  
  54.                 string CmdText = "UPDATE Employee SET EmployeeName='"+x.EmployeeName+"',EmployeeAge="+x.EmployeeAge.ToString(); 
    55. 
  
  
  
  
  55.                 CmdText += " WHERE EmployeeID="+x.EmployeeID.ToString(); 
    56. 
  
  
  
  
  56.                 SQLExcute(CmdText); 
    57. 
  
  
  
  
  57.             }); 
    58. 
  
  
  
  
  58.         } 
    59. 
  
  
  
  
  59.         [WebMethod] //刪除雇員信息 
    60. 
  
  
  
  
  60.        public void Delete(List employee) 
    61. 
  
  
  
  
  61.         { 
    62. 
  
  
  
  
  62.             employee.ForEach(x =>
    63. 
  
  
  
  
  63.             { 
    64. 
  
  
  
  
  64.                 string CmdText = "DELETE FROM Employee WHERE EmployeeID="+x.EmployeeID.ToString(); 
    65. 
  
  
  
  
  65.                 SQLExcute(CmdText); 
    66. 
  
  
  
  
  66.             }); 
    67. 
  
  
  
  
  67.         } 
    68. 
  
  
  
  
  68.        //執(zhí)行SQL命令文本，重載1 
    69. 
  
  
  
  
  69.         private void SQLExcute(string SQLCmd) 
    70. 
  
  
  
  
  70.         { 
    71. 
  
  
  
  
  71.             string ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath(@"App_Data\Employees.mdb;"); 
    72. 
  
  
  
  
  72.             OleDbConnection Conn = new OleDbConnection(ConnectionString); 
    73. 
  
  
  
  
  73.             Conn.Open(); 
    74. 
  
  
  
  
  74.             OleDbCommand Cmd = new OleDbCommand(); 
    75. 
  
  
  
  
  75.             Cmd.Connection = Conn; 
    76. 
  
  
  
  
  76.             Cmd.CommandTimeout = 15; 
    77. 
  
  
  
  
  77.             Cmd.CommandType = CommandType.Text; 
    78. 
  
  
  
  
  78.             Cmd.CommandText = SQLCmd; 
    79. 
  
  
  
  
  79.             Cmd.ExecuteNonQuery(); 
    80. 
  
  
  
  
  80.             Conn.Close(); 
    81. 
  
  
  
  
  81.         } 
    82. 
  
  
  
  
  82.         //執(zhí)行SQL命令文本，重載2 
    83. 
  
  
  
  
  83.         private void SQLExcute(string SQLCmd,OleDbCommand Cmd) 
    84. 
  
  
  
  
  84.         { 
    85. 
  
  
  
  
  85.             string ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath(@"App_Data\Employees.mdb;"); 
    86. 
  
  
  
  
  86.             OleDbConnection Conn = new OleDbConnection(ConnectionString); 
    87. 
  
  
  
  
  87.             Conn.Open(); 
    88. 
  
  
  
  
  88.             Cmd.Connection = Conn; 
    89. 
  
  
  
  
  89.             Cmd.CommandTimeout = 15; 
    90. 
  
  
  
  
  90.             Cmd.CommandType = CommandType.Text; 
    91. 
  
  
  
  
  91.             Cmd.CommandText = SQLCmd; 
    92. 
  
  
  
  
  92.             Cmd.ExecuteNonQuery(); 
    93. 
  
  
  
  
  93.         } 
    94. 
  
  
  
  
  94.     } 
    95. 
  
  
  
  
  95. }
    96.

之后，在Silverlight客戶端應(yīng)用程序文件夾下，右擊References文件夾，選擇菜單選項(xiàng)Add Service Reference...。如下圖所示，引入剛才我們創(chuàng)建的Web Service（別忘了按Discover按鈕進(jìn)行查找）。

創(chuàng)建Silverlight客戶端應(yīng)用程序

 
 
 
 
    
  
  
  
  
  1. MainPage.xaml文件 
    2. 
  
  
  
  
    3. 
  
  
  
  
  3. xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"  
    4. 
  
  
  
  
  4.    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    5. 
  
  
  
  
  5. xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"     mc:Ignorable="d" xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data" xmlns:dataFormToolkit="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data.DataForm.Toolkit" x:Class="SilverlightClient.MainPage"
    6. 
  
  
  
  
  6. 
  
  
  
  
  7.     d:DesignWidth="320" d:DesignHeight="240">
    8. 
  
  
  
  
  8.  x:Name="LayoutRoot" Width="320" Height="240" Background="White">
    9. 
  
  
  
  
  9.   x:Name="dfEmployee" Margin="8,8,8,42"/>
    10. 
  
  
  
  
  10.  x:Name="btnGetData" Height="30" Margin="143,0,100,8" VerticalAlignment="Bottom" Content="Get Data" Width="77"/>
    11. 
  
  
  
  
  11.  x:Name="btnSaveAll" Height="30" Margin="0,0,8,8" VerticalAlignment="Bottom" Content="Save All" HorizontalAlignment="Right" Width="77"/>
    12. 
  
  
  
  
  12.  x:Name="tbResult" Height="30" HorizontalAlignment="Left" Margin="8,0,0,8" VerticalAlignment="Bottom" Width="122" TextWrapping="Wrap" FontSize="16"/>
    13. 
  
  
  
  
    14. 
  
  
  
  
    15. 
  
  
  
  
  15. MainPage.xaml.cs文件 
    16. 
  
  
  
  
  16. using System; 
    17. 
  
  
  
  
  17. using System.Collections.Generic; 
    18. 
  
  
  
  
  18. using System.Collections.ObjectModel; 
    19. 
  
  
  
  
  19. using System.Linq; 
    20. 
  
  
  
  
  20. using System.Net; 
    21. 
  
  
  
  
  21. using System.Windows; 
    22. 
  
  
  
  
  22. using System.Windows.Controls; 
    23. 
  
  
  
  
  23. using System.Windows.Documents; 
    24. 
  
  
  
  
  24. using System.Windows.Input; 
    25. 
  
  
  
  
  25. using System.Windows.Media; 
    26. 
  
  
  
  
  26. using System.Windows.Media.Animation; 
    27. 
  
  
  
  
  27. using System.Windows.Shapes; 
    28. 
  
  
  
  
  28. using System.Xml; 
    29. 
  
  
  
  
  29. using System.Xml.Linq; 
    30. 
  
  
  
  
  30. using System.Windows.Browser; 
    31. 
  
  
  
  
  31. using SilverlightClient.EmployeesInfoServiceReference; 
    32. 
  
  
  
  
  32. namespace SilverlightClient 
    33. 
  
  
  
  
  33. { 
    34. 
  
  
  
  
  34.     public partial class MainPage : UserControl 
    35. 
  
  
  
  
  35.     { 
    36. 
  
  
  
  
  36.         int originalNum;//記錄初始時(shí)的Employee表中的數(shù)據(jù)總數(shù) 
    37. 
  
  
  
  
  37.         ObservableCollection deletedID = new ObservableCollection();//標(biāo)記被刪除的對(duì)象 
    38. 
  
  
  
  
  38.        public MainPage() 
    39. 
  
  
  
  
  39.         { 
    40. 
  
  
  
  
  40.             InitializeComponent(); 
    41. 
  
  
  
  
  41.             this.Loaded += new RoutedEventHandler(MainPage_Loaded); 
    42. 
  
  
  
  
  42.             this.btnGetData.Click += new RoutedEventHandler(btnGetData_Click); 
    43. 
  
  
  
  
  43.             this.btnSaveAll.Click += new RoutedEventHandler(btnSaveAll_Click);  
    44. 
  
  
  
  
  44.             this.dfEmployee.DeletingItem += new EventHandler(dfEmployee_DeletingItem); 
    45. 
  
  
  
  
  45.         } 
    46. 
  
  
  
  
  46.         void dfEmployee_DeletingItem(object sender, System.ComponentModel.CancelEventArgs e) 
    47. 
  
  
  
  
  47.         { 
    48. 
  
  
  
  
  48.             deletedID.Add(dfEmployee.CurrentItem as EmployeeModel);//正在刪除時(shí)，將被刪除對(duì)象進(jìn)行標(biāo)記，以便傳給服務(wù)端真正刪除。 
    49. 
  
  
  
  
  49.         } 
    50. 
  
  
  
  
  50.         void btnSaveAll_Click(object sender, RoutedEventArgs e) 
    51. 
  
  
  
  
  51.         { 
    52. 
  
  
  
  
  52.             List updateValues = dfEmployee.ItemsSource.Cast().ToList(); 
    53. 
  
  
  
  
  53.             ObservableCollection returnValues = new ObservableCollection(); 
    54. 
  
  
  
  
  54.             if (updateValues.Count > originalNum) 
    55. 
  
  
  
  
  55.             { 
    56. 
  
  
  
  
  56.                 //添加數(shù)據(jù) 
    57. 
  
  
  
  
  57.                 for (int i = originalNum; i <= updateValues.Count - 1; i++) 
    58. 
  
  
  
  
  58.                 { 
    59. 
  
  
  
  
  59.                     returnValues.Add(updateValues.ToArray()[i]); 
    60. 
  
  
  
  
  60.                 } 
    61. 
  
  
  
  
  61.                 EmployeesInfoWebServiceSoapClient webClient = new EmployeesInfoWebServiceSoapClient(); 
    62. 
  
  
  
  
  62.                 webClient.InsertCompleted += new EventHandler(webClient_InsertCompleted); 
    63. 
  
  
  
  
  63.                 webClient.InsertAsync(returnValues); 
    64. 
  
  
  
  
  64.                 //必須考慮數(shù)據(jù)集中既有添加又有更新的情況 
    65. 
  
  
  
  
  65.                 returnValues.Clear(); 
    66. 
  
  
  
  
  66.                 updateValues.ForEach(x => returnValues.Add(x)); 
    67. 
  
  
  
  
  67.                 webClient.UpdateCompleted += new EventHandler(webClient_UpdateCompleted); 
    68. 
  
  
  
  
  68.                 webClient.UpdateAsync(returnValues); 
    69. 
  
  
  
  
  69.             } 
    70. 
  
  
  
  
  70.             else if (updateValues.Count < originalNum) 
    71. 
  
  
  
  
  71.             { 
    72. 
  
  
  
  
  72.                 //刪除數(shù)據(jù) 
    73. 
  
  
  
  
  73.                 EmployeesInfoWebServiceSoapClient webClient = new EmployeesInfoWebServiceSoapClient(); 
    74. 
  
  
  
  
  74.                 webClient.DeleteCompleted += new EventHandler(webClient_DeleteCompleted); 
    75. 
  
  
  
  
  75.                 webClient.DeleteAsync(deletedID); 
    76. 
  
  
  
  
  76.             } 
    77. 
  
  
  
  
  77.             else 
    78. 
  
  
  
  
  78.             { 
    79. 
  
  
  
  
  79.                //更新數(shù)據(jù) 
    80. 
  
  
  
  
  80.                 updateValues.ForEach(x => returnValues.Add(x)); 
    81. 
  
  
  
  
  81.                 EmployeesInfoWebServiceSoapClient webClient = new EmployeesInfoWebServiceSoapClient(); 
    82. 
  
  
  
  
  82.                 webClient.UpdateCompleted += new EventHandler(webClient_UpdateCompleted); 
    83. 
  
  
  
  
  83.                 webClient.UpdateAsync(returnValues); 
    84. 
  
  
  
  
  84.            } 
    85. 
  
  
  
  
  85.         } 
    86. 
  
  
  
  
  86.         void webClient_UpdateCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e) 
    87. 
  
  
  
  
  87.         { 
    88. 
  
  
  
  
  88.             tbResult.Text = "更新成功！"; 
    89. 
  
  
  
  
  89.         } 
    90. 
  
  
  
  
  90.         void webClient_DeleteCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e) 
    91. 
  
  
  
  
  91.         { 
    92. 
  
  
  
  
  92.             tbResult.Text = "刪除成功！"; 
    93. 
  
  
  
  
  93.         } 
    94. 
  
  
  
  
  94.         void webClient_InsertCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e) 
    95. 
  
  
  
  
  95.         { 
    96. 
  
  
  
  
  96.             tbResult.Text = "添加成功！"; 
    97. 
  
  
  
  
  97.         } 
    98. 
  
  
  
  
  98.         void btnGetData_Click(object sender, RoutedEventArgs e) 
    99. 
  
  
  
  
  99.         { 
    100. 
  
  
  
  
  100.             GetEmployees(); 
    101. 
  
  
  
  
  101.         } 
    102. 
  
  
  
  
  102.         void MainPage_Loaded(object sender, RoutedEventArgs e) 
    103. 
  
  
  
  
  103.         { 
    104. 
  
  
  
  
  104.             GetEmployees(); 
    105. 
  
  
  
  
  105.         } 
    106. 
  
  
  
  
  106.         void GetEmployees() 
    107. 
  
  
  
  
  107.         { 
    108. 
  
  
  
  
  108.             EmployeesInfoWebServiceSoapClient webClient = new EmployeesInfoWebServiceSoapClient(); 
    109. 
  
  
  
  
  109.             webClient.GetEmployeesInfoCompleted += 
    110. 
  
  
  
  
  110.             new EventHandler(webClient_GetEmployeesInfoCompleted); 
    111. 
  
  
  
  
  111.             webClient.GetEmployeesInfoAsync(); 
    112. 
  
  
  
  
  112.         } 
    113. 
  
  
  
  
  113.         void webClient_GetEmployeesInfoCompleted(object sender, GetEmployeesInfoCompletedEventArgs e) 
    114. 
  
  
  
  
  114.         { 
    115. 
  
  
  
  
  115.             originalNum = e.Result.Count;//記錄原始數(shù)據(jù)個(gè)數(shù) 
    116. 
  
  
  
  
  116.             dfEmployee.ItemsSource = e.Result; 
    117. 
  
  
  
  
  117.         } 
    118. 
  
  
  
  
  118.     } 
    119. 
  
  
  
  
  119. }
    120.

最終效果圖

鏈接：http://www.cnblogs.com/Kinglee/archive/2009/09/05/1561021.html


網(wǎng)站名稱：詳解Silverlight與Access互操作的具體實(shí)現(xiàn)
轉(zhuǎn)載注明：http://m.5511xx.com/article/ccsdhch.html