<% sqls="select * from xxp_manage order by id desc" Set rss= Server.CreateObject("ADODB.Recordset") rss.open sqls,conn,1,1 for n=1 to rss.recordcount if rss.eof then exit For %> <tr> <td height="25"><%=rss("username")%></td> <td height="25"><%=rss("password")%></td> </tr> <% rss.movenext next Rss.close set Rss=nothing %>
SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......