C# MySql Class // Connection Open and Close -

C# MySql Class // Connection Open and Close -

i got problem. stack! don't know if need new class it! want methode closing connection via button click.

i created constructor:

public string server; public string username; public string pwd; public string db; mysqlconnection conn; string connstring; public dbverb(string eserver, string eusername, string epwd, string edb) { this.server = eserver; this.username = eusername; this.pwd = epwd; this.db = edb; }

and 2 methods:

public void connect(system.windows.forms.label lblstatus) { seek { connstring = string.format("server={0};user id={1}; password={2}; database={3}; pooling=false", this.server, this.username, this.pwd, this.db); conn = new mysqlconnection(); conn.connectionstring = connstring; if (conn != null) conn.close(); conn.open(); if (conn.state == connectionstate.open) { lblstatus.text = string.format("verbindung zu {0} user: {1} zeit: {2}", this.server, this.username, datetime.now.tostring()); } else { messagebox.show("felher"); } } grab (exception ex) { messagebox.show(ex.message, "fehler:", messageboxbuttons.ok, messageboxicon.error); } } public void clconnect() { conn = new mysqlconnection(); if (conn.state == connectionstate.open) { conn.close(); } }

here i'm calling methode:

private void cmdherstellen_click(object sender, eventargs e) { string lserver = txtbserv.text; string luid = txtbuid.text; string lpawd = txtbpass.text; string ldb = txtbdat.text; dbverb verbindungherstellen = new dbverb(lserver, luid, lpawd, ldb); verbindungherstellen.err(); verbindungherstellen.connect(lblstatus); } private void cmdabbr_click(object sender, eventargs e) { }

if phone call method clconnect() have give arguments parameter, did, don't work.

any thought how it?

you storing dbconnection field in class. when want close don't want assign new connection object conn = new mysqlconnection(); , instead want remove line , replace check see if conn null or not. if null no work needs done (or maybe error) , if not null can check if open , close if appropriate.

you want careful of creating new objects in connect method. if conn exists don't want (or need to) create new connection object.

my lastly comment there wrong sounding user needing click button close connection. should soemthign code worries , not user. however, don't know doing can't wrong, feels bit wrong. :)

c# mysql database-connection