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();
}
}
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; ////
}
private void Form1_Load(object sender, EventArgs e)
{
ShopDB shopDB = new ShopDB();
var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter();
ShopDB.CustomersDataTable customers = customersTableAdapter.GetData();
dataGridView1.DataSource = customers;
var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter();
ShopDB.EmployeesDataTable employees = employeesTableAdapter.GetData();
dataGridView2.DataSource = employees;
}
