The data reader returned by the store data provider does not have enough columns for the query requested.

See more:

ASP

ASP.NET

SQL

C#3.5

, +

The data reader returned by the store data provider does not have enough columns for the query requested.

Line 1553:            }
Line 1554:
Line 1555:            return base.ExecuteFunction<Nullable<global::System.Int32>>("SalaryMonthly", employeeIdParameter);
Line 1556:        }
Line 1557:

my store procedere

ALTER PROCEDURE [dbo].[SalaryMonthly]
@EmployeeId int
AS
declare @i int,@presentday int,@OneDaySalary int, @totalDay int,@NetSalary int,@Month int,@year int
set @totalDay=(select datediff(day, GETDATE(), dateadd(month, 1, GETDATE())))
set @presentday =(select PresentDay from TblAttendeceMonthly where EmployeeId=@EmployeeId)
set @OneDaySalary =(select salary from  TblSalary where EmploeeId=@EmployeeId)/@totalDay
set @NetSalary=@presentday * @OneDaySalary
set @Month=(SELECT DATEPART(MM, GETDATE()))
set @year=(SELECT DATEPART(YY, GETDATE()))
BEGIN
if @presentday is not null
begin
    insert into TblSalaryMonthly  values (@EmployeeId,@NetSalary,@Month,@year,@presentday,1,0,GETDATE(),null )
end
end


exec SalaryMonthly 41