public bool ExecuteInsertUpdateQuery(string query) { using (MySqlConnection con = C4LDatabase.GetConnection()) { var cmd = new MySqlCommand(); try { cmd.Connection = con; cmd.CommandText = query; cmd.CommandType = System.Data.CommandType.Text; con.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } catch (Exception ex) { //Logger.Error(ex.Message); //Logger.Error(ex.StackTrace); return(false); } finally { cmd.Dispose(); } } }
public object ExecuteScalar(string query) { using (MySqlConnection con = C4LDatabase.GetConnection()) { var cmd = new MySqlCommand(); try { cmd.Connection = con; cmd.CommandText = query; cmd.CommandType = System.Data.CommandType.Text; con.Open(); var result = cmd.ExecuteScalar(); return(result); } catch (Exception ex) { //Logger.Error(ex.Message); //Logger.Error(ex.StackTrace); } finally { cmd.Dispose(); } } return(null); }
public DataRowCollection ExecuteSelectQuery(string query) { using (MySqlConnection con = C4LDatabase.GetConnection()) { var cmd = new MySqlCommand(); try { cmd.Connection = con; cmd.CommandText = query; cmd.CommandType = System.Data.CommandType.Text; DataSet ds = new DataSet(); MySqlDataAdapter ad = new MySqlDataAdapter(); ad.SelectCommand = cmd; con.Open(); ad.Fill(ds); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0].Rows); } } catch (Exception ex) { //Logger.Error(ex.Message); //Logger.Error(ex.StackTrace); } finally { cmd.Dispose(); } } return(null); }