How can I send a C# bool to a table in SQL?

Question

2.50/5 (2 votes)

See more:

I have written code to tell if something has been processed. Now I just need to code something that sends a boolean from my code in C# to my table in SQL. It seems like it should be simple, but I am very new and can't figure it out, and Google hasn't turned anything out for me yet.

I thank anyone for their time reading this.

VB

if (notificationProcessed != null)
             if (notificationProcessed.passed)
//TODO: send Passed to Notification Table using Notification_Insert stored proc?
             _notificationList.RemoveAt(i);

and I'm trying to write that if the notification is "passed" then to put that in the "processed" table of my sproc:

SQL

SELECT TOP 1000 [NotificationID]
      ,[NotificationMasterID]
      ,[NotificationTypeID]
      ,[NotificationStatusID]
      ,[RecordID]
      ,[ModifyDate]
      ,[ModifyUser]
      ,[Processed]
  FROM [FOO].[dbo].[Notification]

Posted 14-Jul-14 4:44am

Member 10945412

Updated 14-Jul-14 5:49am

v2

Add a Solution

Comments

[no name] 14-Jul-14 10:58am

I believe that you will find that a bool is stored in SQL Server as a bit data type. Whatever database engine your are using might be different.

Hemant Singh Rautela 14-Jul-14 11:06am

use BIT in SQL... :-)
And Send 1(True) or 0(False) from c# code

Member 10945412 14-Jul-14 11:37am

I think the trouble I'm having is actually how to send it from C#, I have the column set as BIT, so it should be all good there. I'm just having issue with seeing that it's sent in my code in c#

Hemant Singh Rautela 14-Jul-14 11:41am

Just show your code...

without your code no one can detect issue.. :-)

Member 10945412 14-Jul-14 11:49am

Sorry, added code!

Hemant Singh Rautela 15-Jul-14 2:58am

So whats the issue...write the code as given in Solution 1 ..... :-)

PIEBALDconsult 14-Jul-14 11:11am

Yeah, BIT = 1 , but maybe you'd be better served by storing a timestamp of _when_ it processed.
Or a status that indicates something like { New , Processing , Success , Fail ... }

3 solutions

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)

CHill60 · Answer 1 · 2014-07-14T05:35:00

As the others have suggested, in SQL Server you can use a datatype of BIT[^]
See also SQL Data Type Mappings[^]

Note that the database handlers built into .net should take care of any conversion for you. For example you can do something like this...

SqlCommand cmd = new SqlCommand("insert into Product (ProductName, Active) values(@prod, @active)", con);
cmd.Parameters.AddWithValue("@prod", "A new product");
cmd.Parameters.AddWithValue("@active", true);
int rowsAffected = cmd.ExecuteNonQuery();

Abhinav S · Answer 2 · 2014-07-14T05:37:00

Solution 2

Try these links -
Configuring Parameters and Parameter Data Types[^]
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET[^]
C# Stored Procedure with Parameter [^]

Posted 14-Jul-14 5:37am

Abhinav S

tyagimanoj12 · Answer 3 · 2014-07-14T19:50:00

Solution 3

You have to take datafield bit type in table and then you can store boolean or bool value to database.

Posted 14-Jul-14 19:50pm

tyagimanoj12