How to pass correct object value in SqlParameter for datatype bit?

Question

I am trying to pass a bit value only if needed (is checked).

How do I do this correctly? I am not getting a change in my dataset. SQL Server 2008.

if (chkExpired.Checked)
    CmdGetDetails.Parameters.Add(new SqlParameter("@isExpired", 1));

You should include more info. What is your database platform? Where is the rest of your query? — Patrick Hofman
– Patrick Hofman, Commented May 2, 2014 at 13:16
isExpired looked like boolean field, represented as bit in SQL Server. Are you sure you have an int field — Habib
– Habib, Commented May 2, 2014 at 13:17

Parimal Raj · Accepted Answer · 2014-05-02 13:18:38Z

13

bit refers to Boolean

so you would pass a boolean value in parameter's value

Ex :

CmdGetDetails.Parameters.AddWithValue("isExpired", chkExpired.Checked);

There is no addtional need to use a if block.

answered May 2, 2014 at 13:18

Parimal Raj

20.6k9 gold badges76 silver badges113 bronze badges

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

1 Comment

sam Over a year ago

that way will return only checked value not both checked or unchecked... what I really need is to pass the chosen value

apomene · Accepted Answer · 2014-05-02 13:18:44Z

3

            param.ParameterName = "@isExpired";
            param.Value =chkExpired.Checked; 
            param.DbType = System.Data.DbType.Boolean;
            cmd.Parameters.Add(param);

answered May 2, 2014 at 13:18

apomene

14.4k10 gold badges51 silver badges76 bronze badges

1 Comment

sam Over a year ago

that way will return only checked value not both checked or unchecked... what I really need is to pass the chosen value

Patrick Hofman · Accepted Answer · 2014-05-02 13:19:15Z

1

Just use the value of your checkbox (chkExpired.Checked):

CmdGetDetails.Parameters.Add(new SqlParameter("@isExpired", chkExpired.Checked));

answered May 2, 2014 at 13:19

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

Comments

Jonesopolis · Accepted Answer · 2014-05-02 13:19:38Z

0

you'll want to add the parameter either way, as a boolean :

CmdGetDetails.Parameters.Add(new SqlParameter("@isExpired", chkExpired.Checked));

answered May 2, 2014 at 13:19

Jonesopolis

25.4k12 gold badges72 silver badges115 bronze badges

1 Comment

sam Over a year ago

that way will return only checked value not both checked or unchecked... what I really need is to pass the chosen value

Collectives™ on Stack Overflow

How to pass correct object value in SqlParameter for datatype bit?

4 Answers 4

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related