I need to validate that there are records returned. If not I need to exit the sever side script and display an alert box on the aspx.net page. How can I do this please. I do not want to use response.write I need the user to be alerted to the fact that there is no info for them.
If objRdr.Read() Then
response.Write("NO RECORDS RETURNED")