如何将值从前端传递到后端

如何将值从前端传递到后端

问题描述:

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"[^]