Solved

ASP.NET data reader for next loop

Posted on 2004-09-30
3
229 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
Comment Utility
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
Comment Utility
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
Comment Utility
Glad to help, BetsyV .

Regards
x_com
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now