Solved

ASP.NET data reader for next loop

Posted on 2004-09-30
3
232 Views
Last Modified: 2013-11-25
I'm very new to .NET, and playing with syntax that  I just can't get right.

I have a sql command that reads a number of records from my database.  In the table, there is a field called APPROVED.  When the user clicks a button, it reads the data.  If the field APPROVED has the value of HOLD, I want to exit the subroutine.  I was trying to put the value into a label, so I could test this out, and I can get it to read the last record fine.  I know I need a For / Next loop in the middle of this, but my brain must have gone because I can't get it right.  I've taken out all the things I tried, so you wouldn't wonder -- why that.

Here is the basic structure of the code:
        'select statement is above here
        dtrFinal = SqlSelectCostCenters.ExecuteReader()


        While dtrFinal.Read
             
            Label1.Text = (dtrFinal("Approved"))

            If Label1.Text = "HOLD" Then
                dtrFinal.Close()
                SqlConnection1.Close()
                Exit Sub
            Else
                'Label1.Text = "YOU ARE GOOD TO GO"
            End If

        End While
        SqlConnection1.Close()


How can I get it to exit the sub if it comes across a record with the word "HOLD" in the field called approved??

THANK YOU as always for any suggestions.
0
Comment
Question by:BetsyV
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
David H.H.Lee earned 500 total points
ID: 12200136
BetsyV,
Possible the selected value is not returned as capital letter format? Others that, i cant see why it cant work.
eg:

While dtrFinal.Read
      If dtrFinal("Approved").ToString.ToUpper = "HOLD" Then
                Label1.Text = (dtrFinal("Approved"))
                dtrFinal.Close()
                SqlConnection1.Close()
                Exit Sub
      Else
                Label1.Text = "YOU ARE GOOD TO GO"
      End If
End While

0
 

Author Comment

by:BetsyV
ID: 12202477
Thank you for helping me think it through.  I always doubt my code.  It wasn't actually the upper/lower case, but I had to trim the data.  When I changed it to trim(dtrFinal("Approved").ToString.ToUpper) it worked like a charm.

THANKS !
0
 
LVL 29

Expert Comment

by:David H.H.Lee
ID: 12202658
Glad to help, BetsyV .

Regards
x_com
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASP Button to clear text 4 61
How to LOAD up a .NET Framework website with data? 2 58
Syntax for query to update table 2 29
Asp in server side with Mssql Server 7 4 27
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question