C# (CSharp) DataAccess.DataSetTableAdapters.sp_SearchProjectBySubjectTableAdapter示例

示例#1

        public List <DTO_Project> GetProjectBySubject(string subjectName)
        {
            try
            {
                DataAccess.DataSetTableAdapters.sp_SearchProjectBySubjectTableAdapter adapter = new DataAccess.DataSetTableAdapters.sp_SearchProjectBySubjectTableAdapter();
                DataAccess.DataSet.sp_SearchProjectBySubjectDataTable table = adapter.GetData(subjectName);

                List <DTO_Project> result = new List <DTO_Project>();

                foreach (DataAccess.DataSet.sp_SearchProjectBySubjectRow row in table.Rows)
                {
                    result.Add(new DTO_Project(
                                   row.ProjectName, row.GroupName, row.SubjectName, row.Class));
                }

                return(result);
            }
            catch (Exception)
            {
                return(new List <DTO_Project>());
            }
        }

示例#2

文件： ProjectExplorerBusiness.cs 项目： diemhuongpie/QuanLyDoAn_OOD

        public List<DTO_Project> GetProjectBySubject(string subjectName)
        {
            try
            {
                DataAccess.DataSetTableAdapters.sp_SearchProjectBySubjectTableAdapter adapter = new DataAccess.DataSetTableAdapters.sp_SearchProjectBySubjectTableAdapter();
                DataAccess.DataSet.sp_SearchProjectBySubjectDataTable table = adapter.GetData(subjectName);

                List<DTO_Project> result = new List<DTO_Project>();

                foreach (DataAccess.DataSet.sp_SearchProjectBySubjectRow row in table.Rows)
                {
                    result.Add(new DTO_Project(
                        row.ProjectName, row.GroupName, row.SubjectName, row.Class));
                }

                return result;
            }
            catch (Exception)
            {
                return new List<DTO_Project>();
            }
        }