Jump to content

  2. →
  3. →

Photo

Ler Banco De Dados Sem Criar Duas Tabelas Como?

Started By ricardo_moura, 04/07/2008, 22:50

  • Faça o login para participar
1 reply to this topic

#1 ricardo_moura

ricardo_moura

    Turista

  • Usuários
  • 57 posts
  • Sexo:Não informado
  • Interesses:Web Designer

Posted 04/07/2008, 22:50

Olá gente td bom?.
Bom estou com uma dúvida, estou criando um banco de dados para uma academia atualizar sua seção de horários com as aulas, a pagina orignal em html está assim:

Posted Image

O que fiz em asp ficou assim:

Posted Image

O código que usei está abaixo: 

<?xml version="1.0" encoding="iso-8859-1"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title><style type="text/css"><!--.style1 {	color: #FF6600;	font-size: 14px;	font-weight: bold;}.style2 {	font-family: Arial, Helvetica, sans-serif;	font-size: 12px;}--></style></head><body link="#000000" leftmargin="0"><STYLE type=text/css>BODY {SCROLLBAR-FACE-COLOR: white;SCROLLBAR-HIGHLIGHT-COLOR: white;SCROLLBAR-SHADOW-COLOR: #DEDEDC;SCROLLBAR-3DLIGHT-COLOR: #DEDEDC;SCROLLBAR-ARROW-COLOR: #000053; SCROLLBAR-DARKSHADOW-COLOR: #000053; SCROLLBAR-BASE-COLOR: #DEDEDC;}</STYLE><%strConnection = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("horarios.mdb") & ";"Set adoDataConn = Server.CreateObject("ADODB.Connection")adoDataConn.Open strConnection 	  strQuery = "SELECT * FROM ginastica"   	  Set RS = adoDataConn.Execute(strQuery)          While not RS.eof 	  %><table width="93%" height="70" border="0" cellpadding="0" cellspacing="0">  <tr>    <td>&nbsp;</td>    <td><p class="style1"><font color="#FF6600"><strong>GIN&Aacute;STICA </strong></font><font color="#000000" >- </a> <a href='java script:;' onClick='window.print();return false'>imprimir</a></a></font><br /></p>      <table width="100%" border="1" cellspacing="0" cellpadding="0">        <tr>          <td width="11%" bordercolor="#333333"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">IN&Iacute;CIO</font></strong></font></div>          </td>          <td width="11%" bordercolor="#333333"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">T&Eacute;RMINO</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">SEGUNDA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">TER&Ccedil;A</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">QUARTA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">QUINTA</font></strong></font></div>          </td>          <td width="15%" bordercolor="#000000"><div align="center"><font size="2"><strong><font face="Arial, Helvetica, sans-serif">SEXTA</font></strong></font></div>          </td>        </tr>        <tr>          <td bordercolor="#333333"><div align="center"><strong><%Response.Write RS("incioaula") %></strong></div>          </td>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">07:40</font></strong></div>          </td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.                adulto</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adt. inic.</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adulto</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Nat.          adt. inic.</strong></font></div></td>          <td bgcolor="#666666"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>        </tr>        <tr>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">07:40</font></strong></div>          </td>          <td bordercolor="#333333"><div align="center"><strong><font size="2" face="Arial, Helvetica, sans-serif">08:30</font></strong></div>          </td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font><font size="2" face="Arial, Helvetica, sans-serif"></font></div></td>          <td bgcolor="#666666"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Hidro</strong></font></div></td>          <td bgcolor="#666666"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif"></font></div>                <p align="justify" class="style2">&nbsp;</p></td>  	</td>        </tr>      </table>  </tr> </table> <%      RS.MoveNext     wend   RS.CloseadoDataConn.Close%></body></html>

Sou novo com programação em asp, se poderem me ajudar aonde eu errei pq esta duplicando duas colunas, eu agradeço! valeu
Abraço,
Good Vibe

#2 Jow Xavier

Jow Xavier

    Turista

  • Usuários
  • 39 posts
  • Sexo:Masculino

Posted 15/07/2008, 13:23

Cara vc tá mandando a tabela dentro de um loop .... tente mais ou menos assim:
<table>
<tr>
<td>INICIO</td>
<td>TÉRMINO</td>
<td>SEGUNDA</td>
<td>TERÇA</td>
<td>QUATRA</td>
<td>QUINTA</td>
<td>SEXTA</td>
<% if not tab.eof then
	 while not tab.eof
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
<td><%=VARIAVEL("CAMPO")%></td>
</tr>
<% tab.movenext
	wend
else			
	 response.write "Nenhum registro encontrado" 
	 
			<% end if %>
</table>

Edição feita por: Jow Xavier, 15/07/2008, 13:23.

Voltar para ASP


1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

  1. Fórum WMO
  2. → Desenvolvimento
  3. → ASP
  4. Privacy Policy
  5. Regras ·
IPB Skin By Virteq