execute scalar gives error when no returning data code example
Example: mysql executeScalar only if successful
MySqlCommand cmd = new MySqlCommand(connection);
cmd.CommandText = sqlstring;
Object userNameObj = cmd.ExecuteScalar();
if (userNameObj != null)
string returnedName = userNameObj.ToString();
...