Click here to Skip to main content
15,922,696 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: aboutdotnet framework Pin
Abhijit Jana7-Oct-08 19:20
professionalAbhijit Jana7-Oct-08 19:20 
AnswerRe: aboutdotnet framework Pin
Brij7-Oct-08 20:33
mentorBrij7-Oct-08 20:33 
QuestionSqlMembershipProvider - MembershipUser.ResetPassword not working? Pin
Member 39190497-Oct-08 13:58
Member 39190497-Oct-08 13:58 
QuestionMaximum Concurrent Connections Pin
davidhere407-Oct-08 11:48
davidhere407-Oct-08 11:48 
AnswerRe: Maximum Concurrent Connections Pin
Ashfield7-Oct-08 22:49
Ashfield7-Oct-08 22:49 
GeneralRe: Maximum Concurrent Connections Pin
davidhere408-Oct-08 2:09
davidhere408-Oct-08 2:09 
GeneralRe: Maximum Concurrent Connections Pin
Ashfield8-Oct-08 19:45
Ashfield8-Oct-08 19:45 
AnswerCHECK BOXES INTERACTIVE PROBLEM VIA DBASE Pin
Hasitha Fernando7-Oct-08 2:36
Hasitha Fernando7-Oct-08 2:36 
PLEASE KIND ENOUGH TO CORRECT MY SNIPPET,
I WANT TO CREATE SOME LAYOUT WHEN CHECK BOX CLICK AND SUBMIT, YES IT WORKS NICELY, BUT TWO RECORDS VIEWING SEPERATELY UNDER TWO SUBMIT BUTTON, I WANT TO FIX THIS BROBLEM AND THESE TWO RECORDS UNDER ONE SUBMIT BUTTON AND EACH RECORD MUST HAVE A CHECK BOX.
THANKS
HOPE QUICK REPLY FROM ALL

THIS IS THE "SELECT.ASP"
<html>
<head>
<title><title>
<head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0">

<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsGuestbook 'Holds the recordset for the records in the database
Dim strSQL 'Holds the SQL query for the database



'Create an ADO connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &amp; Server.MapPath("excel.mdb")


'Set an active connection to the Connection object using a DSN-less connection

'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"

'Create an ADO recordset object
Set rsGuestbook = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
If Request.Form("select") &lt;&gt; "" then
strSQL = " SELECT domani.vessel, domani.voyage, domani.portloading, domani.portdis, domani.datearrive, domani.reference, domani.blno, domani.shipper, domani.sadd_a, domani.sadd_b, domani.sadd_c, domani.notify, domani.consignee, domani.cadd_a, domani.cadd_b, domani.cadd_c, domani.desgood, domani.desgood_a, domani.desgoodtxt, domani.destxt_a, domani.destxt_b, domani.pkgs, domani.gross, domani.cbm, domani.contseal, domani.marks, domani.vedeagent, domani.expires, domani.serial, domani.agent, domani.figure, domani.pakgword FROM domani WHERE reference='" &amp; Request.Form("select") &amp; "'"
'Open the recordset with the SQL query
rsGuestbook.Open strSQL, adoCon
end if
'Open the recordset with the SQL query
if not rsGuestbook.EOF then

'Loop through the recordset
Do While not rsGuestbook.EOF

'rsGuestbook.AddNew
'Write the HTML to display the current record in the recordset
%>



<form action="manifestchk.asp" name="chk" method="post">


<input type="checkbox" name="chk1" value=">%Response.Write (rsGuestbook("blno"))%&gt;"&gt;&lt;BR&gt;&lt;%Response.Write (rsGuestbook("blno"))%&gt;

&lt;input type="submit" name="Submit" value="Submit"&gt;

&lt;/form&gt;


&lt;%
'Move to the next record in the recordset
rsGuestbook.MoveNext

Loop

'Reset server objects
else
Response.Write ("&lt;font size='4' color='red'&gt; Error!!!!!!!!! Enter the Correct Code, Thanks&lt;/font&gt;")
end if' if not rsGuestbook.EOF then
rsGuestbook.Close
Set rsGuestbook = Nothing
Set adoCon = Nothing
%&gt;


</body>
</html>

=============================

hasitha
GeneralRe: CHECK BOXES INTERACTIVE PROBLEM VIA DBASE Pin
J4amieC7-Oct-08 2:46
J4amieC7-Oct-08 2:46 
GeneralRe: CHECK BOXES INTERACTIVE PROBLEM VIA DBASE Pin
Paul Conrad7-Oct-08 6:23
professionalPaul Conrad7-Oct-08 6:23 
QuestionShow Multi line text box data on label Pin
nikhil12347-Oct-08 2:35
nikhil12347-Oct-08 2:35 
AnswerRe: Show Multi line text box data on label Pin
Abhijit Jana7-Oct-08 2:40
professionalAbhijit Jana7-Oct-08 2:40 
AnswerRe: Show Multi line text box data on label Pin
Andreas X7-Oct-08 2:41
professionalAndreas X7-Oct-08 2:41 
AnswerRe: Show Multi line text box data on label Pin
N a v a n e e t h7-Oct-08 3:31
N a v a n e e t h7-Oct-08 3:31 
QuestionClient Script is not working Pin
pinna_hari7-Oct-08 2:21
pinna_hari7-Oct-08 2:21 
AnswerRe: Client Script is not working Pin
Abhijit Jana7-Oct-08 2:38
professionalAbhijit Jana7-Oct-08 2:38 
GeneralRe: Client Script is not working Pin
pinna_hari7-Oct-08 20:49
pinna_hari7-Oct-08 20:49 
Questionarraylist Pin
eyeseetee7-Oct-08 0:51
eyeseetee7-Oct-08 0:51 
AnswerRe: arraylist Pin
Guffa7-Oct-08 0:56
Guffa7-Oct-08 0:56 
GeneralRe: arraylist Pin
eyeseetee7-Oct-08 1:05
eyeseetee7-Oct-08 1:05 
AnswerRe: arraylist Pin
sumit70347-Oct-08 1:05
sumit70347-Oct-08 1:05 
GeneralRe: arraylist Pin
eyeseetee7-Oct-08 1:27
eyeseetee7-Oct-08 1:27 
General[Message Deleted] Pin
J4amieC7-Oct-08 1:55
J4amieC7-Oct-08 1:55 
GeneralRe: arraylist Pin
eyeseetee7-Oct-08 2:03
eyeseetee7-Oct-08 2:03 
GeneralRe: arraylist Pin
J4amieC7-Oct-08 2:47
J4amieC7-Oct-08 2: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.