[AspNetAnyQuestionIsOk] Re: Help...

[Michael Swanson]

Here are some samples I can give to you.  See if any of these help.

1st Sample: Connecting to database
<%
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Persist Security
Info=False;Data Source=" & _
Server.MapPath("access_db/KC.mdb") 
%>

2nd Sample: Form for data entry
<table cellspacing="0" cellpadding="0" width="95%" ID="Table1">
<form name="customerForm" method="post" action="Resume.asp"
ID="Form2">
<tr>
<td colspan="2" align="center">Jobseeker's Contact Information</td>
<td></td>
</tr>
<tr>
<td align="right">Last Name: &nbsp;</td>
<td align="left"><input type="text" name="tLastN" id="tLastN"
size="30"></td>
</tr>
<tr>
<td align="right">First Name: &nbsp;</td>
<td align="left"><input type="text" name="tFirstN" id="tFirstN"
size="30"></td>
</tr>
<tr>
<td align="right">MI: &nbsp;</td>
<td align="left"><input type="text" name="tMI" size="3"
ID="Text1"></td>
</tr>
<tr>
<td align="right" valign="top">Email Address: &nbsp;</td>
<td align="left"><input type="text" name="tEmailAdd" id="tEmailAdd"
size="30"></td>
</tr>
<tr>
<td align="right" valign="top">Street Add: &nbsp;</td>
<td align="left"><input type="text" name="tStreetAdd" id="tStreetAdd"
size="30"></td>
</tr>
<tr>
<td align="right" valign="top">City: &nbsp;</td>
<td align="left"><input type="text" name="tCity" id="tCity"
size="15"></td>
</tr>
<tr>
<td align="right" valign="top">State: &nbsp;</td>
<td align="left"><input type="text" name="tState" id="tState"
size="15"></td>
</tr>
<tr>
<td align="right" valign="top">Zip: &nbsp;</td>
<td align="left"><input type="text" name="tZip" id="tZip"
size="15"></td>
</tr>
<tr>
<td align="right" valign="top">Phone: &nbsp;</td>
<td align="left"><input type="text" name="tPhone" id="tPhone"
size="30"></td>
</tr>
<tr>
<td align="right" valign="top">Password: &nbsp;</td>
<td align="left"><input type="password" name="tpassword"
id="tpassword" size="30"></td>
</tr>
<tr>
<td></td>
<td align="left">
<input type="submit" value="Next" ID="Submit1" NAME="Submit1">
</td>
</tr>
</form>
</table>

3rd Sample: Collecting and saving information
Part a || Connecting to database
<%
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Persist Security
Info=False;Data Source=" & _
Server.MapPath("access_db/KC.mdb") 
%>

Part b || Opening table and adding record
<%
        Set db = Server.CreateObject("ADODB.Connection")        
        db.Open (ConnectionString)      
        Set rs = Server.CreateObject("ADODB.Recordset")
        sSql = "SELECT * FROM Employees" 
        rs.Open sSql, db, 1, 3  
        rs.addnew       
        'Add values to fields   
        rs("FirstName") = Session("tLastN")
        rs("LastName") = Session("tFirstN")     
        rs("EmailAddress") = Session("tEmailAdd")
        rs("StreetAddress") = Session("tStreetAdd")
        rs("City") = Session("tCity")
        rs("State") = Session("tState")
        rs("Zip") = Session("tZip")
        rs("Phone") = Session("tPhone")
        rs("Password") = Session("tpassword")
        rs.Update
        rs.movelast                     
        rs.Close
        Set rs = Nothing
        db.Close
%>

I hope that gives you enough detail.  If this is not what you were
looking for then let me know.  I will see how else I can help you. 




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/