private void Form1_Load(object sender, EventArgs e) { ShopDB shopDB = new ShopDB(); var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); employeesTableAdapter.Fill(shopDB.Employees); var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); ordersTableAdapter.Fill(shopDB.Orders); ShopDB.EmployeesDataTable employees = employeesTableAdapter.GetData(); ShopDB.OrdersDataTable orders = ordersTableAdapter.GetData(); employees.Columns.Add("Count", typeof(int)); foreach (DataRow employeeRow in employees.Rows) { employeeRow["Count"] = orders.Count(o => o.EmployeeID == (int)employeeRow["EmployeeID"]); } dataGridView1.DataSource = employees; this.dataGridView1.Columns["FName"].Visible = false; this.dataGridView1.Columns["LName"].Visible = false; this.dataGridView1.Columns["MName"].Visible = false; this.dataGridView1.Columns["Salary"].Visible = false; this.dataGridView1.Columns["PriorSalary"].Visible = false; this.dataGridView1.Columns["HireDate"].Visible = false; this.dataGridView1.Columns["TerminationDate"].Visible = false; this.dataGridView1.Columns["ManagerEmpID"].Visible = false; //// }
static void Main(string[] args) { ShopDB shopDB = new ShopDB(); var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); employeesTableAdapter.Fill(shopDB.Employees); var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); ordersTableAdapter.Fill(shopDB.Orders); var orderDetailsTableAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); orderDetailsTableAdapter.Fill(shopDB.OrderDetails); ShopDB.EmployeesDataTable employees = employeesTableAdapter.GetData(); ShopDB.OrdersDataTable orders = ordersTableAdapter.GetData(); employees.Columns.Add("Count", typeof(int)); foreach (DataRow employeeRow in employees.Rows) { employeeRow["Count"] = orders.Count(o => o.EmployeeID == (int)employeeRow["EmployeeID"]); foreach (DataColumn column in employees.Columns) { if (column.ColumnName == "EmployeeID" || column.ColumnName == "Count") { Console.WriteLine("{0}: {1}", column.ColumnName, employeeRow[column]); } } Console.WriteLine(); } }