Click here to Skip to main content
15,896,269 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: [ASP.net / C#] Checkbox Checked Always false Pin
Jeff Martin29-Mar-05 3:13
Jeff Martin29-Mar-05 3:13 
GeneralJavascript for adding html Pin
shaiba24-Mar-05 19:12
shaiba24-Mar-05 19:12 
GeneralRe: Javascript for adding html Pin
Yulianto.27-Mar-05 15:37
Yulianto.27-Mar-05 15:37 
GeneralRe: Javascript for adding html Pin
Anonymous27-Mar-05 17:33
Anonymous27-Mar-05 17:33 
GeneralRe: Javascript for adding html Pin
Yulianto.27-Mar-05 17:47
Yulianto.27-Mar-05 17:47 
GeneralASP.NET VB on DWMX for User Registration page Pin
bizjosh24-Mar-05 17:36
bizjosh24-Mar-05 17:36 
GeneralCSocket & critical sections under IIS 6 Pin
Sorin24-Mar-05 15:48
Sorin24-Mar-05 15:48 
GeneralASP cant read the data from the Access database Pin
Member 145397924-Mar-05 15:39
Member 145397924-Mar-05 15:39 
I already create the ASP script for the database and also set up the ODBC for the database, why my ASP still can't read the data from the database? Please help me!!!
This is the ASP code:
<form method = "POST" action="online_result.asp" onSubmit="validInput()">
<p align="center">ENTER FIRST NAME:
<input type="text" name="FirstName" size="20">
</p>
<p align="center">ENTER LAST NAME :
<input type="text" name="LastName" size="20">
</p>
<p align="center"> ENTER STUDENT ID:
<input type="password" name="StudentID" size="20">
</p>

<p align="center">
<input type="submit" value="Check In" name="Submit">
<input type="reset" value="Reset" name="Reset">
</p>
</form>

<%
Else
%>

<p align="center"><font face="Comic Sans MS" size="5">
<strong>YOUR RESULT</strong></font>
</p>

<%
Dim SQLString

SQLString = "SELECT student.StudentID, student.FirstName, student.LastName, result.SubjectTaken, result.Grade FROM student, result WHERE student.StudentID = result.StudentID"

If Not Request.Form.Item("StudentID") = "All" Then
SQLString = SQLString & " WHERE result.StudentID=" & chr(39) & Request.Form.Item("StudentID") & chr(39)
End If

If Not Request.Form.Item("FirstName") = " " Then
SQLString = SQLString & " AND result.FirstName=" & chr(39) & Request.Form.Item("FirstName") & chr(39)
End If

If Not Request.Form.Item("LastName") = " " Then
SQLString = SQLString & " AND result.LastName=" & chr(39) & _Request.Form.Item("LastName") & chr(39)
End If

'Create an instance for the Connection Object
Set DatabaseConnection = Server.CreateObject("ADODB.Connection")

'Open Connection to onlineresult database
DatabaseConnection.Open "FILEDSN=Studentresult.dsn"

'Create an instance of the recordset object
Set ResultRecordSet = Server.CreateObject("ADODB.RecordSet")

'Open the onlineresult database and retrieve the data
ResultRecordSet.Open SQLString, DatabaseConnection

Set objResultFirstName = ResultRecordSet("FirstName")
Set objResultLastName = ResultRecordSet("LastName")
Set objResultStudentID = ResultRecordSet("StudentID")
Set objResultSubjectTaken = ResultRecordSet("SubjectTaken")
Set objResultGrade = ResultRecordSet("Grade")

If ResultRecordSet.EOF Then
%>

<p align = "center"><font face ="Arial Black" size="5">
<strong>Sorry. No Records match your search!!!</strong></font>
</p>

<%
Else
%>

<%
<p align = "left"><font face="Arial Narrow" size="3">
<strong>Name: </strong> Response.Write "&objFirstName&" "&objLastName&"
</font>
</p>
<p align = "left"><font face="Arial Narrow" size="3">
<strong>Student ID : </strong> Response.Write "&objStudentID&"
</font>
</p>
%>

<Table border ="2" cellspacing="0" cellpadding="2">
<tr><td>Subject Code</td><td>Grade</td></tr>
<%
Do Until ResultRecordSet.EOF
Response.Write "<tr valign="top"><td>"&objResultSubjectTaken&"</td>
<td>"&objResultGrade&"
ResultRecordSet.MoveNext
Loop

DatabaseConnection.Close
Response.Write "</table>"

End If
End If
%>
GeneralRe: ASP cant read the data from the Access database Pin
Hesham Amin26-Mar-05 0:53
Hesham Amin26-Mar-05 0:53 
GeneralProblems Transfering div contents x-browser Pin
loane24-Mar-05 12:40
loane24-Mar-05 12:40 
GeneralQuestion regarding using the same input! Pin
Jamal42024-Mar-05 10:42
Jamal42024-Mar-05 10:42 
Generalcombo control appear infront of menu Pin
TariqMahmood24-Mar-05 0:41
TariqMahmood24-Mar-05 0:41 
GeneralCWebBrowser ActiveX Pin
Grahamfff23-Mar-05 10:46
Grahamfff23-Mar-05 10:46 
GeneralDestroying objects Pin
paixtis23-Mar-05 9:00
paixtis23-Mar-05 9:00 
GeneralA string problem.. Pin
Monisankar22-Mar-05 22:53
Monisankar22-Mar-05 22:53 
GeneralRe: A string problem.. Pin
Jeff Martin23-Mar-05 8:20
Jeff Martin23-Mar-05 8:20 
GeneralRe: A string problem.. Pin
kutz923-Mar-05 10:54
kutz923-Mar-05 10:54 
GeneralRe: A string problem.. Pin
Monisankar23-Mar-05 20:04
Monisankar23-Mar-05 20:04 
Generalmake class in java script Pin
Yulianto.22-Mar-05 15:44
Yulianto.22-Mar-05 15:44 
GeneralRe: make class in java script Pin
Edbert P22-Mar-05 19:07
Edbert P22-Mar-05 19:07 
GeneralJavascript ASP Login Pin
Shrex22-Mar-05 1:09
Shrex22-Mar-05 1:09 
Questionhow to open a save as dilog box using java script Pin
swaga22-Mar-05 0:31
swaga22-Mar-05 0:31 
GeneralJava Script loadJava Applet upon User Clicking A Button Pin
ahjiefreak21-Mar-05 22:45
ahjiefreak21-Mar-05 22:45 
Generalappend special characters onload Pin
21-Mar-05 10:12
suss21-Mar-05 10:12 
GeneralStarter Question Pin
Grahamfff21-Mar-05 8:47
Grahamfff21-Mar-05 8:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.