Mysql update query not running ASP.NET

Question

My mysql query in ASP.NET is not running. I have printed out string session so i know i have the value for it and connection string is working in all other methods so i know the issue is not there. Running the command manually in PHPMyadmin works fine. Another method which looks the same, only with select cmd works.

public IActionResult DeleteProfile()
    {
        string session = HttpContext.Session.GetString("session"); /* gets value (customerid) for user session */

        MySqlConnection conn = new MySqlConnection(connectionString);
        try
        {

            conn.Open();
            string cmdtxt = "UPDATE customer SET active = '0' WHERE customerid = @session";


            MySqlCommand cmd = new MySqlCommand(cmdtxt, conn);

            /**************** SQL PARAMETER ********///

            MySqlParameter parameter = new MySqlParameter();
            cmd.Parameters.AddWithValue("@session", session);

            /**************** SQL PARAMETER ********///


        }
        catch (Exception ex)
        {
            ViewBag.error = "Connection Error!\n" + ex.Message;


        }
        finally
        {

            conn.Close();
            ViewBag.error = "Account deleted";
            HttpContext.Session.Remove("session");
        }                

        return View("../Account/Index");
    }

where your cmd.ExecuteNonQuery(); statement ?

IMParasharG
– IMParasharG

2019-03-07 11:02:48 +00:00
Commented Mar 7, 2019 at 11:02 — IMParasharG
– IMParasharG, Commented Mar 7, 2019 at 11:02

CodeCaster · Accepted Answer · 2019-03-07 11:00:36Z

4

You're correctly instantiating the MySqlCommand and assigning the appropriate parameter, but then you're not doing anything with that command.

You need to execute the query, so it gets sent to the database server:

cmd.ExecuteNonQuery();

answered Mar 7, 2019 at 11:00

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TTT Over a year ago

Ops. I used MySqlDataAdapter on my insert commands in other parts of the code, is it more practial or other pros to use ExecuteNonQuery?

Collectives™ on Stack Overflow

Mysql update query not running ASP.NET

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related