Esposizione di ADO

English | French | Portugese | Dutch | Italian

in linea

|

Codici sorgente

|

|

Trasferimenti dal sistema centrale verso i satelliti

|

Metterseli in contatto con

|

HTML Tutorials

TCP/IP Tutorial

XML Tutorials

Schema Tutorial

XForms Tutorial

XSL-FO Tutorial

XML DOM Tutorial

XQuery Tutorial

XPointer Tutorial

Web Services Tutorial

Browser Scripting

JavaScript Tutorial

VBScript Tutorial

HTML DOM Tutorial

WMLScript Tutorial

Server Scripting

.NET (dotnet)

XML Web Services

Multimedia

Web Building

Java Tutorials

Servlets Tutorial

Struts Tutorial

Programming Langauges

Visual Basic Tutorial

Data Structures Using C

Soft Skills

Communication Skills

Time Management

Project Management

Leadership Skills

Corporate Communication

Negotiation Skills

Esposizione di ADO

Previous

Next

Il senso generale visualizzare i dati da un recordset, � visualizzare i dati in una tabella del HTML.

Visualizzare i nomi di campo ed i valori del campo

Abbiamo una base di dati chiamata �vyom� e desideriamo visualizzare i dati dalla tabella che �degli impiegati� conserviamo la lima con un'estensione di .asp.

<html>
<head>

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/vyomworld/vyom.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM employee", conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "<br />")
next
Response.Write("<br />")
rs.MoveNext
loop
rs.close
conn.close

%>

</head>
</html>

Uscita: Esposizione As--

EmloyeeID = Sys04
CompanyName = Vyom Technosoft
ContactName = Raj
ContactTitle = Developer
Address = STPI-Block3
City = Electronic city
PostalCode = 560100
Country = India

EmloyeeID = Sys03
CompanyName = Vyom Technosoft
ContactName = Rajeev
ContactTitle = Developer
Address = STPI-Block3
City = Electronic city
PostalCode = 560100
Country = India

EmloyeeID = Sys01
CompanyName = Vyom Technosoft
ContactName = Raju
ContactTitle = System Admin
Address = silicon vally
City = Electronic city
PostalCode = 560100
Country = India

Visualizzare i nomi di campo ed i valori del campo in una Tabella del HTML

Possiamo visualizzare i dati dalla tabella �di Emloyee� all'interno di una tabella del HTML con le seguenti linee e conservare la lima con un'estensione di .asp.

<html>
<head>

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/vyomworld/vyom.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT Companyname, Contactname FROM employee", conn %>
<table border="1" width="100%">
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
>/tr>
<%loop
rs.close
conn.close

%>

</head>
</html>

Uscita: Esposizione As--


Vyom	Rajeev
Royal Soft	Sedan
IT Tech	Grayan
Global IT	T koock
Soft Uro	Dol Gerg
Tera Soft	Rana
RevaTech	Peter Ron
MicroSolution	Kurdin
TenSoftware	Waren
Riya Chemical	Revan
Riyan Hardware	Rojon
BangaSoft	Surab
ZSoft	Wallan
TechSoft	Prasie
RoyTech Group	Hrosod
Silicon Tech Group	Jupit
Big International	Partijar

Aggiungere le intestazioni alla Tabella del HTML

Se desideriamo aggiungere le intestazioni alla tabella del HTML per renderla pi� leggibile. Per esempio:

<html>
<head>

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/vyomworld/vyom.mdb"
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM Employee"
rs.Open sql, conn
%>

<table border="1" width="100%">

<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close

%>

</table>
%>

</head>
</html>

Uscita: Esposizione As--


Company Name	Employee Name
Vyom	Rajeev
Royal Soft	Sedan
IT Tech	Grayan
Global IT	T koock
Soft Uro	Dol Gerg
Tera Soft	Rana
RevaTech	Peter Ron
MicroSolution	Kurdin
TenSoftware	Waren
Riya Chemical	Revan
Riyan Hardware	Rojon
BangaSoft	Surab
ZSoft	Wallan
TechSoft	Prasie
RoyTech Group	Hrosod
Silicon Tech Group	Jupit
Big International	Partijar

Previous

Next

Keywords:ADO Display, visual basic ado, ado asp net, ado stored procedure, microsoft access ado, ado sql server

HTML Quizes

XML Quizes

Web Services Quiz

Browser Scripting Quizes

JavaScript Quiz

Server Scripting Quizes

.NET (dotnet) Quizes

Microsoft.Net Quiz

XML Web Services Quiz

.Net Mobile Quiz

C# : C Sharp Quiz

Multimedia Quizes

Web Building Quizes

Web Browsers Quiz

Web Hosting Quiz

Web Building Quiz

Web Quality Quiz

Web Semantic Quiz

Web Careers Quiz

Java Quizes

Programming Langauges Quizes

Visual Basic Quiz

Data Structures Using C Quiz

Soft Skills Quizes

Communication Skills Quiz

Time Management Quiz

Project Management Quiz

Leadership Skills Quiz

Corporate Communication Quiz

Negotiation Skills Quiz

Copyright � 2003-2008 Vyom Technosoft Pvt. Ltd., All Rights Reserved.