C# (CSharp) PersonDataSetTableAdapters.PersonTableAdapter Examples

Example #1

File: MyDataSet.cs Project: coderisrael/a-programmer-guide-to-csharp-5.0

        public static void Test()
        {
            PersonDataSetTableAdapters.PersonTableAdapter personTableAdapter =
                new PersonDataSetTableAdapters.PersonTableAdapter();

            PersonDataSet.PersonDataTable personDataTable = personTableAdapter.GetData();

            foreach (PersonDataSet.PersonRow personRow in personDataTable.Rows)
            {
                Console.WriteLine(personRow.PersonType);
            }
        }

Example #2

File: MyDataSet.cs Project: coderisrael/a-programmer-guide-to-csharp-5.0

        public static void EmployeesOnlyLinqish()
        {
            PersonDataSetTableAdapters.PersonTableAdapter personTableAdapter =
                new PersonDataSetTableAdapters.PersonTableAdapter();

            PersonDataSet.PersonDataTable personDataTable = personTableAdapter.GetData();

            List <PersonDataSet.PersonRow> persons = new List <PersonDataSet.PersonRow>();

            foreach (PersonDataSet.PersonRow personRow in personDataTable.Rows)
            {
                persons.Add(personRow);
            }

            var employees = persons.Where(person => person.PersonType == "EM");
        }

Example #3

File: MyDataSet.cs Project: coderisrael/a-programmer-guide-to-csharp-5.0

        public static void EmployeesOnly()
        {
            PersonDataSetTableAdapters.PersonTableAdapter personTableAdapter =
                new PersonDataSetTableAdapters.PersonTableAdapter();

            PersonDataSet.PersonDataTable personDataTable = personTableAdapter.GetData();

            List <PersonDataSet.PersonRow> employees = new List <PersonDataSet.PersonRow>();

            foreach (PersonDataSet.PersonRow personRow in personDataTable.Rows)
            {
                if (personRow.PersonType == "EM")
                {
                    employees.Add(personRow);
                }
            }

            foreach (PersonDataSet.PersonRow personRow in employees)
            {
                Console.WriteLine(personRow.LastName);
            }
        }