ASP.NET data reader for next loop
Posted on 2004-09-30
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()
Label1.Text = (dtrFinal("Approved"))
If Label1.Text = "HOLD" Then
'Label1.Text = "YOU ARE GOOD TO GO"
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.