How To know what String return

Question

5.00/5 (1 vote)

See more:

Let's Consider I am using 1 store procedure that return message if record save
then
Record Save Successfully with Grn No 1 and Sr No 3

numbers are calculated

and result is fetch by asp.net page
if record save then i want to show in message box
if any error occurs then then i want to show in Label

so my is query how to find means i am going to save result in String _result Variable
so how can i know that Record Save or error occurs
do ii have to use Linq or SubString and How??

Posted 2-Jan-13 23:38pm

Member-515487

Add a Solution

Comments

Abhishek Pant 3-Jan-13 5:41am

just perform and know it-Save or error occurs

Member-515487 3-Jan-13 6:04am

what i want to show to the user grn no and sr no for his transaction in msg box

prashant patil 4987 3-Jan-13 6:11am

@Member-515487: this task do urself.... if during coding any error occur then come for help here.

Sergey Alexandrovich Kryukov 3-Jan-13 17:57pm

For a record: string does not return. String is not a method. :-)
—SA

2 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)

Christian Graus · Answer 1 · 2013-01-03T15:05:00

Solution 1

What do you think LINQ is ? What do you mean by 'substring' ? You should call your data layer, and then check what values it returns, and write code to render the result as you expect. I think you're throwing around buzzwords with no clue what they mean.

Posted 3-Jan-13 15:05pm

Christian Graus

Faisalabadians · Answer 2 · 2013-01-03T19:26:00

"so my is query how to find means i am going to save result in String _result Variable
so how can i know that Record Save or error occurs
do ii have to use Linq or SubString and How??"

when you will call stored procedure to save date and your stored procedure does not contain any error handling technique, you will gotten error which you have to handled in application level.

and

"Let's Consider I am using 1 store procedure that return message if record save
then
Record Save Successfully with Grn No 1 and Sr No 3
"
return 1 from your stored procedure when your transaction is completed successfully, then in your application

C#

bool _result = Convert.ToBoolean(YourSqlCommand.ExecuteScalar());

and after that, see if you have true value or false in _result

C#

if(_result)
{
   // data saved, so show message
   HttpContext.Current.Response.Write("<script> alert('data saved'); </script>");
}
else
{
   // data is not saved, show error or any proper message you want here
}