سلام
آیا کد زیر اشتباه؟




	@Name	nvarchar(100),

	@Tel1 nchar(11)

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET NOCOUNT ON;	

	IF(@Name!=NULL AND @Tel1 = NULL)

		BEGIN

		SELECT *  FROM Customer WHERE [Name] LIKE '%'+@Name+'%'

		END

	ELSE IF(@Name=NULL AND @Tel1 != NULL)	

	BEGIN

		SELECT *  FROM Customer WHERE [Tel1] LIKE '%'+@Tel1+'%'

	END

	ELSE IF(@Name!=NULL AND @Tel1!=NULL)

	BEGIN

		SELECT *  FROM Customer WHERE [Name] LIKE '%'+@Name+'%'

	END

	ELSE IF(@Name=NULL AND @Tel1=NULL)

	BEGIN

		SELECT * FROM Customer

	END

END



اینم C#‎




 DGWcustomer.DataSource = _db.SP_Customer_Findbynameandtel("1",null);