TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dean Hall
NA
1
1.5k
How to handle an SQL DB Bit value
May 28 2013 4:25 PM
I have a table that has a column (IsParticipant) that is set as a BIT type that can be NULL, 1 or 0. The intent is to use the NULL to determine if the customer has made a selection, i.e. Yes or No (Radio Buttons on web page).
I have a stored procedure that is used to get the field IsParticipant.
ALTER PROCEDURE [dbo].[X_GetParticipantForXAndY]
@xID uniqueidentifier,
@yID uniqueidentifier,
@IsParticipant bit output
AS
BEGIN
If @xID is null
BEGIN
RaisError('xID must be provided.', 16, 1);
Return 1;
END
If @yID is null
BEGIN
RaisError('yID must be provided.', 16, 1);
Return 1;
END
SET NOCOUNT ON;
SELECT @IsParticipant = DS.IsParticipant
FROM DShows DS
WHERE DS.xID = @xID and DS.yID = @yID;
END
I then have a class method that calls the stored procedure and then I want to use that NULL, 1 or 0 to set the True or False settings for the Yes and No Radio Buttons. If the value is null I want both radio buttons set to false.
sqlParameter = sqlCommand.Parameters.Add(new SqlParameter("@IsParticipant", SqlDbType.Bit));
sqlParameter.Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery("X_GetParticipantForXAndY", sqlCommand);
My initial thought was to have the method be set to return a Boolean.
My issue is, I am having problems returning the null, 1 or 0 back to the web page class -
Boolean isParticipant = Webpg.GetParticipant(xID, yID)
Based on how I setup the return statement, I can either get the null passed or the 1 & 0 but not the three values. What am I doing wrong? I am new this type of environment and it has been years since I have programmed with other OO Language.
I have tried these three return statements:
return Convert.ToBoolean(sqlCommand.Parameters["@IsSHSLogParticipant"].Value.Equals(sqlCommand.Parameters["@IsSHSLogParticipant"].IsNullable));
return Convert.ToBoolean(sqlCommand.Parameters["@IsSHSLogParticipant"].Value);
return Convert.ToBoolean(sqlCommand.Parameters["@IsSHSLogParticipant"]);
Reply
Answers (
1
)
How we can campare MVC with 3 tier architecture.
how to display binary stored image from database to image co