getemployeeinformation.cs

蓝山人事管理系统

using System;
using System.Data ;
using System.Data .SqlClient ;

namespace BlueHill.BlueHillWindows.SalaryManagement
{
	
	/// GetEmployeeInformation 的摘要说明。
// 连接数据库并为FormDepartmentSum创建资源
	public class GetEmployeeInformation
	{
		
			public SqlConnection conn=null;
			public SqlDataAdapter adp=null;
			public DataSet ds=null;
			public string deptname;
		public DataSet displayEmployee()
		{
			conn=new SqlConnection ("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			adp=new SqlDataAdapter ("select *from tblEmployee where DeptID=(select DeptID from tblDepartment where DeptName='"+deptname+"')",conn);
			ds=new DataSet ();
			adp.Fill (ds,"tblEmployee");
			return ds;
		}
			
		
	}

}