asked on

VB.net code to query a stored procedure for an IF-THEN statement

I am working on an acsx user module with Visual Studio .net in VB.net.

I want code to query a stored procedure to see if a field has a particular value to create an if-then statement.

Something like . .

If in SP_Select_whatever
Record=@variable
variable2=X
then . . .

Thanks is advance.

Quick answer is important, hence the points

ASKER CERTIFIED SOLUTION

emadat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JCMcNeil

ASKER

Thanks for referring me to the long article.
However, I am in a bit of a hurry with this . . .
I know how to display, edit, delete, and add data from a stored procedure with vb.net.

Being the newbie I am, though, I am not sure how to use vb.net to simply check data in a stored procedure to see if it matches a value as part of an if-then statement.

anyone ready with a quick answer??

CleanupPing

Hi JCMcNeil,
This old question (QID 20567519) needs to be finalized -- accept an answer, split points, or get a refund. Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.

GPrentice00

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

-->Accept emadat's comment as Answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer