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

PL/SQL Tutorial

.NET (dotnet)

Multimedia

Photoshop Tutorial

Gnuplot Programming

GIF Animation Tutorial

Scientific Visualization Tutorial

Web Building

Weblogic Tutorial

Web Site Hosting

Java Tutorials

Servlets Tutorial

Struts Tutorial

Programming Langauges

Visual Basic Tutorial

Data Structures Using C

Assembly Language

Forth Programming

Lisp Programming

Data Warehousing

CGI Programming

Soft Skills

Communication Skills

Time Management

Project Management

Leadership Skills

Corporate Communication

Negotiation Skills

Database Tutorials

Operating System

IP-Masquerading

Software Testing

SAP Module

Business Warehousing

Material Management

Sales & Distribution

Customer Relationship Management

Production and Planning

Networking Programming

Networking Tutorial

Microsoft Office

Microsoft Outlook

Microsoft PowerPoint

Microsoft Publisher

Microsoft Excel

Microsoft Front Page

Microsoft InfoPath

Microsoft Access

Accounting

Financial Accounting

Managerial Accounting

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

Apple Script Quiz

SQL Server Quiz

.NET (dotnet) Quizes

Microsoft.Net Quiz

.Net Mobile Quiz

C# : C Sharp Quiz

Multimedia Quizes

Gnuplot Programming Quiz

GIF Animation Quiz

Scientific Visualization Quiz

Web Building Quizes

Web Browsers Quiz

Web Hosting Quiz

Web Building Quiz

Web Quality Quiz

Web Semantic Quiz

Web Careers Quiz

Web Site Hosting Quiz

Domain Name Quiz

Java Quizes

Programming Langauges Quizes

Visual Basic Quiz

Data Structures Using C Quiz

Assembly Language Quiz

Forth Programming Quiz

Lisp Programming Quiz

Data Warehousing Quiz

CGI Programming Quiz

Soft Skills Quizes

Communication Skills Quiz

Time Management Quiz

Project Management Quiz

Leadership Skills Quiz

Corporate Communication Quiz

Negotiation Skills Quiz

Database Quizes

Operating System Quizes

IP-Masquerading Quiz

Software Testing Quizes

SAP Module Quizes

Business Warehousing Quiz

Material Management Quiz

Sales & Distribution Quiz

Human Resource Quiz

Customer Relationship Management Quiz

Production and Planning Quiz

Networking Programming Quizes

Networking Quiz

Microsoft Office Quizes

Microsoft Word Quiz

Microsoft Outlook Quiz

Microsoft PowerPoint Quiz

Microsoft Publisher Quiz

Microsoft Excel Quiz

Microsoft Front Page Quiz

Microsoft InfoPath Quiz

Microsoft Access Quiz

Accounting Quizes

Financial Accounting Quiz

Managerial Accounting Quiz

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