问题描述
大家好,
我是3层架构的新手.
谁能帮助我在哪里声明(我的意思是哪一层)以及如何声明SQL Server存储过程的参数.
我正在使用存储过程将值插入表中.
假设我的SP是
Hi All,
I am new to 3-Tier architecture.
Can anyone help me where(I mean which layer) to declare and how to declare parameters for sql server stored procedure.
I am using stored procedure to insert values into the table.
Suppose my SP is
create procedure sp_insert
@fname varchar,
@lname varchar
As
Begin
Insert into emp(firstname,lastname) values(@fname,@lname);
End
现在使用asp.net Web表单,将值插入表中.
在Web表单中,我有两个文本框txtfirstname和txtlastname和一个按钮.
谁能告诉我要在每一层mailny变量/参数声明中编写的代码.
我浏览了许多文章,但感到困惑.
我只需要为该示例编写每层代码的粗略草图.
谢谢您,
Now using asp.net web form, I am inserting values into the table.
Here in web form I have two textboxes txtfirstname and txtlastname and a button.
Can anyone tell me the code to be written in each layer mailny variable/parameters declaration.
I went through many articles but getting confusion.
Just I need rough sketch of each layer code to be written for this example.
Thank you,
推荐答案
这篇关于ASP.Net 3层架构参数声明的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!