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