JavaScript connection string for Access database

vinidimple · March 12th, 2009, 03:11 AM

Create a table with userid,username,pwd,fullname in sql server Databse and execute the below code

Code:

<!DOCTYPE HTML PUBLIC "-//w3c//DTD HTML 3.2//EN">
<html>
<HEAD>
<TITLE>HTML PROGRAM</TITLE>
</HEAD>
<BODY>
<a href="../HTML/test.html"  >link1</a>
<P>
    <LABEL ACCESSKEY=U>USER NAME : <INPUT id="txtUser" TYPE="TEXT" NAME="txtUser"  SIZE=8 MAXLENGTH=8 /></LABEL>
</P>
<P>
<LABEL ACCESSKEY=U>PASSWORD : <INPUT id="txtPwd" TYPE="PASSWORD" NAME="txtPwd" SIZE=8 MAXLENGTH=8 /></LABEL>
</P>

<P>
    <INPUT id="btnOK" TYPE="Submit" NAME="btnOK" Value="SUBMIT" ONCLICK="display()" />
</P>

<table border="1" id="testtable">
<TR>

    <TD>user Id</TD>
    <TD>UserName</TD>
    <TD>FullName</TD>  
</TR>   
   
</table>

</BODY>

</html>

<SCRIPT language="Javascript" runat="server">

var strConnection;
var strConn;
var rs;
var txtUsername,txtPwd;
    

    function display()

    {
        txtUsername=document.getElementById("txtUser").value;

        txtPwd=document.getElementById("txtPwd").value;        

        if (txtUsername !="" && txtPwd!="")
        {
 
            window.alert ("Hello: " + txtUser.value);
            AddRow();
            
        }        
    }
    
    function AddRow()
    {
        var table,row,col1,col2,col3;                

        CreateRecordSet();
        
        
        table = document.getElementById("testtable");
        
        
        if(table)
        {
    
            while (!rs.EOF)    
            {
                row=table.insertRow(-1);
                col1=row.insertCell(-1);
                col2=row.insertCell(-1);
                col3=row.insertCell(-1);                        
                col1.innerHTML=rs("id");            
                col2.innerHTML=rs("username");            
                col3.innerHTML=rs("FullName");
                        
            rs.moveNext();
            }            
            
        
        }

        CloseConnection();    
    }

    

    function CloseConnection()

    {
        rs=null;        
    
        strConnection.Close();
    
        strConn=null;        
        
    }
    
    function OpenConnection()

    {                

        strConn = "PROVIDER=SQLOLEDB;SERVER=ws-in308;UID=sa;PWD=sa123;DATABASE=thetest; Persist Security Info=False";        

        strConnection =new ActiveXObject("ADODB.Connection");
        
        strConnection.Open(strConn);

        
        
    }
    
    function CreateRecordSet()

    {
        var sql;

        OpenConnection();
    
        sql = "select id,username,FullName from login where username='"+ txtUsername +"'and pwd='"+txtPwd+"'";
                
        rs=new ActiveXObject("ADODB.recordset");            
        
        if(strConnection)
        {
            
            rs.Open (sql, strConnection);

            if (!rs.EOF)
            {    
                return rs;            
            }            
            
        }

        else

        {
            window.alert ("Sorry no connection");
        }
        
        
        
    }
    
    

    
</SCRIPT>

Thanks
Vineetha Mathew