如何在c＃中为存储过程的单个参数添加多个值？ [英] how to add multiple values for a single parameters of stored procedure in c#..?

问题描述

SELECT P.ProductId , P.ProductName , P.Description ,P.Image , C.CategoryName ,P.IsActive
FROM Product AS P
JOIN
Category AS C
ON
P.CategoryId=C.CategoryId
WHERE (@ProductName IS NULL OR ProductName like '%' + @ProductName + '%')
AND (@CategoryName IS NULL OR CategoryName= @CategoryName)
AND (@IsActive IS NULL OR IsActive=@IsActive)

这是我的存储过程我希望空值和文本框值都传递在c＃中为产品名称..如何做..？

this is my stored procedure i want null value and textbox values both to be passed in c# for product name ..how to do it..?

推荐答案

这篇关于如何在c＃中为存储过程的单个参数添加多个值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！