<% set rs = Server.CreateObject("ADODB.Recordset") strSQL="Select * from client where city='ISLAMABAD'" rs.Open strSQL, conn If rs.EOF = True Then Response.Redirect("./DatabaseError.asp") ' Else while not rs.EOF %> <% rs.MoveNext wend end if %>
Islamabad Rawalpindi Lahore Karachi Peshawar Quetta UAE A & J Kashmir  
Islamabad Capital Territory Of Pakistan
<% response.write rs.fields(1).value %>