Untitled
unknown
plain_text
2 years ago
2.8 kB
2
Indexable
Never
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using MySql.Data.MySqlClient; using System.Windows.Forms; using System.Data; namespace DataBase { class LICSEC_Connect { MySql.Data.MySqlClient.MySqlConnection lic_conn; string myConnectionString; static string host = "82.209.216.3"; static string database = "sql11471484"; static string userDB = "sqluser"; static string password = "89Baben89"; public static string strProvider = "server=" + host + ";Database=" + database + ";User ID=" + userDB + ";Password=" + password + ";SSL Mode=None"; public bool Open() { try { strProvider = "server=" + host + ";Database=" + database + ";User ID=" + userDB + ";Password=" + password + ";SSL Mode=None"; lic_conn = new MySqlConnection(strProvider); lic_conn.Open(); return true; } catch (Exception er) { MessageBox.Show("Connection Error ! " + er.Message, "Information"); } return false; } public void Close() { lic_conn.Close(); lic_conn.Dispose(); } public DataSet ExecuteDataSet(string sql) { try { DataSet ds = new DataSet(); MySqlDataAdapter da = new MySqlDataAdapter(sql, lic_conn); da.Fill(ds, "result"); return ds; } catch (Exception ex) { MessageBox.Show(ex.Message); } return null; } public MySqlDataReader ExecuteReader(string sql) { try { MySqlDataReader reader; MySqlCommand cmd = new MySqlCommand(sql, lic_conn); reader = cmd.ExecuteReader(); return reader; } catch (Exception ex) { MessageBox.Show(ex.Message); } return null; } public int ExecuteNonQuery(string sql) { try { int affected; MySqlTransaction mytransaction = lic_conn.BeginTransaction(); MySqlCommand cmd = lic_conn.CreateCommand(); cmd.CommandText = sql; affected = cmd.ExecuteNonQuery(); mytransaction.Commit(); return affected; } catch (Exception ex) { MessageBox.Show(ex.Message); } return -1; } } }