save checkbox value in access database with vb.net 2010 (wpf c#)

Question

guy how can i insert the value of checkbox in access database or any database.

i tried any of this sql statement but it still give me error: OleDbException was Unhandled. Data type mismatch in criteria expression. and it's pointing to myData = myCommand.ExecuteReader();

note that allowviewpsr is a boolean type of field in ms access database or the one with YES/NO. :) chkviewpsr is mycheckbox

SQL = "UPDATE `RUsers` SET `allowviewpsr` = '" + chkviewpsr.IsChecked.Value + "' WHERE `idnum`= '" + txtblkuserid.Text  + "' AND `fullname`= '" + txtblkusername.Text + "'";

also this:

SQL = "UPDATE `RUsers` SET `allowviewpsr` = '" + chkviewpsr.IsChecked + "' WHERE `idnum`= '" + txtblkuserid.Text  + "' AND `fullname`= '" + txtblkusername.Text + "'";

and also this:

SQL = "UPDATE `RUsers` SET `allowviewpsr` = '" + chkviewpsr + "' WHERE `idnum`= '" + txtblkuserid.Text  + "' AND `fullname`= '" + txtblkusername.Text + "'";

and here's my connector:

myCommand.CommandText = SQL;
myCommand.Connection = MyNewOleDbConnection;
myAdapter.SelectCommand = myCommand;
myData = myCommand.ExecuteReader();

EDITED: hi anandkumar thanks for the quick replay i tried NonQuery but it gives same error as above

SQL = "UPDATE `RWMUsers` SET `allowviewpsr` = '" + chkviewpsr.IsChecked.Value + "' WHERE `idnum`= '" + txtblkuserid.Text  + "' AND `fullname`= '" + txtblkusername.Text + "'";
myCommand.CommandText = SQL;
myCommand.Connection = MyNewOleDbConnection;
myAdapter.UpdateCommand = myCommand;
myCommand.ExecuteNonQuery();

Snapshot of my Access Database :(

enter image description here

there is some bad practice in this code ;) you should read about query injection and how to avoid it. — Felice Pollano
– Felice Pollano, Commented Oct 30, 2012 at 6:09
can you give me sample on how can i create a right sql statement... thanks :( — Kenshi Hemura
– Kenshi Hemura, Commented Oct 30, 2012 at 6:17
@KenshiHemura, Please upload the table constraints and column types of "RWMUsers" — andy
– andy, Commented Oct 30, 2012 at 6:20
@KenshiHemura use Parameters to deal with variables in your sql queries. — Felice Pollano
– Felice Pollano, Commented Oct 30, 2012 at 7:40
@Felice Pollano thanks for the reply.. im sorry im not that good in c#.. can you give me an example if you dont mind. thanks :( — Kenshi Hemura
– Kenshi Hemura, Commented Oct 30, 2012 at 7:50

andy · Accepted Answer · 2012-10-30 06:07:09Z

3

Instead of

myAdapter.SelectCommand = myCommand;
myCommand.ExecuteReader();

Use

myAdapter.UpdateCommand = myCommand;
myCommand.ExecuteNonQuery();

Reference:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand.aspx

answered Oct 30, 2012 at 6:07

andy

6,0792 gold badges29 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

save checkbox value in access database with vb.net 2010 (wpf c#)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related