473,405 Members | 2,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Pass SQL SelectCommand result to variable/textbox

Expand|Select|Wrap|Line Numbers
  1. <asp:SqlDataSource ID="verifyNumber" runat="server" ConnectionString="<%$ConnectionStrings:pageConnectionString %>"
  2.     SelectCommand="
  3.               IF EXISTS(SELECT 1 FROM [page].[dbo].[_testing] WITH(NOLOCK)
  4.                     WHERE Number = '803' )
  5.               BEGIN
  6.                 PRINT 'Record Exists'
  7.               END
  8.            ELSE
  9.               BEGIN
  10.                 PRINT 'Record doesn''t Exists'
  11.               END
  12.             "
  13.     ProviderName="<%$ConnectionStrings:page.ProviderName %>" > </asp:SqlDataSource>
The above code is what I am trying to pass the result into a variable or label for further use. Any help would be greatly appreciated!
Aug 27 '15 #1
0 1457

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: olga | last post by:
Hi, On my site, i want to pass a javascript variable to php. I know that this needs to done in a link or in a post. I want to know if there is a way i can do it with an html link. I should...
2
by: Augusto Cesar | last post by:
Hello people. How can I Pass ASP Array variable to Javascript; I´m to trying this: <script language="JavaScript"> var x = new Array(10);
3
by: Wayne Wengert | last post by:
I have an application where a session variable is set in an ASPX page, The process calls an ASP page and when in that page the session variable appears to be null. How can I pass a session variable...
2
by: Beffmans | last post by:
HI how to pass client side variable(javascript) to an asp.net webform? I was thinking using an invisible asp:textbox control to store the value in? any ideas? thanks Bert
0
by: colleen1980 | last post by:
Hi: There are two textboxs in my main form. One is bound and another is unbound. There is no entry in the unbound textbox as values come into automatically after entering some information in the...
3
by: hemashiki | last post by:
hi i cant pass a same variable to multiplepages... while passing variables in sessions it shows warning and it doesn't pass to multiple pages here the coding which i hve used Registration.php...
10
by: mike4722 | last post by:
I wish to have the form to be able to automatically select the radio button based on the logic of HTML/php variable. example show below: javascript: function autoForm(value) { var myForm =...
9
by: JRough | last post by:
I tried to pass the $result from a mysql_query in a url like this line Header("Location:clm_historyXL.php?_result=".$result); but on the redirect location clm_history.php page I get an error on...
2
by: Gunasegar | last post by:
i have php variable which has to be passed inside the javascript... this is my code.. <ul class="frnd_lst"> <?php for($i=1; $i<11; $i=$i+1) { ?> <li id="color" class="frnd_lst_li"...
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.