ASP.Net 3-Tier architecture parameters declaration

Question

0.00/5 (No votes)

See more:

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

SQL

create procedure sp_insert
@fname varchar,
@lname varchar
As
Begin
Insert into emp(firstname,lastname) values(@fname,@lname);
End

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,

Posted 15-Jun-12 2:54am

jaipal0908

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Answer 1 · 2012-06-15T03:02:00

You have already asked a couple questions about 3-tiered architecture and how to accomplish it. Each question has received good answers and tutorials. Each time you ask fairly open-ended questions that are difficult to answer specifically. My suggestion would be to find a good book or video series on how to architect applications. For example, Pluralsight[^] has a great video training library for this type of application development. It isn't free but it is definitely worth it.

I don't want to sound like I'm avoiding your questionm, but in a way I guess I am. The reason is that usually it depends is the best possible answer. For instance, I would say that probably those variables would get put together in the business layer but I have also built them in the User Interface layer and in the data access layer. It all depends on the circumstances, which makes it impossible for me to give you a specific answer.

As to how to call the stored procedure using those parameters, this tutorial will help:

http://www.csharp-station.com/Tutorial/AdoDotNet/lesson07[^]