c# - Change parameter at form load and close -

c# - Change parameter at form load and close -

i writing application in c#. need send value when open edit form sql table contains bit value. value of 1 represents open, , value of 0 represents closed. need pass 1 when open edit form record, , set 0 there when leave form. how can this?

you can handle in load , closed event handlers.

when open, can have this:

public myform_load(object sender, eventargs e) { // phone call function bit set, or set here. setbit(1, rownumber); }

and closed identical:

public myform_closed(object sender, eventargs e) { setbit(0, rownumber); }

hope helps.

edit sort of making assumption issue when , where set bit, , not how. if having problem writing query set bit, allow me know. function this:

private setbit(int open, int rowid) { using(mysqlconnection conn = new mysqlconnection(cs)) // assuming you've built connection string. { conn.open(); using(mysqlcommand cmd = new mysqlcommand()) { cmd.connection = conn; cmd.commandtext = "update tablename set columnname = @open rowid = @id"; cmd.parameters.addwithvalue("@open", open); cmd.parameters.addwithvalue("@id", rowid); cmd.executenonquery(); } conn.close(); } }

of course, practice set in try/catch block, wanted cover in case gave trouble.

edit 2 have edited code above. note going changing open/close value of specific row (at least, that's how question appears) need find way row id , pass setbit function, because need in there where clause of sql statement update proper row. challenge figure out how row id, , if stuck, sense free come help.

c# sql winforms