PDA

View Full Version : سوال: ارور The data reader is incompatible with the specified Entity هنگام خواندن پزوسیجر



r4hgozar
جمعه 10 آبان 1398, 13:34 عصر
سلام
آیا کد زیر اشتباه؟


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