<html>
<head>
<script type="text/javascript">
<!--
var adOpenDynamic = 2;
var adLockOptimistic = 3;
/* Path of database.
*/
var strDbPath = "E:\\master1.mdb";
/*
Here is the ConnectionString for Microsoft Access.
If you want to use SQL or other databases, you hav to change the connection string..
eg: SQL => var conn_str = "Provider=sqloledb; Data Source=itdev; Initial Catalog=pubs; User ID=sa;Password=yourpassword";
*/
var conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDbPath;
function getAdoDb(strAdoType)
{
if (window.ActiveXObject)
{
return new ActiveXObject(strAdoType);
}
else
{
return ActiveXObject(strAdoType);
}
}
function showReports()
{
try
{
var strHtml ="";
strHtml += "<table cellpadding=0 cellspacing=0 border=1 width= '100%' align=center>";
strHtml += "<tr ><td align=center colspan=4><b>Insurance items</b></td></tr>";
//Database Connection
var conn = getAdoDb("ADODB.Connection");
conn.open(conn_str, "", "");
var val1=document.getElementById('txt1').value;
var val2=document.getElementById('txt2').value;
//Recordset
var rs = new ActiveXObject("ADODB.Recordset");
//strQuery = "insert into xxx values (12,'csdfcsd')";
strQuery ="insert into xxx values ("+ document.getElementById('txt1').value +")";
alert(val2);
rs.open(strQuery, conn, adOpenDynamic, adLockOptimistic);
if(!rs.bof)
{
rs.MoveFirst();
while(!rs.eof)
{
strHtml += "<tr>";
strHtml += " <td><Font face ='tahoma'>" + rs.fields(0).value + "</font></td>";
strHtml += "</tr>";
rs.MoveNext();
}
}
else
{
//No Records.
strHtml += "<tr colspan=4><td align=center><font color=red>No Records.</font></td></tr>";
}
conn.close();
strHtml += "</table>";
document.write(strHtml);
}
catch(ex)
{
alert(ex.message);
}
}
//-->
</script>
<title>Call Log Details</title>
</head>
<body>
<div id="main" />
<body>
//<script language="JavaScript">
// showReports();
//</script>
<TABLE>
<TR>
<TD>Text</TD>
<TD>
<INPUT TYPE="TEXT" id="txt1" NAME="txt1">
</TD>
</TR>
<TR>
<TD>Text</TD>
<TD>
<INPUT TYPE="TEXT" id="txt2" NAME="txt2">
<input type="submit" value="submit" onclick="showReports();">
</TD>
</TR>
</TABLE>
</body>
</html>
No comments:
Post a Comment