Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Eswar Datta
2.1k
115
5.8k
Web Service and jquery ajax
Sep 28 2018 4:22 AM
I wrote a stored procedure in sql-server for inserting data
CREATE PROCEDURE [dbo].[ASP_INSERT_CATEGORY](@CATEGORY_NAME NVARCHAR(MAX),@CATEGORY_DESCRIPTION NVARCHAR(MAX))
AS BEGIN
DECLARE @COUNT INT
SELECT @COUNT = COUNT(CATEGORY_NAME) FROM PARES_MASTER_CATEGORIES WHERE CATEGORY_NAME=@CATEGORY_NAME
IF(@COUNT>1)
BEGIN
SELECT 1 AS ALREADY_SAVED
END
ELSE
BEGIN
INSERT INTO [PARES_MASTER_CATEGORIES] (CATEGORY_NAME,CATEGORY_DESCRIPTION,STATUS) VALUES(@CATEGORY_NAME,@CATEGORY_DESCRIPTION,1)
END
END
Now i want to create a webservice and call that webmethod with jquery-ajax
But i don,t know how will do it.
Any body could u plz send me solution
Reply
Answers (
4
)
compare time with current time
C Sahrp Date Time Functions