sql="select * from table1 where id >0 "
set rs = server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
do while not rs.eof
if rs("userid") is not null then
response.write rs("userid")
else
response.write rs("placeid")
end if
rs.movenext
loop
set rs = server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
do while not rs.eof
if rs("userid") is not null then
response.write rs("userid")
else
response.write rs("placeid")
end if
rs.movenext
loop
DataSet re=new DataSet();
SqlConnection SqlConn=new SqlConnection(conn--连接数据库的语句);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
sql, SqlConn);
SqlConn.open();
adapter.Fill(re);
SqlConn.close();
for(int i=0;i<re.Table[0].rows.count;i++)
{
if (re.Table[0].rows[i][userid所在的列从0开始].tostring()!="")
{
response.write (re.Table[0].rows[i][userid所在的列从0开始].tostring());
}
else
{
response.write (re.Table[0].rows[i][placeid所在的列从0开始].tostring());}
}随手写的,可能会又语法错误,请自己更正。