public static void ExecuteQuery(string query) { MySqlCommand mySqlCommand = new MySqlCommand(query, DBConfig.Connection); try { //MySqlDataReader reader = mySqlCommand.ExecuteReader(); mySqlCommand.ExecuteNonQuery(); DBConfig.CloseConnection(); Console.WriteLine("Query has been successfully executed."); } catch (Exception ex) { DBConfig.CloseConnection(); Console.WriteLine("ERROR: " + ex.Message); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtFirstName.Text) && !String.IsNullOrEmpty(txtLastName.Text) && !String.IsNullOrEmpty(txtEmail.Text) && !String.IsNullOrEmpty(txtEmailReenter.Text) && !String.IsNullOrEmpty(txtPassword.Text)) { if (txtEmail.Text == txtEmailReenter.Text) { Application["FirstName"] = txtFirstName.Text; Application["LastName"] = txtLastName.Text; Application["Email"] = txtEmail.Text; Application["Password"] = txtPassword.Text; DBConfig.InsertUser(txtFirstName.Text, txtLastName.Text, txtEmail.Text, txtPassword.Text); Response.Redirect("Result.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { DBConfig.Init(); }