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();
}
}
static void Main(string[] args)
{
var customers = new ShopDB.CustomersDataTable();
var customersTableAdapter = new CustomersTableAdapter();
customersTableAdapter.ClearBeforeFill = true;
customersTableAdapter.Insert("test", "test", "test", "test", "test", "test", "test", new DateTime(9999 / 12 / 31));
//var insertedRowNumber = customersTableAdapter.Insert("test", "test", "test", "test", "test", "test", "test", new DateTime(9999 / 12 / 31));
customers = customersTableAdapter.GetData();
DataRow[] testRows = customers.Select("Phone='test'");
foreach (DataRow testRow in testRows)
{
foreach (DataColumn column in customers.Columns)
{
Console.WriteLine($"{column.ColumnName}: {testRow[column]}");
}
Console.WriteLine();
}
//now we're going to delete rows with test phone numbers
Console.WriteLine(new string('*', 30));
Console.WriteLine($"Total test row(s) deleted: {DeleteTestRows()}");
//customersTableAdapter.Delete(insertedRowNumber); //doesn't work with sole int
customers = customersTableAdapter.GetData();
testRows = customers.Select("Phone = 'test'");
foreach (DataRow testRow in testRows)
{
foreach (DataColumn column in customers.Columns)
{
Console.WriteLine($"{column.ColumnName}: {testRow[column]}");
}
}
Console.ReadKey();
}
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]);
}
}
}
