Inserting radio buttons values into a database

[steve_rm]

Hello,

I have a database with 3 fields High and Low. The datatype in the database using MS Access is 'YesNo'.

I have this code in Visual C#

OleDbCommand cmdInsert = cnnstrInsert.CreateCommand();
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = @"INSERT INTO Customer(Customer, High, Low) VALUES('" + txtCustID.Text + "', '" + radHigh.Checked + "', "' + radLow.Checked + "') ";

cmdInsert.ExecuteNonQuery();

There is nothing wrong with the actual syntax, but how do l send the values for the radio buttons to the database.

I keep getting a error msg say "incorrect datatype match". So started to do some testing and used this in the connection string instead.

@"INSERT INTO Customer(Customer, High, Low) VALUES('" + txtCustID.Text + "', 'True', 'False') ";

This still gave the same error.

Can anyone tell me the correct way to insert the values of radio buttons into a database.

Many thanks in advance,

Steve

[Granty]

Have you tried the 2nd way but without quotes around the True and False?

[Ecniv]

No quotes around true/false - or put 0 for false and -1 for true...

Not sure of C#'s syntax - vb one would be:

cmdInsert.CommandText = @"INSERT INTO Customer(Customer, High, Low) VALUES('" + txtCustID.Text + "', '" + (radHigh.Checked=true) + "', "' + (radLow.Checked=true) + "') ";

.checked might be =1 - I can't remember


Vince