C# (CSharp) DAL SQLHelper.ExecSelect示例

示例#1

        public DataTable Select()
        {
            //这里需要写两个表联合查询
            string cmdText = "SELECT empId, empName, empSex, empBirthday,deptName,postName FROM   Employee ,Department,Positionwhere   Employee.deptId = Department.deptId ANDDepartment.deptId=Position.deptId";

            return(Helper.ExecSelect(cmdText, CommandType.Text));
        }