THIS IS MY TABLE CODE
CREATE TABLE [dbo].[LupHolidays](
[HolidaysId] [int] IDENTITY(1,1) NOT NULL,
[HolidaysDetails] [nvarchar](250) NULL,
[HolidaysDate] [datetime] NULL,
[IsMandetory] [bit] NULL,
[DateEntered] [datetime] NULL,
[EnteredByID] [int] NULL,
[DateUpdated] [datetime] NULL,
[UpdatedByID] [int] NULL,
[UpdatedBy] [nvarchar](250) NULL,
[IsActive] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[HolidaysId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
THIS IS MY PROCEDURE CODE
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[AddEditLupHoliday]
@holidaysdetails nvarchar(250),
@holidaysdate datetime,
@ismandetory bit,
@dateenterd datetime,
@enteredbyid int,
@dateupdated datetime,
@updatedbyid int,
@updatedby nvarchar(250),
@isactive bit
AS
INSERT INTO LupHolidays(HolidaysDetails, HolidaysDate, IsMandetory, DateEntered, EnteredByID, DateUpdated, UpdatedByID, UpdatedBy, IsActive)
VALUES(@holidaysdetails, @holidaysdate, @ismandetory, @dateenterd, @enteredbyid, @dateupdated, @updatedbyid, @updatedby, @isactive)
THIS IS MY C# CODE TO CALL SP
public void DAAddEditLupHoliday(eLupHoliday eLH, out string oHolidaysDetails)
{
try
{
DataSet ds = new DataSet();
DBAccess objDbAccess = new DBAccess();
string SP = "AddEditLupHoliday";
SqlParameter[] spc = new SqlParameter[9];
spc[1] = new SqlParameter("@holidaysdetails", eLH.HolidaysDetails);
spc[2] = new SqlParameter("@holidaysdate", eLH.HolidaysDate);
spc[3] = new SqlParameter("@ismandetory", eLH.IsMandetory);
spc[4] = new SqlParameter("@dateenterd", eLH.DateEntered);
spc[5] = new SqlParameter("@enteredbyid", eLH.EnteredByID);
spc[6] = new SqlParameter("@dateupdated", eLH.DateUpdated);
spc[7] = new SqlParameter("@updatedbyid", eLH.UpdatedByID);
spc[8] = new SqlParameter("@updatedby", eLH.UpdatedBy);
spc[9] = new SqlParameter("@isactive", eLH.IsActive);
ds = objDbAccess.getDataSet(SP, spc);
oHolidaysDetails = ds.Tables[0].Rows[1]["HolidaysDetails"].ToString();
}
catch (Exception ex)
{
throw;
}
}
What I have tried:
1. I droped the procedure and build it again.
2. Re-check every code which I created.
3. I changed the table and rows value in c# code.
4. Build parameters again in c# code and sql.