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]);
}
}
}
