6Silverlight访问数据库之MySQL数据库[参.pdf
![资源得分’ title=](/images/score_1.gif)
![资源得分’ title=](/images/score_1.gif)
![资源得分’ title=](/images/score_1.gif)
![资源得分’ title=](/images/score_1.gif)
![资源得分’ title=](/images/score_05.gif)
《6Silverlight访问数据库之MySQL数据库[参.pdf》由会员分享,可在线阅读,更多相关《6Silverlight访问数据库之MySQL数据库[参.pdf(6页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、Silverlight访问数据库之 MySQL 数据库本文将为大家介绍如何让Silverlight 使用 MySQL 作为后台数据库以及CURD 操作。准备工作1)建立起测试项目细节详情请见 强大的 DataGrid 组件2_ 数据交互之 ADO.NET Entity Framework2)创建测试用数据库如下图所示,创建一个名为employees的 MySQL 数据库,建立数据表名称为Employee。3)安装 MySQL Connector Net 6.1.1 为了能让.NET 操作 MySQL 数据库,请务必安装。【点击:下载地址】建立数据模型EmployeeModel.cs文件(放置在
2、服务端项目文件夹下)using System;using System.Collections.Generic;using System.Linq;namespace dataformnmysqldb publicclassEmployeeModel publicint EmployeeID get;set;publicstring EmployeeName get;set;publicint EmployeeAge get;set;建立服务端 Web Service 右击服务端项目文件夹,选择Add-New Item.,按下图所示建立一个名为EmployeesInfoWebService.a
3、smx的 Web Service,作为 Silverlight 与 MySQL 数据库互操作的桥梁。在 Silverlight 客户端应用程序文件夹下,右击References文件夹,添加名为MySql.Data 的命名空间。之后,双击 EmployeesInfoWebService.asmx打开该文件,将里面的内容修改如下:using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Services;using System.Data;using MySql
4、.Data.MySqlClient;/引入该命名空间是为了操作MySQL 数据库namespace dataformnmysqldb /Summary description for EmployeesInfoWebService/WebService(Namespace=http:/tempuri.org/)WebServiceBinding(ConformsTo=WsiProfiles.BasicProfile1_1)System.ComponentModel.ToolboxItem(false)/To allow this Web Service to be called from sc
5、ript,using ASP.NET AJAX,uncomment the following line./System.Web.Script.Services.ScriptService文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文
6、档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5
7、T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R
8、2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K1
9、0文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3
10、D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F
11、2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10publicclassEmployeesInfoWebService :Sy
12、stem.Web.Services.WebService WebMethod /获取雇员信息publicList GetEmployeesInfo()List returnedValue=newList();MySqlCommand Cmd=new MySqlCommand();SQLExcute(SELECT*FROM Employee,Cmd);MySqlDataAdapter EmployeeAdapter=newMySqlDataAdapter();EmployeeAdapter.SelectCommand=Cmd;DataSet EmployeeDataSet=new DataSet
13、();EmployeeAdapter.Fill(EmployeeDataSet);foreach (DataRow dr in EmployeeDataSet.Tables0.Rows)EmployeeModel tmp=new EmployeeModel();tmp.EmployeeID=Convert.ToInt32(dr0);tmp.EmployeeName=Convert.ToString(dr1);tmp.EmployeeAge=Convert.ToInt32(dr2);returnedValue.Add(tmp);return returnedValue;WebMethod /添加
14、雇员信息publicvoid Insert(List employee)employee.ForEach(x=string CmdText=INSERT INTO Employee(EmployeeName,EmployeeAge)VALUES(+x.EmployeeName+,+x.EmployeeAge.ToString()+);SQLExcute(CmdText););WebMethod /更新雇员信息publicvoid Update(List employee)employee.ForEach(x=stringCmdText=UPDATE Employee SET EmployeeN
15、ame=+x.EmployeeName+,EmployeeAge=+x.EmployeeAge.ToString();文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4
16、L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8
17、W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T
18、8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5
19、D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:C
20、F8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV
21、9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10文档编码:CF8W9D3D5T5 HV9T8N2F2R2 ZM7C5D4L7K10 CmdText+=WHERE EmployeeID=+x.EmployeeID.ToString();SQLExcute(CmdText););
22、WebMethod /删除雇员信息publicvoid Delete(List employee)employee.ForEach(x=string CmdText=DELETE FROM Employee WHERE EmployeeID=+x.EmployeeID.ToString();SQLExcute(CmdText););/执行 SQL命令文本,重载 1privatevoid SQLExcute(string SQLCmd)string ConnectionString=server=localhost;user id=root;password=yourpassword;datab
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Silverlight 访问 数据库 MySQL
![提示](https://www.deliwenku.com/images/bang_tan.gif)
限制150内