ALUES ('1 ',' Finger LTD '); INTO `suppliers` VALUES ('2', 'Ribon Master'); INTO `suppliers` VALUES ('3 ',' JSeven '); INTO `suppliers` VALUES ('5', 'Arm Corp'); INTO `test` VALUES ('1 ', '5' ); INTO `test` VALUES ('2 ', '5'); INTO `test` VALUES ('3 ', '5'); INTO `test` VALUES ('4 ', '5'); INTO `test `VALUES ('5 ', '5'); INTO` test `VALUES ('6 ', '5'); INTO` test `VALUES ('7 ', '5'); INTO` test `VALUES ('8 ', '5'); INTO `type` VALUES ('1 ',' РљоР"СРЉС вЂ РС• '); INTO` type `VALUES ('2', 'РРЋРОјСР‚СРЉРіР В°'); INTO` type `VALUES ('3 ',' Р | РОјРїРС•С вЂЎ РєР В° '); INTO `type` VALUES ('5', 'Braslet'); INTO `type_ex` VALUES ('1 ', '1', '1 ', '50', ' 1 ', '50'); INTO `type_ex` VALUES ('2 ', '2', '2 ', '100', '2 ', '33'); INTO `type_ex` VALUES ('3 ',' 3 ', '3', '45 ', '1', '45 '); INTO `type_ex` VALUES ('4', '1 ', '2', '34 ', '3', '20 ') ;
Додаток 2
Form1. cs
using System; System. Collections. Generic; System.componentModel; System. Data; System. Drawing; System. Linq; System. Text; System. Windows. Forms; MySql. Data. MySqlClient; Kursova9_Den
{partial class Form1: Form
{x = new Int16 (); MySqlCommand cmd; DataTable data; MySqlDataAdapter da; MySqlCommandBuilder cb; MySqlConnection conn; string connStr; Form1 ()
{();
} void button1_Click (object sender, EventArgs e)
{= String. Format ("server = {0}; uid = {1}; pwd = {2}; database = {3}",. TextBox1. Text, this. TextBox2. Text, this. MaskedTextBox1. Text, this. TextBox3 . Text); = new MySqlConnection (connStr);
{. Open ();. Show ("Підключення пройшло успішно!!", "Курсова");
// Заповнюємо Вкладку Предстовленія
{sql = "show full tables where table_type like 'VIEW';"; = new DataTable (); = new MySqlDataAdapter (sql, connStr); = new MySqlCommandBuilder (da);. Fill (data); (int i = 0; i
{. comboBox1. Items. Insert (i, this. Data. Rows [i]. Field (0). ToString ());
}
}
} (Exception ex)
{. Show ("Exception:" + ex. Message);
}
} void comboBox1_SelectedIndexChanged (object sender, EventArgs e)
{sql = ...
