employeesdata.cs

《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含的源代码.非常经典的一本asp.net2.0的书籍

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// Summary description for Employees
/// </summary>
public class EmployeesData
{
	protected string connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

	//Select员工数据
	public DataView SelectEmployee()
	{
		string strCmd = "Select EmployeeID,LastName,City,Country from Employees";
		SqlDataSource sqlds = new SqlDataSource(connString, strCmd);
		return (DataView)sqlds.Select(DataSourceSelectArguments.Empty);	//返回DataView
	}

	//Update员工数据
	public void UpdateEmployee(string EmployeeID,string LastName,string City,string Country)
	{
		string strCmd = "Update Employees set LastName=@paramLastName,City=@paramCity,Country=@paramCountry where EmployeeID=@paramEmployeeID";
		SqlDataSource sqlds = new SqlDataSource();
		sqlds.ConnectionString = connString;
		sqlds.UpdateCommand = strCmd;
		sqlds.UpdateParameters.Add("paramLastName",TypeCode.String,LastName);
		sqlds.UpdateParameters.Add("paramCity", TypeCode.String, City);
		sqlds.UpdateParameters.Add("paramCountry", TypeCode.String,Country);
		sqlds.UpdateParameters.Add("paramEmployeeID", TypeCode.Int16,EmployeeID);
		sqlds.Update();
	}

	//Delete员工数据
	public void DeleteEmployees(string EmployeeID)
	{
		string strCmd = "Delete from Employees where EmployeeID=@paramEmployeeID";
		SqlDataSource sqlds = new SqlDataSource();
		sqlds.ConnectionString = connString;
		sqlds.DeleteCommand= strCmd;
		sqlds.DeleteParameters.Add("paramEmployeeID", TypeCode.String, EmployeeID);
		sqlds.Delete();
	}

	//Insert员工数据
	public void InsertEmployee(string LastName,string FirstName,string City, string Country)
	{
		string strCmd = "Insert into Employees (LastName,FirstName,City,Country) values (@paramLastName,@paramFirstName,@paramCity,@paramCountry)";
		SqlDataSource sqlds = new SqlDataSource();
		sqlds.ConnectionString = connString;
		sqlds.InsertCommand = strCmd;
		sqlds.InsertParameters.Add("paramLastName", TypeCode.String, LastName);
		sqlds.InsertParameters.Add("paramFirstName", TypeCode.String, FirstName);
		sqlds.InsertParameters.Add("paramCity", TypeCode.String, City);
		sqlds.InsertParameters.Add("paramCountry", TypeCode.String, Country);
		sqlds.Insert();
	}
}