how to insert "button.checked " in database mysql

Question

3.00/5 (2 votes)

See more:

i want to insert the button.checked bool but i face problem
this is my code i don't know where is problem?

and this is my error : incorrect integer value :'true' for column 'ThemeColor' at row 1

C#

if (Office2007Blue.Checked == true)
{
    //Blue07();

    try
    {
        _bd = new DataBases();
        _bd.Command.CommandText = " INSERT INTO `Theme`" +
            "(`ThemeColor`) " +
            "VALUES (\"" +
            Office2010Blue.Checked + "\")";
        Debug.WriteLine(Environment.NewLine);
        Debug.WriteLine(_bd.Command.CommandText);
        _bd.Command.ExecuteNonQuery();
    }//try
    catch (Exception ex)
    {
        System.Diagnostics.Debug.WriteLine(Environment.NewLine);
        System.Diagnostics.Debug.WriteLine(ex.Message);
        MessageBox.Show("Une erreur a été détectée : " + Environment.NewLine + ex.Message, "Erreur");
    }//catch
}//end if

Posted 7-Jan-14 20:11pm

Atif BOUZAGLAOUI

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Answer 1 · 2014-01-07T20:35:00

Your ThemeColor field is obviously an integer type and so it is rejecting a bool value input. If you use a parameterised query, then it should succed. Something like this :

C#

_bd = new DataBases();
_bd.Command.CommandText = "INSERT INTO `Theme` (`ThemeColor`) VALUES (@themecolor)";
_bd.Command.Parameters.AddWithValue("themecolor", Office@010Blue.Checked);

//etc

Atif BOUZAGLAOUI · Answer 2 · 2014-01-08T03:01:00

thank you Wayne Gaylard
what about update ? i try this but if does not work

C#

try
            {
                //_bd.Command.CommandText = "UPDATE `Theme` " +
                //    "SET ThemeColor = \"" + Office2010Blue.Checked +
                //    "\"";
                _bd.Command.CommandText = "Update `Theme` SET (`ThemeColor`) VALUES   (@themecolor)";
                _bd.Command.Parameters.AddWithValue("themecolor", Office2007Blue.Checked);
                Debug.WriteLine(Environment.NewLine);
                Debug.WriteLine(_bd.Command.CommandText);
                _bd.Command.ExecuteNonQuery();
            }//try
            catch (Exception ex)
            {
                Debug.WriteLine(Environment.NewLine);
                Debug.WriteLine(ex.Message);
                MessageBox.Show("Une erreur a été détectée : " + Environment.NewLine + ex.Message, "Erreur");
            }//catch

Naz_Firdouse · Answer 3 · 2014-01-08T03:18:00

Solution 3

The update statement should be like thid

C#

_bd.Command.CommandText = "Update `Theme` SET ThemeColor = @themecolor";

 _bd.Command.Parameters.AddWithValue("@themecolor", Office2007Blue.Checked);

refer this for more info
sqlparametercollection.addwithvalue

Posted 8-Jan-14 3:18am

Naz_Firdouse

Updated 8-Jan-14 3:26am

v5

how to insert "button.checked " in database mysql

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0