存储过程

[yumei20001]

在c#里调用存储过程如下:
create proc user_advancedQuery
(
@paramMemberName char(40),
@paramPolitical char(10),
@paramEdu char(10),
@paramDetailedUnit char(20),
@paramRewardAndPunish char(500)
)
AS
if @paramMemberName=""
set @paramMemberName='%'
if @paramPolitical=""
set @paramPolitical='%'
if @paramEdu=""
set @paramEdu='%'
if @paramDetailedUnit=""
set @paramDetailedUnit='%'
if @paramRewardAndPunish=""
set @paramRewardAndPunish='%'
select IdCard,MemberName,Sex,Political,BirthDate,Native,Edu,DetailedUnit,Tel,HireDate from YouthInfo
where (MemberName like @paramMemberName)and
(Political like @paramPolitical)and
(Edu like @paramEdu) and
(DetailedUnit like @paramDetailedUnit) and
(RewardAndPunish like @paramRewardAndPunish)
go
传人值:
advancedQueryCmd.Parameters.Add("@paramMemberName",SqlDbType.NVarChar,40,"MemberName").Value="";
advancedQueryCmd.Parameters.Add
("@paramPolitical",SqlDbType.Char,10,"Political").Value="";
advancedQueryCmd.Parameters.Add
("@paramEdu",SqlDbType.Char,10,"Edu").Value="";
advancedQueryCmd.Parameters.Add("@paramDetailedUnit",SqlDbType.NVarChar,40,"DetailedUnit").Value="";
advancedQueryCmd.Parameters.Add("@paramRewardAndPunish",SqlDbType.NVarChar,500,"RewardAndPunish").Value="";
为什么总是没有结果???

[zr1982930]

不会把，顶一下！

[yumei20001]

谢谢支持

[yumei20001]

大家都去吃饭了吗?

[lishengyu]

１查看　YouthInfo　　看数据库有没有记录

２ user_advancedQuery '','','','','' 看看有没有结果
如有结果肯定是前台问题

3用事件查看器跟踪前台传来的SQL语句　看看哪个值有什么异样

[lishengyu]

２　在查询分析器里执行　user_advancedQuery '','','','',''

[yumei20001]

user_advancedQuery '','','','',''执行以后没有结果,我怀疑是存储过程的问题

[yumei20001]

大家帮忙看看啊~~~~~~~~

[jerry_yuan]

SQL好像是用单引号。
if @paramMemberName=''
set @paramMemberName='%'
if @paramPolitical=''
set @paramPolitical='%'
if @paramEdu=''
set @paramEdu='%'
if @paramDetailedUnit=''
set @paramDetailedUnit='%'
if @paramRewardAndPunish=''
set @paramRewardAndPunish='%'

你试试

[yumei20001]

双引号是我打错了,问题找到了,没有消除空格

create proc user_advancedQuery
(
@paramMemberName char(40),
@paramPolitical char(10),
@paramEdu char(10),
@paramDetailedUnit char(20),
@paramRewardAndPunish char(500)
)
AS
if @paramMemberName=''
set @paramMemberName='%'
if @paramPolitical=''
set @paramPolitical='%'
if @paramEdu=''
set @paramEdu='%'
if @paramDetailedUnit=''
set @paramDetailedUnit='%'
if @paramRewardAndPunish=''
set @paramRewardAndPunish='%'
select IdCard,MemberName,Sex,Political,BirthDate,Native,Edu,DetailedUnit,Tel,HireDate from YouthInfo
where (MemberName like RTRIM (@paramMemberName))and
(Political like RTRIM(@paramPolitical))and
(Edu like RTRIM(@paramEdu))and
(DetailedUnit like RTRIM(@paramDetailedUnit))and
(RewardAndPunish like RTRIM(@paramRewardAndPunish))
go

[syfsz]

CREATE PROCEDURE BW_BWTest_GetPKey
@Addon nVarchar (3),
@ADDRESS2 nVarchar (20),
@TRANSACTIONID INT,
@TIMELASTMOD DATETIME,
@USERIDLASTMOD CHAR(20), －－传进去的值
@pKey int Output --传出来的值
AS
Declare @lipKey int
select @lipKey = pkey from BWTest
where Addon= @Addon
and ADDRESS2= @ADDRESS2

If @lipKey is null
Begin
EXEC GetNextId 'BWTest.pKey', 1, @lipKey OUTPUT
Insert into BWTest (pKey,Addon,
ADDRESS2,TotS_Qty,TotC_Qty,
TotGM_Qty,Sc_TimeCreated,Sc_TimeLastMod,
Sc_UserIdLastMod)
Values(@lipKey,@Addon,
@ADDRESS2,0,0,0,getdate(),getdate(),@USERIDLASTMOD)
End
Set @pKey=@lipKey