C# (CSharp) DataAccess.DataSetTableAdapters.sp_SearchProjectByGroupTableAdapter Beispiele

Beispiel #1

        public List <DTO_Project> GetProjectByGroup(string groupName)
        {
            try
            {
                DataAccess.DataSetTableAdapters.sp_SearchProjectByGroupTableAdapter adapter = new DataAccess.DataSetTableAdapters.sp_SearchProjectByGroupTableAdapter();
                DataAccess.DataSet.sp_SearchProjectByGroupDataTable table = adapter.GetData(groupName);

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

                foreach (DataAccess.DataSet.sp_SearchProjectByGroupRow 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>());
            }
        }

Beispiel #2

Datei: ProjectExplorerBusiness.cs Projekt: diemhuongpie/QuanLyDoAn_OOD

        public List<DTO_Project> GetProjectByGroup(string groupName)
        {
            try
            {
                DataAccess.DataSetTableAdapters.sp_SearchProjectByGroupTableAdapter adapter = new DataAccess.DataSetTableAdapters.sp_SearchProjectByGroupTableAdapter();
                DataAccess.DataSet.sp_SearchProjectByGroupDataTable table = adapter.GetData(groupName);

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

                foreach (DataAccess.DataSet.sp_SearchProjectByGroupRow 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>();
            }
        }