private void Form1_Load(object sender, EventArgs e) { ShopDB shopDB = new ShopDB(); var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter(); customersTableAdapter.Fill(shopDB.Customers); var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); ordersTableAdapter.Fill(shopDB.Orders); var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); // employeesTableAdapter.Fill(shopDB.Employees); shopDB.Orders.Columns.Add("SurnameEmployee", typeof(String)); shopDB.Orders.Columns.Add("NameEmployee", typeof(String)); shopDB.Orders.Columns.Add("SurnameCustomer", typeof(String)); shopDB.Orders.Columns.Add("NameCustomer", typeof(String)); foreach (var orderRow in shopDB.Orders) { orderRow["NameEmployee"] = orderRow.EmployeesRow.FName; orderRow["SurnameEmployee"] = orderRow.EmployeesRow.LName; orderRow["SurnameCustomer"] = orderRow.CustomersRow.FName; orderRow["NameCustomer"] = orderRow.CustomersRow.LName; } dataGridView1.DataSource = shopDB.Orders; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].Visible = false; dataGridView1.Columns[3].Visible = false; dataGridView1.Columns["OrderDate"].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; }
static void Main(string[] args) { var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter(); ShopDB.CustomersDataTable customers = customersTableAdapter.GetData(); foreach (DataRow customersRow in customers.Rows) { foreach (DataColumn customersColumn in customers.Columns) { Console.WriteLine("{0}: {1}", customersColumn.ColumnName, customersRow[customersColumn]); } Console.WriteLine(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { ShopDB dataBase = new ShopDB(); var empAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); var employees = empAdapter.GetData(); var ordAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); var orders = ordAdapter.GetData(); var ordDetAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); var orderDet = ordDetAdapter.GetData(); employees.Columns.Add("TotalSum", typeof(decimal)); var sum = from em in employees.AsQueryable() join ord in orders.AsQueryable() on em.EmployeeID equals ord.EmployeeID into ordGroup from o in ordGroup join det in orderDet.AsQueryable() on o.OrderID equals det.OrderID into detGroup select new { FName = em.FName, LName = em.LName, Total = detGroup.Sum(od => od.TotalPrice) }; var full = from s in sum.AsQueryable() group s by new { s.FName, s.LName } into g select new { FName = g.Key.FName, LName = g.Key.LName, Total = g.Sum(a => a.Total) }; dtgrd.ItemsSource = full; var custAdap = new ShopDBTableAdapters.CustomersTableAdapter(); DataTable customers = custAdap.GetData(); dtgrd2.ItemsSource = customers.Select("City = 'Киев'"); }
private void Window_Loaded(object sender, RoutedEventArgs e) { ShopDB dataBase = new ShopDB(); var empAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); var employees = empAdapter.GetData(); var ordAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); var orders = ordAdapter.GetData(); var ordDetAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); var orderDet = ordDetAdapter.GetData(); employees.Columns.Add("TotalSum", typeof(decimal)); var sum = from em in employees.AsQueryable() join ord in orders.AsQueryable() on em.EmployeeID equals ord.EmployeeID into ordGroup from o in ordGroup join det in orderDet.AsQueryable() on o.OrderID equals det.OrderID into detGroup select new { FName = em.FName, LName = em.LName, Total = detGroup.Sum(od => od.TotalPrice) }; var full = from s in sum.AsQueryable() group s by new { s.FName, s.LName } into g select new { FName = g.Key.FName, LName = g.Key.LName, Total = g.Sum(a => a.Total) }; dtgrd.ItemsSource = full; var custAdap = new ShopDBTableAdapters.CustomersTableAdapter(); DataTable customers = custAdap.GetData(); dtgrd2.ItemsSource = customers.Select("City = 'Киев'"); }
static void Main(string[] args) { ShopDB shopDB = new ShopDB(); // Для каждой таблицы типизированного DataSet создается адаптер, который позволяет заполнить эту таблицу данными var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter(); // Заполнение таблиц данными производится с помощью вызова метода Fill customersTableAdapter.Fill(shopDB.Customers); foreach (DataRow customersRow in shopDB.Customers.Rows) { foreach (DataColumn customersColumn in shopDB.Customers.Columns) { Console.WriteLine("{0}: {1}", customersColumn.ColumnName, customersRow[customersColumn]); } Console.WriteLine(); } }
static void Main(string[] args) { var customers = new ShopDB.CustomersDataTable(); var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter { ClearBeforeFill = true }; customersTableAdapter.Insert("Test", "Test", "Test", "Test", "Test", "Test", "Test", new DateTime(9999 / 12 / 31)); customers = customersTableAdapter.GetData(); DataRow[] testRows = customers.Select("Phone = 'Test'"); foreach (var testRow in testRows) { foreach (DataColumn customersColumn in customers.Columns) { Console.WriteLine("{0}: {1}", customersColumn.ColumnName, testRow[customersColumn]); } } //***************************************************************************************** Console.WriteLine(new string('-', 20)); Console.WriteLine("Total test row(s) deleted: " + DeleteTestRows()); customers = customersTableAdapter.GetData(); testRows = customers.Select("Phone = 'Test'"); foreach (var testRow in testRows) { foreach (DataColumn customersColumn in customers.Columns) { Console.WriteLine("{0}: {1}", customersColumn.ColumnName, testRow[customersColumn]); } } }