ASP.NET Code
  Home arrow ASP.NET Code arrow Return Value from Stored Procedure using ....
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Silverlight  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
ASP Web Hosting  
ASP.NET Web Hosting 
Windows Web Hosting
 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ASP.NET CODE

Return Value from Stored Procedure using .NET
By: aspfree
  • Search For More Articles!
  • Disclaimer
  • Author Terms
    		•
    Rating: 2 stars2 stars2 stars2 stars2 stars / 7
    2001-12-05

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
    		 
     
    ADVERTISEMENT

    Return Value from Stored Procedure

    This tip uses ExecuteScalar to return a value from a stored procedure and increment the value by one.



    <%@ Page Language="VB" EnableSessionState="False" EnableViewState="False" 

    Trace="False" 

    Debug="False" Strict="True" %>

    

    <%@ Import Namespace="System.Data" %>

    

    <%@ Import Namespace="System.Data.SQLClient" %>

    

    <script language="VB" runat="server">

    

    Sub Page_Load(Sender As Object, E As EventArgs) 

    

    

    Dim myConnection As SqlConnection = _ 

    New SqlConnection(ConfigurationSettings.AppSettings("DSN"))

    

    Dim MyCommand as SQLCommand = New SQLCommand("spReturnarticleId", MyConnection)

    

    MyCommand.CommandType = CommandType.StoredProcedure

    

    

    myConnection.Open()

    

    

    'Execute the Stored Procedure, return the value and increment it by 1

    

    Dim count As Int32 = CInt(myCommand.ExecuteScalar()) + 1

    

    dim strID as string = cstr(count)

    

    

    'Set the value of a textbox

    

    text1.text = strId

    

    

    'Set the Value of a message to test what value is returned

    

    Message.InnerHtml = strId

    

    myConnection.Close()

    

    End Sub

    

    </script>

    

    <html>

    

    <head></head>

    

    <body>

    

    <h1 align="center">Article Info</h1>

    

    <span id="Message" style="font: arial 11pt;color:#339900;" runat="server"/></h2>

    

    <asp:textbox id="text1" size="20" runat="server" /> 

    

    </body>

    

    </html>

     

    Stored Proc code.

    CREATE PROCEDURE spReturnArticleID

    as

    SELECT max(articleId) FROM articleInfo

    RETURN

    GO

    Table Code

    CREATE TABLE [dbo].[articleInfo] (

    [articleId] [int] NOT NULL ,

    [catID] [int] NOT NULL,

    [typeID] [int] NOT NULL,

    [fpTitle] [varchar] (255),

    [fpMessage] [varchar] (8000),

    [titleOfDemo] [varchar] (255),

    [href] [varchar] (150),

    [demoLink] [varchar] (255),

    [downloadLink] [varchar] (255),

    [dateSubmitted] [datetime] NULL,

    [dateUpdated] [datetime] NULL,

    [authorId] [int] NULL,

    [active] [bit] NOT NULL,

    [pageHits] [int] NULL,

    [fileName] [varchar] (150),

    [filePath] [varchar] (50),

    [fileCreated] [datetime] NULL

    ) ON [PRIMARY]

    GO

    ALTER TABLE [dbo].[articleInfo] WITH NOCHECK ADD

    CONSTRAINT [DF_tblWhatsNew_new_Active] DEFAULT (1) FOR [active],

    CONSTRAINT [PK_tblWhatsNew_new] PRIMARY KEY NONCLUSTERED

    (

    [articleId]

    ) WITH FILLFACTOR = 90 ON [PRIMARY]

    GO

     

    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More ASP.NET Code Articles
    More By aspfree

     

    IBM® developerWorks developerWorks - FREE Tools!
    IBM DB2 Deep Compression ROI Tool

    The IBM DB2 Deep Compression ROI tool is designed for DBA’s and IT management personnel to perform a clinical analysis of the cost savings gained from the Storage Optimization feature of DB2 9 for Linux, UNIX and Windows. The feature, also known as Deep Compression, compresses data that lies within a database by up to 80% at times.
    FREE! Go There Now!
    NEW! BlammoSplat: Build a community Web site of OpenLaszlo animations, Part 3: The community animation

    Learn to enable users to both rate existing animations and to combine existing animations into new snippets. This is the third in a series of three tutorials that chronicle the building of a site that enables collaborative discussion and animation building using Domino and OpenLaszlo.
    FREE! Go There Now!
    NEW! Download a free trial of WebSphere Business Modeler Advanced V6.1.1

    Visit IBM developerWorks to download a free trial version of WebSphere Business Modeler Advanced V6.1.1, IBM’s premier business process modeling and analysis tool for business users that offers process modeling, simulation, and analysis capabilities. IBM WebSphere Business Modeler helps you visualize, understand, and document business processes for continuous improvement.
    FREE! Go There Now!
    NEW! Evaluate Rational Host Access Transformation Services (HATS) Toolkit V7.1

    Visit IBM developerWorks to download a free trial of the Rational Host Access Transformation Services (HATS) Toolkit. The HATS toolkit provides a set of plug-ins for the IBM Rational Software Delivery Platform to help you easily extend your legacy applications. HATS makes your 3270 and 5250 applications available as HTML through the most popular Web browsers, while converting your host screens to a Web look and feel and it also enables you to develop new Web, portal, and rich-client applications.
    FREE! Go There Now!
    NEW! Project and Portfolio Management Executive Resource Kit

    Portfolio Management is about effectively managing portfolio value by aligning portfolio investments with business goals. This complimentary e-kit provides a collection of materials that can help you understand how IBM Rational enables and automates best practices for improved governance and clear visibility into portfolio and project performance across the entire IT project lifecycle.
    FREE! Go There Now!
    NEW! Rational Testing eKits

    Discover how Rational tools and best practices for testing can make your job easier. The new Rational Testing eKits provide you with valuable resources – including demos, webcasts, tutorials, and articles – that help you address your specific testing needs across the software lifecycle. Five new eKits are available covering the topics of Requirements and Test Management, Functional Testing, Performance Testing, Code Quality and Embedded Systems, and SOA and Web Services Testing.
    FREE! Go There Now!
    NEW! Software Change and Configuration Management Solution Guidelines

    This whitepaper provides areas to consider when evaluating any software configuration management solution. It addresses how the IBM solutions (Rational ClearCase and Rational ClearQuest) meet the needs and requirements of both project leaders and developers to provide successful Software Change and Configuration Management.
    FREE! Go There Now!
    NEW! Webcast: Extreme transaction processing with WebSphere Extended Deployment

    In this webcast, you'll get an introduction to the eXtreme Transaction Processing (XTP) features of WebSphere Extended Deployment and the common architectural traits required by XTP applications. See how WebSphere Extended Deployment's ObjectGrid feature provides a state-of-the-art infrastructure for hosting XTP applications.
    FREE! Go There Now!
    NEW! Webcast: What is new in Viper 2 for developers?

    Viper 2 brings a great value to developer communities including SQL, XML, PHP, Ruby, .NET and Java. You probably already know that DB2 Express-C is free for developers to develop, deploy and distribute. Viper 2 provides a variety of means that help move your application from the development stage to deployment more rapidly. This webcast shows how to best utilize the latest tools available for developing DB2 applications.
    FREE! Go There Now!
    Refresh! IBM Rational Systems Development Solution eKit

    With IBM Rational Systems Development Solution, you can deliver products faster with higher quality. Within this kit, Read the “Model Driven Systems Development” white paper to see how to improve product quality and communication. Then check out the rest of the e-Kit to learn more about important topics that can affect the success of any software project through customer examples, tutorials, informative Webcasts, and best practices for designing, building and managing systems. From start to finish, at every stage in your projects, Rational Systems Development Solution can help your company reach its full potential.
    FREE! Go There Now!

    All FREE IBM® developerWorks Tools!

    ASP.NET CODE ARTICLES

    - How to Use the ListBox Control in ASP.NET 2.0
    - How to Load XML Documents in ASP.NET 2.0
    - DataGrid Code
    - ASP.NET Guestbook
    - User Controls and Client Side Scripting
    - ASP.NET Programming with Microsoft's AS...
    - ASP.NET Basics (part 3): Hard Choices
    - ASP.NET Basics (part 2): Not My Type
    - ASP.NET Basics (part 1): Nothing But .Net
    - Directory Tree Browser
    - How to get the confirmation of Yes/No from a...
    - Complete example using custom errors and wri...
    - Paging Certain # records per page .NET style
    - General Methods of formatting and Subtractin...
    - .NET LinkButton web control
    Find More ASP.NET Code Articles




    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 3 Hosted by Hostway. 
    Stay green...Green IT