使用LIKE关键字在SQL中搜索数据

我有一个SQL存储过程，它根据send data搜索表中的数据。但是当我使用它时，我不能得到任何结果。这是我使用存储过程的c#代码:

List<Common.CommonPersonSerchResult> SerchResult = new List<Common.CommonPersonSerchResult>();
    public DLAdvancedSearch(Common.CommonPersonAdvancedSearch data)
    {
        //Creating Connection Started...
        SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=Khane;Integrated Security=True");
        //Creating Connection Finished.
        //Creating Command To Run started...
        SqlCommand command = new SqlCommand();
        command.Connection = connection;
        //Creating Command To Run Finished.
        //Setting Command Text...
        command.CommandType = CommandType.StoredProcedure;
        command.CommandText = "AdvancedSearch";
        //Setting Command Text Finished.
        //Making And Setting SQL AdvancedSearch Parametters...
        SqlParameter FirstName = new SqlParameter("FirstName", SqlDbType.NVarChar, 50);
        FirstName.Value = data.FirstName;
        command.Parameters.Add(FirstName);
        SqlParameter LastName = new SqlParameter("LastName", SqlDbType.NVarChar, 50);
        LastName.Value = data.LastName;
        command.Parameters.Add(LastName);
        SqlParameter FatherName = new SqlParameter("FatherName", SqlDbType.NVarChar, 50);
        FatherName.Value = data.FatherName;
        command.Parameters.Add(FatherName);
        SqlParameter NationalCode = new SqlParameter("NationalCode", SqlDbType.Int);
        NationalCode.Value = data.NationalCode;
        command.Parameters.Add(NationalCode);
        SqlParameter ShenasnameCode = new SqlParameter("ShenasnameCode", SqlDbType.Int);
        ShenasnameCode.Value = data.ShenasnameCode;
        command.Parameters.Add(ShenasnameCode);
        SqlParameter State = new SqlParameter("State", SqlDbType.NVarChar, 50);
        State.Value = data.State;
        command.Parameters.Add(State);
        SqlParameter City = new SqlParameter("City", SqlDbType.NVarChar, 50);
        City.Value = data.City;
        command.Parameters.Add(City);
        SqlParameter Address = new SqlParameter("Address", SqlDbType.NVarChar, 50);
        Address.Value = data.Address;
        command.Parameters.Add(Address);
        SqlParameter PostalCode = new SqlParameter("PostalCode", SqlDbType.Int);
        PostalCode.Value = data.PostalCode;
        command.Parameters.Add(PostalCode);
        SqlParameter SportType = new SqlParameter("SportType", SqlDbType.NVarChar, 50);
        SportType.Value = data.SportType;
        command.Parameters.Add(SportType);
        SqlParameter SportStyle = new SqlParameter("SportStyle", SqlDbType.NVarChar, 50);
        SportStyle.Value = data.SportStyle;
        command.Parameters.Add(SportStyle);
        SqlParameter RegisterType = new SqlParameter("RegisterType", SqlDbType.NVarChar, 50);
        RegisterType.Value = data.RegisterType;
        command.Parameters.Add(RegisterType);
        SqlParameter Gahremani = new SqlParameter("Gahremani", SqlDbType.NVarChar, 50);
        Gahremani.Value = data.Ghahremani;
        command.Parameters.Add(Gahremani);
        //Making And Setting SQL AdvancedSearch Parametters Finished.
        //Reading Data And Save in SearchResult List...
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            Common.CommonPersonSerchResult res = new Common.CommonPersonSerchResult();
            res.ID = (int)reader.GetValue(0);
            res.FirstName = reader.GetValue(1).ToString();
            res.LastName = reader.GetValue(2).ToString();
            res.FatherName = reader.GetValue(3).ToString();
            res.NationalCode = (int)reader.GetValue(4);
            res.ShenasnameCode = (int)reader.GetValue(5);
            res.BirthDate = reader.GetValue(6).ToString();
            res.State = reader.GetValue(7).ToString();
            res.City = reader.GetValue(8).ToString();
            res.PostalCode = (int)reader.GetValue(10);
            res.SportType = reader.GetValue(11).ToString();
            res.SportStyle = reader.GetValue(12).ToString();
            res.RegisterType = reader.GetValue(13).ToString();
            res.Ghahremani = reader.GetValue(14).ToString();
            SerchResult.Add(res);
        }
        connection.Close();
        //Reading Data And Save in SearchResult List Finished.

    }

这是我的存储过程:

USE [Khane]
GO
/****** Object:  StoredProcedure [dbo].[AdvancedSearch]    Script Date: 10/28/2011 01:02:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[AdvancedSearch] 
@FirstName nvarchar(50) = null,
@LastName nvarchar(50) = null,
@FatherName nvarchar(50) = null,
@NationalCode int = null,
@ShenasnameCode int = null,
@State nvarchar(50) =null,
@City nvarchar(30) =null,
@Address nvarchar(250)=null,
@PostalCode int=null,
@SportType nvarchar(50)=null,
@SportStyle nvarchar(50)=null,
@RegisterType nvarchar(50)=null,
@Gahremani nvarchar(50)=null
AS
BEGIN
if @FirstName<>null
begin
select * from PersonsDataTbl where Name like '%'+@FirstName+'%'
end
if @LastName<>null
begin
select * from PersonsDataTbl where LastName like '%'+@LastName+'%'
end
if @FatherName<>null
begin
select * from PersonsDataTbl where FatherName like '%'+@FatherName+'%'
end
if @NationalCode<>null
begin
select * from PersonsDataTbl where NationalCode like '%'+@NationalCode+'%'
end
if @ShenasnameCode<>null
begin
select * from PersonsDataTbl where ShenasnameCode like '%'+@ShenasnameCode+'%'
end
if @State<>null
begin
select * from PersonsDataTbl where State like '%'+@State+'%'
end
if @City<>null
begin
select * from PersonsDataTbl where City like '%'+@City+'%'
end
if @Address<>null
begin
select * from PersonsDataTbl where Address like '%'+@Address+'%'
end
if @PostalCode<>null
begin
select * from PersonsDataTbl where PostalCode like '%'+@PostalCode+'%'
end
if @SportType<>null
begin
select * from PersonsDataTbl where SportType like '%'+@SportType+'%'
end
if @SportStyle<>null
begin
select * from PersonsDataTbl where SportStyle like '%'+@SportStyle+'%'
end
if @RegisterType<>null
begin
select * from PersonsDataTbl where RegisterType like '%'+@RegisterType+'%'
end
if @Gahremani<>null
begin
select * from PersonsDataTbl where Ghahremani like '%'+@Gahremani+'%'
end
END

我该怎么做?