Halfblood17
New Member
I have a search page that uses a datagrid. I want it to redirect to a URL if the datagrid comes back empty. I do I search to see if the datagrid is empty?Instead of checking your datagrid you should be checking your database.Do you know how I can do that?use ISDBNULL something like this<BR><BR>while DBreader.read()<BR>if isdbnull(dbreader.item("city")) then<BR>response.redirect(somewhere)<BR>else<BR>item.databind()<BR>end if<BR>end while<BR><BR>or to check all fields do this..<BR><BR>while DBreader.read()<BR>for i = 0 to dbreader.fieldcount -1<BR>if isdbnull(dbreader(i)) then<BR>response.redirect(somewhere)<BR>else<BR>item.databind()<BR>end if<BR>next<BR>end while<BR><BR>