how to insert my flag true or false in sqlserver

Question

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_Namecat_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

ketan borsdiya · Answer

replace @cat_IsSizeRequired parameter with@cat_IsSizeRequired bit=0 while you not pass parameter it takes Zero.

Ravi Patel · Answer

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

Devendra Kumar · Answer

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_Namecat_IsSizeRequired) values(@Category_Name@cat_IsSizeRequired) select 'insert' as operation end end

ketan borsdiya · Answer

Can you provide your procedure?

Devendra Kumar · Answer

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

ketan borsdiya · Answer

Hi Devendra try below query it may help you insert into dbo.Tbl_Category(Category_Namecat_IsSizeRequired) values(@Category_NameISNULL(@cat_IsSizeRequired0))

Ravi Patel · Answer

Hi try this Category_Id int @Category_Name varchar(250) @cat_IsSizeRequired bit IF (@cat_IsSizeRequired = 'True') BEGIN insert into dbo.Tbl_Category(Category_Namecat_IsSizeRequired) values(@Category_Name@cat_IsSizeRequired) END ELSE BEGIN insert into dbo.Tbl_Category(Category_Namecat_IsSizeRequired) values(@Category_Name0) END