C# (CSharp) packages.mysql.mysqlConnection Beispiele

Beispiel #1

Datei: employees.xaml.cs Projekt: n1ghtdev/dashboard-data-app

 private void loadTable()
 {
     packages.mysql.mysqlConnection mySqlConnection = new packages.mysql.mysqlConnection("SELECT employees.id, firstname as 'Імя', surname as 'Призвище', patronymic as 'По батькові', divisions.name as 'Відділ' FROM", "employees", this.dataGrid, "JOIN divisions ON employees.DIVISIONS_id = divisions.id");
 }

Beispiel #2

 private void loadTable()
 {
     packages.mysql.mysqlConnection mySqlConnection = new packages.mysql.mysqlConnection("SELECT id, name as 'Назва обладнання', divisions_id as 'Відділ', description, technical_data FROM", databaseTable, this.dataGrid);
 }

Beispiel #3

Datei: services.xaml.cs Projekt: n1ghtdev/dashboard-data-app

 private void loadTable()
 {
     packages.mysql.mysqlConnection mySqlConnection = new packages.mysql.mysqlConnection("SELECT id, name as 'Назва послуги', price_per_unit as 'Ціна за одиницю' FROM", databaseTable, this.dataGrid);
 }

Beispiel #4

 private void loadTable()
 {
     packages.mysql.mysqlConnection mySqlConnection = new packages.mysql.mysqlConnection("SELECT id, main_sub as 'Код главного отдела', name as 'Название отдела' FROM", databaseTable, this.dataGrid);
 }

Beispiel #5

Datei: orders.xaml.cs Projekt: n1ghtdev/dashboard-data-app

 private void loadTable()
 {
     packages.mysql.mysqlConnection mySqlConnection = new packages.mysql.mysqlConnection("SELECT description, id as '№', quantity as 'Кількість', client_name as 'Імя клієнта', publish_date as 'Дата замовлення', completion_date as 'Дата виконання', SERVICES_id FROM", databaseTable, this.dataGrid);
 }