I want to make multiple mysql queries in the same time in C# -
i have code, when run select query works. when run insert query works. 2 queries can't work @ same time. don't know what's problem???! can me
public partial class signupfm : form { string str = @"server=localhost;database=bullivant_arabia_archive;userid=root;password='';"; mysqlconnection con = null; mysqlcommand cmd = null; public signupfm() { initializecomponent(); } private void signupbt_click(object sender, eventargs e) { try { con = new mysqlconnection(str); con.open(); if(checkuser(usernametb.text)) { if (password1tb.text == password2tb.text) { insertuser(this.usernametb.text, this.password1tb.text); } else { messagebox.show("you haven't enter same password twice"); } } else { messagebox.show("the user name exist, please enter one!"); } } catch (mysqlexception err) { console.writeline("error: " + err.tostring()); } { if (con != null) { con.close(); } } } public void insertuser(string username, string password) { string userquery = @"insert login (username,password) values ('" + username + "' , '" + password + "')"; if (executeinsertquery(userquery)) messagebox.show("sign have been completed"); else messagebox.show("sign couldn't completed"); } bool checkuser (string username) { string query = @"select * login username = '" + username + "'"; if (executeselectquery(query)) return false; else return true; } bool executeselectquery(string query) { cmd = new mysqlcommand(query, con); if (cmd.executereader().read()) return true; else return false; } bool executeinsertquery(string query) { cmd = new mysqlcommand(query, con); if (cmd.executenonquery() == 1) return true; else return false; }
please share exact error getting. in opinion can't use same connection perform multiple queries. you'll fine using multiple connections, connection pooling works great mysql.
Comments
Post a Comment