want to chech username exist or not in database in 3tier architecture

Posted by Saritha.rajeshkumar under C# on 4/21/2011 | Points: 10 | Views : 2476 | Status : [Member] | Replies : 4
hi,
this is saritha i want to chech username exist or not in database, if exist it should show message user already exist in 3tier architecture with stored procedures.




Responses

Posted by: Sashys on: 4/30/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Saritha,
3tier is organized in to three layers

These layers are described below.

1. Application layer or Business layer
2. Business layer
a. Property layer(Sub layer of business layer)
3. data layer

Your authorization check is a functionality. you can send the user inputs in to Busiesslayer where you can do some validation [if required] on the inputs and send that inputs to function which written in Data layer. Data layer connects with Db and calls the stored procedure and return result.
1.Create stored procedure which returns 0 or 1 or true or false based on the input - if usr found 1 else 0 some thig like that..
2.Get that value to the dataaccess layer function and return that value all the way to presentation layer.
3.In the presentation layer, use that value and reply message to user saying user invalid or valid.

let us know if not working.






Sasikumar .M

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 4/30/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
I think i am getting tired of this kid of question now. Please guys before you post, search the forum first. we cannot flood the forum or site with this kinds of questions.


Thank you for posting at Dotnetfunda
[Administrator]

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Taanu51 on: 5/2/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Refer this one it may helps you
http://taanu51.blogspot.com/2011/02/how-to-set-check-availability-button-in.html


Tanisha Sayyad
.Net and Android Developer
INDIA(Andhra Pradesh)

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 5/19/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi Saritha,
Refer this link,
http://encosia.com/2007/07/02/aspnet-username-availability-checking-via-ajax/

Regards,
Susan

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response