C# - MysqlDataReader not reading

Question

This is the code atm:

if (e.KeyCode == Keys.Enter && chatTextRTB.Text.Length > 0) <br>
        {
            con.Open();
            MySqlDataReader mdr;
            MySqlCommand cmd;
            string sq6 = ("UPDATE `new`.`chat_mod` SET `cCstatus`= cCstatus + 1 WHERE  `ID`= 1;");
            cmd = new MySqlCommand(sq6, con);
            mdr = cmd.ExecuteReader();

            if (mdr.Read())
            {
                ***chatClean = mdr.GetInt32("cCstatus");***
                if(chatClean > 20)
                {
                    sq6 = ("UPDATE `new`.`chat_mod` SET `cCfirst`= cCfirst + 1, `cClast`= cClast+1 WHERE  `ID`= 1;");
                }
            }
            con.Close(); </pre>

chatClean = mdr.GetInt32("cCstatus");

isnt recieving any data from the table.

You're performing an update. that doesn't return a data set to read. — Wheels73, Mar 15 '17 at 09:16

score 0 · Accepted Answer · answered Mar 15 '17 at 09:20

Updates do not return data. They return the number of rows affected. You should call ExecuteNonQuery instead of ExecuteReader.

This answer suggests to make a procedure that selects what you've updated, although the method used isn't entirely safe since you can end up with rows that were added/removed between the two statements.

C# - MysqlDataReader not reading

1 Answers1