31-01-2006, 07:57
|
|
|
|
חבר מתאריך: 29.01.06
הודעות: 1,596
|
|
תהנה!!!
וקרדיט לפורומים של תפוז!!!
קוד:
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
<SCRIPT LANGUAGE=javascript>
function pages(pageNum){
if( pageNum ==null)
{
pageNum=1
}
alert(pageNum )
var oConn=new ActiveXObject("ADODB.connection")
DSN="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\\tnuva.mdb';User Id=admin; Password="
SQL="SELECT top 10 tnuva.fname, tnuva.lname, tnuva.tz FROM tnuva;"
oConn.Open(DSN)
var oRs=new ActiveXObject("ADODB.recordSet")
oRs.PageSize =10
oRs.CacheSize =oRs.PageSize
oRs.Open(SQL, oConn,3,1)
document.write ( oRs.RecordCount )
document.write("<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=1>")
document.write(" <TR> <TD>שם </TD> <TD>תעודת זהות</TD> </TR>")
while (!(oRs.EOF))
{
document.write("<TR>")
document.write (" <TD>" +oRs.Fields("fname").Value +" </TD>")
document.write ("<TD>"+oRs.Fields("tz").Value +"</TD> ")
document.write("</TR>")
oRs.MoveNext()
}
oRs.Close()
oConn.Close()
delete oRs
delete oConn
document.write("</TABLE>")
}
pages()
</SCRIPT>
</BODY>
</HTML>
|