How Do I Update The Database With Field Yes/No Datatype...I Want To Update The Data From False To True. I Have My Code And It Wont Work..

Question

0.00/5 (No votes)

See more:

C#

con.Open();
command = new OleDbCommand("select * from Instructor where insno=? AND inclass=?", con);
command.Parameters.Add("@insno", OleDbType.VarChar).Value=txtid.Text;
command.Parameters.Add("@inclass", OleDbType.Boolean).Value=false;
adapter.SelectCommand = command;
OleDbDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
    command = new OleDbCommand("UPDATE Instructor SET inclass = ? WHERE insno=?", con);
    command.Parameters.Add("@insno", OleDbType.VarChar).Value = txtid.Text;
    command.Parameters.Add("@inclass", OleDbType.Boolean).Value = false;
    adapter.UpdateCommand = command;
    adapter.UpdateCommand.ExecuteNonQuery();
{
    MessageBox.Show("!!!!!");
}
con.Close();

Posted 13-Dec-14 20:50pm

markqui

Updated 13-Dec-14 20:58pm

DamithSL

v2

Add a Solution

3 solutions

Solution 3

Please see my past answers[^]. I suggest to use named parameters.

Posted 14-Dec-14 0:12am

Maciej Los

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-12-13T22:13:00

Solution 2

Your order of parameter declaration is incorrect. Otherwise code looks good. According to the query, inclass parameter should come first and then insno.

C#

command = new OleDbCommand("UPDATE Instructor SET inclass = ? WHERE insno=?", con);
    
command.Parameters.Add("@inclass", OleDbType.Boolean).Value = false;
command.Parameters.Add("@insno", OleDbType.VarChar).Value = txtid.Text;

Posted 13-Dec-14 22:13pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

markqui 15-Dec-14 2:53am

thank you

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-Dec-14 2:53am

Most welcome. :)

DamithSL · Accepted Answer · 2014-12-13T21:11:00

Solution 1

I think you can do the update at one execution

C#

con.Open();
bool inclass =false; // set this value true or false 
var command1 = new OleDbCommand("UPDATE Instructor SET inclass = ? WHERE inclass = ? and insno=?", con);
// above line ~inclass will set the invert value of current inclss value if the where condition match 
command1.Parameters.AddWithValue("?", !inclass); 
command1.Parameters.AddWithValue("?", inclass); 
command1.Parameters.AddWithValue("?", txtid.Text);
int rowcount =command1.ExecuteNonQuery(); // if rowcount > 0 means update success 
con.Close();

Posted 13-Dec-14 21:11pm

DamithSL

Updated 13-Dec-14 22:16pm

v3

Comments

markqui 14-Dec-14 3:41am

having trouble with line 4, "inclass" does not exist in the current context.

DamithSL 14-Dec-14 3:43am

you can give false, check my updated answer, you can pass this value to your function/method.

markqui 14-Dec-14 3:54am

ok i did! but another error.."syntax error with ~inclass.

markqui 14-Dec-14 4:03am

syntax error in query expression "~inclass"

DamithSL 14-Dec-14 4:16am

Ok, answer updated, please check

markqui 15-Dec-14 2:56am

thank you

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Dec-14 4:13am

Please refer my answer.