Help with ASP.net file

Printable View

September 29th, 2010, 07:17 PM
zehrasyeda

Help with ASP.net file

Hello,

I need help with Asp.net file.

I am trying to create a website that will take input from user, and when user clicks submit, it will run the asp.net file which will take the data and place it into a MS Access Table.

I have created the html page, the asp.net file and the db.

But when user clicks Submit, a pop up comes up that asks user to either open, save or cancel the asp.net file.

What am I doing wrong. Here is the code from the Asp.net file:
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head>
<title>Form to database</title>
</head>
<body>
<%
'declare your variables
Dim Card#, FirstName, LastName, DOB, CellPhone, Gender, StoreName, EmailAddress
Dim sConnString, connection, sSQL

' Receiving values from Form, assign the values entered to variables
Card# = Request.welcome.html("Card#")
FirstName = Request.welcome.html("FirstName")
LastName =Request.welcome.html("LastName")
DOB =Request.welcome.html("DOB")
CellPhone =Request.welcome.html("CellPhone")
Gender =Request.welcome.html("Gender")
StoreName =Request.welcome.html("StoreName")
EmailAddress =Request.welcome.html("EmailAddress")

'declare SQL statement that will query the database
sSQL = "INSERT into G&L Table (Card#, First Name, Last Name, DOB, Cell Phone, Gender, Store Name, Email Address) values ('" & Card# & "', '" & FirstName & "', '" & LastName & "', '" & DOB & "', '" & CellPhone & "', '" & Gender & "', '" & StoreName & "','" & EmailAddress & "',)"

'define the connection string, specify database
'driver and the location of database
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("Test1.accdb")

'create an ADO connection object
Set connection = Server.CreateObject("ADODB.Connection")

'Open the connection to the database
connection.Open(sConnString)

'execute the SQL
connection.execute(sSQL)

response.write "The form information was inserted successfully."

' Done. Close the connection object
connection.Close
Set connection = Nothing
%>
</body>
</html>
September 30th, 2010, 08:13 AM
Craig Gemmill

Re: Help with ASP.net file

Can we see the code for the HTML file?

It sounds like either you're web server is not configured to handle asp files, or your HTML page is coded incorrectly.
October 1st, 2010, 08:04 AM
zehrasyeda

Re: Help with ASP.net file

Here is the code from the body of the html file

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">

</style>
</head>

<body>
<form id="form1" name="form1" method="post" action="posttodb.asp">
<label></label>
<label></label>
<table width="1066" height="191" border="0">

<tr>
<td width="138"><label>Card# </label></td>
<td width="912"><input type="text" name="Card#" id="Card#" /></td>
</tr>
<tr>
<td><label>FirstName </label></td>
<td><input type="text" name="FirstName" id="FirstName" /></td>
</tr>
<tr>
<td>LastName</td>
<td><input type="text" name="Last Name" id="Last Name" /></td>
</tr>
<tr>
<td><label>DOB </label></td>
<td><label>
<input type="text" name="DOB" id="DOB" />
</label></td>
</tr>
<tr>
<td><label>CellPhone </label></td>
<td><label>
<input type="text" name="CellPhone" id="CellPhone" />
</label></td>
</tr>
<tr>
<td><label>EmailAddress</label></td>
<td><input type="text" name="EmailAddress" id="EmailAddress" /></td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="radio" name="Gender" value="radio" id="Gender_0" />
Male</label>
<br />
<label>
<input type="radio" name="Gender" value="radio" id="Gender_1" />
Female</label></td>
</tr>
<tr>
<td><label>StoreName </label></td>
<td><label>
<input type="text" name="StoreName" id="StoreName" />
</label></td>
</tr>
</table>
<p>

</form>
</body>
</html>

Thanks
October 2nd, 2010, 10:41 AM
Craig Gemmill

Re: Help with ASP.net file

Yeah, you have to run that page from a web server that supports ASP (IIS for example). You cannot just execute ASP scripting on your desktop.
October 6th, 2010, 04:46 PM
zehrasyeda

Re: Help with ASP.net file

Now I keep getting an internal server error as soon as I clik on Submit.

The code looks ok right?

Any ideas?
October 6th, 2010, 04:57 PM
dglienna

Re: Help with ASP.net file

What server do you have? Did you install the ASP batch file from VS2010?

If you didn't have IIS installed when you installed VS2010, it doesn't load it