how to insert my flag true or false in sqlserver

Devendra Kumar

10y810.NET

hello friends please solve this query

i have one table like: category

and there field like:

Category_Id int,

Category_Name varchar(50),

cat_IsSizeRequired bit

and cat_IsSizeRequired this column default value set ((0))

and than

insert time my query like

Category_Id int,

@Category_Name varchar(250),

@cat_IsSizeRequired bit

insert into dbo.Tbl_Category(Category_Name,cat_IsSizeRequired) values(@Category_Name,@cat_IsSizeRequired)

this and i want when insert

query

if i check cat_IsSizeRequired is true it insert true else default value false please any body tell me

sorry for my bad English

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
replace @cat_IsSizeRequired parameter with@cat_IsSizeRequired bit=0

while you not pass parameter it takes Zero.
0
Ravi Patel10y ago
Hi ,
try this
SqlParameter[] paramsToStore = new SqlParameter[3];
paramsToStore[0] = new SqlParameter("@Category_Id", Category_Id);
paramsToStore[1] = new SqlParameter("@Category_Name", Category_Name);
if(cat_IsSizeRequired=="true")
{
paramsToStore[2] = new SqlParameter("@cat_IsSizeRequired", cat_IsSizeRequired);
}else
{
paramsToStore[2] = new SqlParameter("@cat_IsSizeRequired", false);
}
paramsToStore[2].Direction = ParameterDirection.ReturnValue;
DataSet ds = SQLDataAccess.ExecuteDataset(SQLDataAccess.ConnectionString,CommandType.StoredProcedure, "Sp_Category", paramsToStore);
0
Devendra Kumar10y ago
ALTER PROCEDURE [dbo].[Sp_Category]
@Category_Id int,
@Category_Name varchar(250),
@cat_IsSizeRequired bit
AS
BEGIN
---for insert
begin
insert into dbo.Tbl_Category(Category_Name,cat_IsSizeRequired) values(@Category_Name,@cat_IsSizeRequired)
select 'insert' as operation
end
end
0
ketan borsdiya10y ago
Can you provide your procedure?
0
Devendra Kumar10y ago
public int Category_Id { get; set; }
public string Category_Name { get; set; }
public bool cat_IsSizeRequired { get; set; }
public DataSet CategoryOperations()
{
try
{
SqlParameter[] paramsToStore = new SqlParameter[3];
paramsToStore[0] = new SqlParameter("@Category_Id", Category_Id);
paramsToStore[1] = new SqlParameter("@Category_Name", Category_Name);
paramsToStore[2] = new SqlParameter("@cat_IsSizeRequired", cat_IsSizeRequired);
paramsToStore[2].Direction = ParameterDirection.ReturnValue;
DataSet ds = SQLDataAccess.ExecuteDataset(SQLDataAccess.ConnectionString, CommandType.StoredProcedure, "Sp_Category", paramsToStore);
return ds;
my procedure not supplied
cat_IsSizeRequired this column
0
ketan borsdiya10y ago
Hi Devendra try below query it may help you
insert into dbo.Tbl_Category(Category_Name,cat_IsSizeRequired) values(@Category_Name,ISNULL(@cat_IsSizeRequired,0))
0
Ravi Patel10y ago
Hi,
try this
Category_Id int,
@Category_Name varchar(250),
@cat_IsSizeRequired bit

IF (@cat_IsSizeRequired = 'True')
BEGIN
insert into dbo.Tbl_Category(Category_Name,cat_IsSizeRequired) values(@Category_Name,@cat_IsSizeRequired)
END
ELSE
BEGIN
insert into dbo.Tbl_Category(Category_Name,cat_IsSizeRequired) values(@Category_Name,0)
END
0