showing error message from stored procedure to lable control in asp.net applcation.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

i have a store procedure i want to show @Result in lable control.

here is the stored proceudure. this procedure result in nothing.. probably dere would be some error in my code.

SQL

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[insertUser] (
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(150),
@Mobile varchar(50),
@Result varchar(100) output )
AS
BEGIN
 
Declare @UserCount int;
 
SELECT @UserCount = COUNT(*) FROM users WHERE UserName = @UserName;
 
IF(@UserCount > 0)
begin
 
 Set  @Result = 'User already exists';
 
end
ELSE
begin
 
 INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile);
 

 Set  @Result = 'User successfully added';
 
end
	
END

my web application is three teir based..

here is the code of presentation layer..

C#

registerUser reg = new registerUser();
reg.UserName = txtUserName.Text;
reg.Password = txtPassword.Text;
reg.FirstName = txtfirstname.Text;
reg.LastName = txtlastname.Text;
reg.Email = txtemail.Text;
reg.MobileNo = txtmobileno.Text;

int b =reg.insertUser(reg);
if (b == 1)

{
    lblreg.Text = "User Registration Successful";

}
else
{
    lblreg.Text = "Oh Their is Some Problem, Come back Lator";
}

and thats for business layer..

C#

public int insertUser(registerUser reg)
    {
        dbcon obj = new dbcon();
        SqlParameter[] objParams = new SqlParameter[6];


        objParams[0] = new SqlParameter("@UserName", reg.UserName);
        objParams[1] = new SqlParameter("@Password", reg.Password);
        objParams[2] = new SqlParameter("@FirstName", reg.FirstName);
        objParams[3] = new SqlParameter("@LastName", reg.LastName);
        objParams[4] = new SqlParameter("@Email", reg.Email);
        objParams[5] = new SqlParameter("@Mobile", reg.MobileNo);

        int b=obj.ExecuteNonQuery("insertUser", objParams);
        return b;
    }

what changes i have to made to get my disired results..

Posted 27-Nov-11 4:22am

codegeekalpha

Updated 27-Nov-11 4:24am

Sander Rossel

v2

Add a Solution

Comments

OriginalGriff 27-Nov-11 10:34am

Please, it is called a Presentation layer for a reason. Have you ever considered spell-checking your messages?
lblreg.Text = "Oh Their is Some Problem, Come back Lator";
Makes you look very unprofessional!
"Their" is a plural adjective meaning "Belonging to or associated with the people or things previously mentioned or easily identified".
"There" is an adverb meaning "In, at, or to that place or position".
"Lator" is not a word.
"Later" is an adverb meaning "at a subsequent time".

If You Are Going To Capitalise Every Word, Don't forget One Near The End.

codegeekalpha 27-Nov-11 10:37am

oh dear.. thats not english grammer forum..

3 solutions

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)

RC_Sebastien_C · Answer 1 · 2011-11-27T04:35:00

Solution 1

You would need a SqlParameter in your objParams to hold your @Result.
The b you seem to be using will be the execution status of your stored procedure (success/fail), not the result you determine within it.

Posted 27-Nov-11 4:35am

RC_Sebastien_C

VallarasuS · Answer 2 · 2011-11-27T05:46:00

It has been years since I've done any SQL, try this code hope it helps!

SQL

SELECT @UserCount = COUNT(*) FROM users WHERE UserName = @UserName;
 
IF(@UserCount > 0)
begin
 
 SELECT '0';
 
end
ELSE
begin
 
 INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile);
 
 
 SELECT '1';
 
end
	
END

D K N T H · Answer 3 · 2011-11-27T15:17:00

hi,

try my codes without output parameter..

sql section:

SQL

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[insertUser] (
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(150),
@Mobile varchar(50)
AS
BEGIN
 
Declare @UserCount int;
Declare @result int);
 
set @UserCount = SELECT COUNT(*) FROM users WHERE UserName = @UserName;
 
IF(@UserCount > 0)
begin
 
 Set  @Result = -1
 return
end
ELSE
begin
 
 INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile);
 
 --succesful
 Set  @Result = -2;
 return
end
	
END

Business layer:

C#

public int insertUser(registerUser reg)
    {
        dbcon obj = new dbcon();
        SqlParameter[] objParams = new SqlParameter[6];
 

        objParams[0] = new SqlParameter("@UserName", reg.UserName);
        objParams[1] = new SqlParameter("@Password", reg.Password);
        objParams[2] = new SqlParameter("@FirstName", reg.FirstName);
        objParams[3] = new SqlParameter("@LastName", reg.LastName);
        objParams[4] = new SqlParameter("@Email", reg.Email);
        objParams[5] = new SqlParameter("@Mobile", reg.MobileNo);
 
        int b=obj.ExecuteScalar("insertUser", objParams);
        return b;
    }

presentation layer:

C#

registerUser reg = new registerUser();
        reg.UserName = txtUserName.Text;
        reg.Password = txtPassword.Text;
        reg.FirstName = txtfirstname.Text;
        reg.LastName = txtlastname.Text;
        reg.Email = txtemail.Text;
        reg.MobileNo = txtmobileno.Text;
 
        int b =reg.insertUser(reg);
        if (b == -2)
 
        { 
            lblreg.Text = // successful message; 
 
        }
        else
        { 
            lblreg.Text = //error message; 
        }

try this codes and ask me if it gives you error.
hope it helps..

mark this as answer if it helps you..
thanks

showing error message from stored procedure to lable control in asp.net applcation.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0