Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class ItemGrid
- {
- public string clas { get; set; }
- public string lastName { get; set; }
- public string firstName { get; set; }
- public string rating { get; set; }
- }
- private void Button_Click(object sender, RoutedEventArgs e)
- {
- string serverName = ""; // Адрес сервера БД (для локальной базы пишите "localhost")
- string userName = ""; // Имя пользователя БД
- string dbName = ""; //Имя базы данных
- string port = "3306"; // Порт для подключения
- string password = ""; // Пароль для подключения
- string connStr = "server=" + serverName +
- ";user=" + userName +
- ";database=" + dbName +
- ";port=" + port +
- ";password=" + password + ";charset=utf8";
- try
- {
- MySqlCommand command = new MySqlCommand();
- MySqlConnection connection = new MySqlConnection(connStr);
- string sql = "SELECT * FROM student;";
- command.CommandText = sql;
- command.Connection = connection;
- MySqlDataReader reader;
- try
- {
- command.Connection.Open();
- reader = command.ExecuteReader();
- dataGridResult.Items.Clear();
- while (reader.Read())
- {
- dataGridResult.Items.Add(new ItemGrid() {
- clas = reader["class"].ToString(),
- lastName = reader["lastName"].ToString(),
- firstName = reader["firstName"].ToString(),
- rating = reader["rating"].ToString() });
- }
- reader.Close();
- }
- catch (MySqlException ex)
- {
- Console.WriteLine("Error: \r\n{0}", ex.ToString());
- }
- }
- catch
- {
- MessageBox.Show("Внимание!\nПри получении данных возникла ошибка!", "Ошибка!");
- }
- }
RAW Paste Data