Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using MySql.Data;
- using MySql.Data.MySqlClient;
- //Agregar referencia/paquete NuGet (MySql.Data.dll)
- public class SqlClient
- {
- string Server, DB, Port, Username, Password;
- public SqlClient(string db, string password, string server = "localhost", string port = "3306", string username = "root") //Constructor.
- {
- Server = server; //Setea los parametros en las propiedades de la clase.
- DB = db;
- Port = port;
- Username = username;
- Password = password;
- }
- public void Command(string query)
- {
- string connectionString = $"datasource={Server}, database={DB}, port={Port}, username={Username}, password={Password}"; //Crea un string con los valores necesarios para la conexión.
- MySqlConnection connection = new MySqlConnection(connectionString); //Configura la conexión.
- int columns=0;
- MySqlCommand command = new MySqlCommand(query, connection);
- command.CommandTimeout = 60;
- MySqlDataReader reader;
- try //Intenta ejecutar el comando.
- {
- connection.Open();
- reader = command.ExecuteReader();
- if(reader.HasRows) //Si obtiene valores.
- {
- while(reader.Read())
- {
- for (int a = 0; a < columns; a++) //Mientras "a" sea menor que el número de columnas, aumenta 1 y agrega el valor de cada columna en el array "row".
- {
- string[] row = { reader.GetString(a) };
- }
- }
- }
- connection.Close();
- }
- catch(Exception ex) //En caso de error, crea una excepción y lo muestra en un mensaje de windows.
- {
- System.Windows.Forms.MessageBox.Show(ex.Message);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement