如何将值从前端传递到后端 [英] how to pass values from frontend to backend

问题描述

hi


我想通过文本框（在我的.aspx页面中）将详细信息保存到sqltables，为此我创建了一个像这样的存储过程

hi
I want to save the details what i am giving through the textboxes(in my .aspx pages) to sqltables for this i create a storedprocedure like this

CREATE PROCEDURE INSERT_WEBSITEDETAILS
	@WebsiteName VARCHAR(100),
	@LiveIp1 NVARCHAR(100) ,
	@LiveIp2  NVARCHAR(100) ,
	@PortId   VARCHAR(100),	
	@ERROR VARCHAR(100) OUT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Createdate DATE
declare @Exist int
set @Exist = (SELECT count( PortId) FROM Websitedetails WHERE @PortId=PortId AND  @WebsiteName=WebsiteName)
if(@Exist=0)
BEGIN
	INSERT INTO Websitedetails 
	(WebsiteName,LiveIp1,LiveIp2,PortId,Createdate)
	VALUES
	(@WebsiteName,@LiveIp1,@LiveIp2,@PortId,GETDATE())
	SET @ERROR='UPDATED SUCCESSFULLY'
	END
	ELSE
	BEGIN
	SET @ERROR=' already exists'
	END	
END

但我不知道如何在FRONTEND中调用这个存储过程

plz帮助我

BUT I DONT KNOW HOW TO CALL THIS STOREDPROCEDURE IN FRONTEND
plz help me

推荐答案

使用下面的链接

Link1 [ ^ ]

Link2 [ ^ ]

use below links
Link1[^]
Link2[^]

参考：

如何将存储过程写入数据插入应用程序 [ ^ ]

使用带有c＃的插入存储过程 [ ^ ]

Refer:
How to write Stored procedure to Your Data Insert Application[^]
Using insert stored procedure with c#[^]

查看我过去的回答：存储过程C＃ - 如果EXISTS UPDATE ELSE INSERT [ ^ ]

See my past answer: Stored Procedure C# - "IF EXISTS UPDATE ELSE INSERT"[^]

这篇关于如何将值从前端传递到后端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！