建站
咨詢
售后
建站咨詢
新聞中心
Silverlight與MySQL數(shù)據(jù)庫(kù)互操作，也是因?yàn)镸ySQL在平時(shí)開發(fā)中應(yīng)用得很多，適合大多數(shù)開發(fā)環(huán)境與要求。本文用到的MySQL環(huán)境是MySQL Connector Net 6.1.1，需要大家提前安裝。
創(chuàng)新互聯(lián)響應(yīng)式網(wǎng)站特點(diǎn)就是不管在電腦、平板還是手機(jī)上，H5網(wǎng)站設(shè)計(jì)都會(huì)根據(jù)屏幕尺寸自動(dòng)調(diào)節(jié)大小、圖片分辨率，并且融入一定的動(dòng)畫特效，讓網(wǎng)站看起來非常的美觀大方。從網(wǎng)站需求對(duì)接到網(wǎng)站制作設(shè)計(jì)、從代碼編寫到項(xiàng)目上線運(yùn)維，技術(shù)人員全程跟蹤，快速響應(yīng)
準(zhǔn)備工作
1）建立起測(cè)試項(xiàng)目
細(xì)節(jié)詳情請(qǐng)見強(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的MySQL數(shù)據(jù)庫(kù)，建立數(shù)據(jù)表名稱為Employee。
3）安裝MySQL Connector Net 6.1.1
為了能讓.NET操作MySQL數(shù)據(jù)庫(kù)，請(qǐng)務(wù)必安裝。
建立數(shù)據(jù)模型
EmployeeModel.cs文件（放置在服務(wù)端項(xiàng)目文件夾下）
- using System;
- using System.Collections.Generic;
- using System.Linq;
- namespace dataformnmysqldb
- {
- public class EmployeeModel
- {
- public int EmployeeID { get; set; }
- public string EmployeeName { get; set; }
- public int EmployeeAge { get; set; }
- }
- }
建立服務(wù)端Web Service
右擊服務(wù)端項(xiàng)目文件夾，選擇Add->New Item....，按下圖所示建立一個(gè)名為EmployeesInfoWebService.asmx的Web Service，作為Silverlight與MySQL數(shù)據(jù)庫(kù)互操作的橋梁。
在Silverlight客戶端應(yīng)用程序文件夾下，右擊References文件夾，添加名為MySql.Data的命名空間。之后，雙擊EmployeesInfoWebService.asmx打開該文件，將里面的內(nèi)容修改如下：
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.Services;
- using System.Data;
- using MySql.Data.MySqlClient;//引入該命名空間是為了操作MySQL數(shù)據(jù)庫(kù)
- 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 script, using ASP.NET AJAX, uncomment the following line.
- // [System.Web.Script.Services.ScriptService]
- public class EmployeesInfoWebService : System.Web.Services.WebService
- {
- [WebMethod]//獲取雇員信息
- public List GetEmployeesInfo()
- {
- List returnedValue = new List ();
- MySqlCommand Cmd = new MySqlCommand();
- SQLExcute("SELECT * FROM Employee", Cmd);
- MySqlDataAdapter EmployeeAdapter = new MySqlDataAdapter();
- EmployeeAdapter.SelectCommand = Cmd;
- DataSet EmployeeDataSet = new DataSet();
- EmployeeAdapter.Fill(EmployeeDataSet);
- foreach (DataRow dr in EmployeeDataSet.Tables[0].Rows)
- {
- EmployeeModel tmp = new EmployeeModel();
- tmp.EmployeeID = Convert.ToInt32(dr[0]);
- tmp.EmployeeName = Convert.ToString(dr[1]);
- tmp.EmployeeAge = Convert.ToInt32(dr[2]);
- returnedValue.Add(tmp);
- }
- return returnedValue;
- }
- [WebMethod] //添加雇員信息
- public void Insert(List employee)
- {
- employee.ForEach(x =>
- {
- string CmdText = "INSERT INTO Employee(EmployeeName,EmployeeAge) VALUES('" + x.EmployeeName + "'," + x.EmployeeAge.ToString() + ")";
- SQLExcute(CmdText);
- });
- }
- [WebMethod] //更新雇員信息
- public void Update(List employee)
- {
- employee.ForEach(x =>
- {
- string CmdText = "UPDATE Employee SET EmployeeName='" + x.EmployeeName + "',EmployeeAge=" + x.EmployeeAge.ToString();
- CmdText += " WHERE EmployeeID=" + x.EmployeeID.ToString();
- SQLExcute(CmdText);
- });
- }
- [WebMethod] //刪除雇員信息
- public void Delete(List employee)
- {
- employee.ForEach(x =>
- {
- string CmdText = "DELETE FROM Employee WHERE EmployeeID=" + x.EmployeeID.ToString();
- SQLExcute(CmdText);
- });
- }
- //執(zhí)行SQL命令文本，重載1
- private void SQLExcute(string SQLCmd)
- {
- string ConnectionString = "server=localhost;user id=root;password=yourpassword;database=employees";
- MySqlConnection Conn = new MySqlConnection(ConnectionString);
- Conn.Open();
- MySqlCommand Cmd = new MySqlCommand();
- Cmd.Connection = Conn;
- Cmd.CommandTimeout = 15;
- Cmd.CommandType = System.Data.CommandType.Text;
- Cmd.CommandText = SQLCmd;
- Cmd.ExecuteNonQuery();
- Conn.Close();
- }
- //執(zhí)行SQL命令文本，重載2
- private void SQLExcute(string SQLCmd, MySqlCommand Cmd)
- {
- string ConnectionString = "server=localhost;user id=root;password= yourpassword;database=employees";
- MySqlConnection Conn = new MySqlConnection(ConnectionString);
- Conn.Open();
- Cmd.Connection = Conn;
- Cmd.CommandTimeout = 15;
- Cmd.CommandType = System.Data.CommandType.Text;
- Cmd.CommandText = SQLCmd;
- Cmd.ExecuteNonQuery();
- }
- }
- }
之后，在Silverlight客戶端應(yīng)用程序文件夾下，右擊References文件夾，選擇菜單選項(xiàng)Add Service Reference...。如下圖所示，引入剛才我們創(chuàng)建的Web Service（別忘了按Discover按鈕進(jìn)行查找）。
創(chuàng)建Silverlight客戶端應(yīng)用程序
詳情參見我的[原創(chuàng)]Silverlight與Access數(shù)據(jù)庫(kù)的互操作(CURD完全解析)。
Silverlight與MySQL數(shù)據(jù)庫(kù)互操作最終效果圖
文章標(biāo)題：詳解Silverlight與MySQL數(shù)據(jù)庫(kù)互操作
當(dāng)前網(wǎng)址：http://www.5511xx.com/article/dhocddc.html
