How to detect return value from stored procedure used by a Details

=?Utf-8?B?QmlzaG95?=

Hi all,
I have an asp.net 2.0 web site with a DetailsView control to select and
insert data from database.
I made the insert statement for that DetailsView by a stored procedure.
I made some logic in the stored procedure so it returns a value in certain
cases.
How to detect the return value from that stored procedure that is used by
the DetailsView control.

Many Thanks,
Bishoy

Dec 24 '06 #1

Subscribe Post Reply

1359

Mark Fitzpatrick

You need to add pass a parameter to your code that talks to the stored
procedure. This parameter is always the first one (position 0 in the array).
This is always an integer value. The name of the parameter should always be
@return_value.
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Bishoy" <Bi****@discussions.microsoft.comwrote in message
news:2D**********************************@microsof t.com...

Hi all,
I have an asp.net 2.0 web site with a DetailsView control to select and
insert data from database.
I made the insert statement for that DetailsView by a stored procedure.
I made some logic in the stored procedure so it returns a value in certain
cases.
How to detect the return value from that stored procedure that is used by
the DetailsView control.

Many Thanks,
Bishoy

Dec 24 '06 #2

by: Vipul Pathak | last post by:

Hello Friends ! I have the Following Code, that Executes a Stored Procedure and Attempt to read a Returned Integer Value from the StoredProc. But It gives Error ... ADODB.Command (0x800A0BB9)...

ASP / Active Server Pages

Detect Insert error using ADO

by: Larry | last post by:

I know how to detect errors if a stored procedure is used, by adding a ReturnValue parameter to the command object and then in the stored procedure having a RETURN @@ERROR But, If I am using...

Microsoft SQL Server

Stored procedure return value

by: Sandy | last post by:

Hello - I need a good example of how to take a return value from a stored procedure and use it in vb code. I have an app that searches a database by city and state. If a user makes a typo, the...

Visual Basic .NET

return value question

by: ken | last post by:

Dear all, question 1: IF (NOT EXISTS(SELECT * FROM table) RETURN 1 ELSE RETURN 0 how to get back the return value from stored procedure from ado.net 2.0 i try Dim result As Boolean =...

ASP.NET

Handling of different return number in stored procedure

by: Fir5tSight | last post by:

Hi All, I have a C#.NET code as follows: private void ScanInput_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { try { Row lRow = this.Connection.InsertScannedFile(ID);

.NET Framework

Handling of different return code correspondingly in a stored procedure

by: Fir5tSight | last post by:

Hi All, I have a C#.NET code as follows: private void ScanInput_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { try { Row lRow = this.Connection.InsertScannedFile(ID);

.NET Framework

How to return a Pk value from one stored procedure to another storedprocedure

by: gopi2ks | last post by:

Dear All, I have one stored procedure like sp_insertEmployee Employee Table Fileds Eno int pk, ename varchar(100), designation varchar

Microsoft SQL Server

Return value from Stored Procedure

by: Dooza | last post by:

I have a stored procedure that takes a number of inputs, does a bulk insert, and then outputs a recordset. When I run the stored procedure in Server Management Studio I also get a return value from...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

How to detect return value from stored procedure used by a Details

Similar topics