public class EmployeeModel
{
public int EmployeeID { get; set; }
public string EmployeeName { get; set; }
public int EmployeeAge { get; set; }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using MySql.Data.MySqlClient;//引入该命名空间是为了操作MySQL数据库
namespace dataformnmysqldb
/// <summary>
/// Summary description for EmployeesInfoWebService
/// </summary>
[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<EmployeeModel> GetEmployeesInfo()
      {
            List<EmployeeModel> returnedValue = new List<EmployeeModel>();
            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<EmployeeModel> employee)
      {
            employee.ForEach(x =>
            {
                  string CmdText = "INSERT INTO Employee(EmployeeName,EmployeeAge) VALUES('" + x.EmployeeName + "'," + x.EmployeeAge.ToString() + ")";
                  SQLExcute(CmdText);
            });
      }
      [WebMethod] //更新雇员信息
      public void Update(List<EmployeeModel> 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<EmployeeModel> employee)
      {
            employee.ForEach(x =>
            {
                  string CmdText = "DELETE FROM Employee WHERE EmployeeID=" + x.EmployeeID.ToString();
                  SQLExcute(CmdText);
            });
      }
      //执行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();
      }
      //执行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();
      }
}

--转自