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));

Kettledrum

You should include more info. What is your database platform? Where is the rest of your query? – Flaherty

isExpired looked like boolean field, represented as bit in SQL Server. Are you sure you have an int field – Blocking

I need to cast that 1 int value dont I? – Kettledrum

Answer 1

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.

Bacchanal

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

Answer 2

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

Hillery

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

Answer 3

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

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

Flaherty

Answer 4

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

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

Oca

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