如何将值从前端传递到后端
问题描述:
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"[^]