hiGary
first you write this code for a htm page (index.htm)
'''''''''''''code''''''''''''
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<SCRIPT LANGUAGE=javascript>
<!--
function ddd()
{
document.form1.action="normaldatabasecon.asp"
document.form1.submit()
}
//-->
</SCRIPT>
<BODY>
<form name=form1>
<input type=text name=email>
<input type=button Value=Submit id=button1 name=button1 onclick=ddd()>
</form>
</BODY>
</HTML>
'''''''''''''''''asp page (normaldatabasecon.asp''''''''''''''''''
<HTML>
<HEAD>
</HEAD>
<BODY>
<%
email=Request("email")
str="dsn=SAMPLE;uid="";pwd="";"
dim c,r
set c=server.CreateObject("adodb.connection")
set r=server.CreateObject("adodb.recordset")
c.open str
sql="Insert into client(name) values ('"&email&"')"
c.Execute sql
msg="your data is successfully added"
%>
</BODY>
<%=msg%>
</HTML>
'''''''''''''''''''''''''
and create a access database
'''''''''''''''''''''''''
field name :name type : text
tablename :client
Make DSN :SAMPLE
'''''''''''''''''''
surendran
|
