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

c# sqlparameter
JoJo picture JoJo · May 2, 2014 · Viewed 9.6k times · Source

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

Answer

Parimal Raj picture Parimal Raj · May 2, 2014

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.

Related questions

Assign null to a SqlParameter

The following code gives an error - "No implicit conversion from DBnull to int." SqlParameter[] parameters = new SqlParameter[1]; SqlParameter planIndexParameter = new SqlParameter("@AgeIndex", SqlDbType.Int); planIndexParameter.Value = (AgeItem.AgeIndex== null) ? DBNull.Value : AgeItem.AgeIndex; parameters[0] = planIndexParameter;

Read More
WHERE IN (array of IDs)

I have webservice which is passed an array of ints. I'd like to do the select statement as follows but keep getting errors. Do I need to change the array to a string? [WebMethod] public MiniEvent[] getAdminEvents(int buildingID, DateTime …

Read More
How to pass XML from C# to a stored procedure in SQL Server 2008?

I want to pass xml document to sql server stored procedure such as this: CREATE PROCEDURE BookDetails_Insert (@xml xml) I want compare some field data with other table data and if it is matching that records has to inserted …

Read More