Using ExecuteScalar Method without Stored Procedures

ASP CODE

By: aspfree	Search For More Articles! Disclaimer Author Terms
Rating: / 7
2002-05-12

Table of Contents:

	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

This simple example shows how to use the ExecuteScalar to do a SELECT MAX(column) FROM Table and return the value without using stored procedures.

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
If Not IsPostBack Then
Dim dtStartDate As DateTime = DateTime.Now.AddDays(-7)
Dim dtEndDate As DateTime = DateTime.Now.AddDays(-1)
startdate.Text = dtStartDate.ToShortDateString
enddate.Text = dtEndDate.ToShortDateString
literal1.Text = GetEditionNumber()
End If
End Sub
Function GetEditionNumber()
Dim conn As SqlConnection = 
    New SqlConnection(ConfigurationSettings.AppSettings("DSN"))
Dim cmd As SqlCommand = New SqlCommand("SELECT MAX(Id) from Table", conn)
conn.Open()
Dim id As String = cmd.ExecuteScalar
conn.Close()
Return id
End Function
</script>
<html>
<head></head>
<body>
<form runat="server">
<asp:literal id="literal1" runat="server" /><br>
<asp:TextBox id="startDate"  runat="server"></asp:TextBox><br>
<asp:TextBox id="endDate"  runat="server"></asp:TextBox>
</form>
</body>
</html>

Web.Config used in Example

<?xml version="1.0" encoding="utf-8" ?>
<configuration>  <appSettings> <add key="DSN" value="server=localhost;uid=sa;pwd=;Database=pubs"/> </appSettings></configuration>

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 Code Articles
More By aspfree

developerWorks - FREE Tools!

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! Achieving True Agility -- How process can change the behavior of your tools

Achieving true agility is a never-ending effort. We will showcase how you can become agile incrementally, a few practices at the time.Which practices should any agile team strive to adopt? What additional practices should you consider based on your needs to scale? Adopting practices are however made much easier with the right tool support. What about if your tools adapt to your practices? We will take a look at how the Jazz technology can be leveraged to make your process change the behavior of your tools.
FREE! Go There Now!

NEW! A Layered approach to delivering security-rich Web applications

As businesses grow increasingly dependent upon Web applications to provide services to customers, employees and partners, these complex applications become more difficult to secure. Although traditional security solutions protect Internet infrastructure layers, they do not guard against HTTP and HTML attacks. Many organizations that conduct security testing still deploy applications that allow attackers to manipulate their logic and wreak havoc on their business. To mitigate this risk, development and delivery teams must address Web application security throughout the lifecycle, addressing the many layers detailed in this paper.
FREE! Go There Now!

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! Trial download: IBM Rational Functional Tester V7.0.1

Get a free trial download of the latest version of IBM Rational Functional Tester V7.0.1. Rational Functional Tester is an automated functional and regression testing solution for QA teams concerned with the quality of their Java, Microsoft Visual Studio .NET, and Web-based applications.
FREE! Go There Now!

NEW! Webcast: Application security testing and Web compliance

Join the IBM Watchfire team for an informative discussion on techniques and best practices to proactively manage Web application security and how to effectively build application security testing into the software development lifecycle (SDLC). In this Software Delivery Platform webcast you will learn: How to better understand potential web application security vulnerabilities, best practices and how to effectively integrate application security testing into the software development lifecycle, the importance of detecting and removing software vulnerabilities during application development.
FREE! Go There Now!

NEW! Webcast: IBM Rational Build Forge - Beyond the Build

The discipline of assembling and delivering software is maturing beyond standard developer-centric compile/test software builds. The end-to-end software development lifecycle is emerging as the new focus moves “Beyond the Build.” Join this on demand webcast to learn about methods for streamlining software delivery and key capabilities of the IBM Rational Build Forge framework for automating build and release management in environments of any size.
FREE! Go There Now!

Role of Integrated Requirements Management in Software Delivery

As organizations integrate software into every aspect of business, they are constantly pressured to deliver faster, better, and cheaper results. Unfortunately, a “dis-integrated” software delivery approach reduces returns while increasing costs. This IBM Rational White Paper shows how Integrated Requirements Management aligns organizations around maximizing value and keeping pace with change.
FREE! Go There Now!

NEW! Download IBM Rational Developer for System z

Download a free trial version of IBM Rational Developer for System z, software that can help you deliver core development capabilities; the power of Java Platform, Enterprise Edition (Java EE); and rapid application development support to diverse enterprise application development teams. With comprehensive development tools to help create, deploy and maintain traditional enterprise and composite applications, Rational Developer for System z enables developers with different technical backgrounds to easily participate in important technology projects.
FREE! Go There Now!

NEW! Did you say mainframe? e-kit

Learn how you can extend modern application lifecycle management to IBM System z through the IBM Rational Software Delivery Platform (SDP). The Did you say mainframe? e-kit includes podcasts, webcasts, tutorials, white and red papers, demos, and articles designed to help ease the challenges of modernizing your enterprise. This complimentary kit for mainframe developers is a practical, how-to guide for making the most of an existing development environment, including the skills and infrastructure already in place at an established enterprise.
FREE! Go There Now!

All FREE IBM® developerWorks Tools!

ASP CODE ARTICLES

- ASP Forms
- ASP: The Beginning
- Getting Remote Files With ASP Continued
- Inbox and Outbox Manipulation in ASP
- Relational DropDownList Using VB.NET
- Ad Tracking URL Hits
- Use ViewState to display one record per page...
- Send Email using ASP.NET formatted in HTML
- ASP File Explorer
- ASP/XML Interview questions by Srivatsan Sri...
- Various methods of setting Date values to a ...
- Conditional DataGrid Item and using checkbox...
- Fill .NET Listbox with SQL DataReader
- Filling Dropdown box using Code-Behinds in C#
- FLAMES code sample written in .NET What is F...
Find More ASP Code Articles

Application Delivery: Everything You Wanted to Know, but Didn`t Know You Needed to Ask
A comprehensive guide to examining the topics of Wide-area Data Services and app....

Best Practices: Safe and Secure Hardware Asset Recovery
Companies increasingly must meet EPA and local requirements for the disposal of ....

Managing SSL Security in Multi-Server Environments
Read this white paper to learn how to simplify management of your organization's....

Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available t....

Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity man....