return exception when run one stored procedure

Question

0.00/5 (No votes)

See more:

hi i hve one stored procedure

SQL

create PROCEDURE spgetoutpatientidbyinpatientid
@pinpatientid int
AS

BEGIN

    select  Patient_ID from tblPatientAdmissionDetails where ID=@pinpatientid and Status=1
END
GO

if this condition is wrong i got null exception.i want to return at least null value or anything.how can i avoid this error
in my code i use

C#

string  ds = UserDataBase.ExecuteScalar(Command).ToString();

how can i change my sql query..?

Posted 25-Oct-12 22:16pm

nixon13

Add a Solution

2 solutions

Solution 1

Hi,

you can write your query like this :

SQL

create PROCEDURE spgetoutpatientidbyinpatientid
@pinpatientid int = 0
AS

BEGIN

    select  ISNULL(Patient_ID,0) AS Patient_ID from tblPatientAdmissionDetails where ID=@pinpatientid and Status=1
END
GO

Thanks,
Viprat

Posted 25-Oct-12 22:19pm

VIPR@T

Updated 25-Oct-12 22:37pm

v2

Comments

nixon13 26-Oct-12 4:31am

sorry its not working..i got same exception

VIPR@T 26-Oct-12 4:36am

have you check that @pinpatientid in this variable value is going to pass or not.
@pinpatientid int = 0
Do like this and try once

nixon13 26-Oct-12 4:50am

its not working ..i got the answer..declare one variable in stored procedure

VIPR@T 26-Oct-12 5:14am

see the solution, this is the same thing which i told you. I have given value 0 at parameter.

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)

damodara naidu betha · Accepted Answer · 2012-10-25T22:35:00

Solution 2

You can avoid the error by using a variable inside your stored procedure. See the following code block

SQL

create PROCEDURE spgetoutpatientidbyinpatientid
@pinpatientid int
AS
 
BEGIN
    
    DECLARE @PatientId BIGINT;

    SET @PatientId = 0

    select @PatientId = ISNULL(Patient_ID,0) from tblPatientAdmissionDetails where  
    ID=@pinpatientid and Status=1

    SELECT @PatientId
END

Thank you..

Posted 25-Oct-12 22:35pm

damodara naidu betha

Comments

nixon13 26-Oct-12 4:47am

hi..thnks..its working..

damodara naidu betha 26-Oct-12 6:45am

any vote?.. ;)