?
Solved

Connect Web Page with Arena(Simulation Software)

Posted on 2007-07-20
7
Medium Priority
?
485 Views
Last Modified: 2008-09-17
i need a code to connect web page with ARENA(Simulation Software).
 I have to write a code on IIS. I have to give input to ARENA through web page and the results given by ARENA should be seen on web page
0
Comment
Question by:PrasadKPatil
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:effx
ID: 19537800
We will need more information than that what you are providing, for example what language do you wish to use eg. ASP, JSP or any other.

what you wish to import/export.
0
 

Author Comment

by:PrasadKPatil
ID: 19539236
I am using ASP and IIS server.
 Or simply provide me a code to connect web page and microsoft access or excel.
For eg. I should see some 10 text box input fields in web page. When i enter values in each text field,
 it should go to one coloumn of Acess table or excel sheet.[ excel sheet is preffered].
   If i have already some values in Acess table and Excel sheet. I should be able to  see those values on web page in the form of some documents.
    I will look at ARENA part myself. Pls help me
  Thanks
0
 
LVL 10

Accepted Solution

by:
effx earned 2000 total points
ID: 19540167
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Database Example</title>
</head>

<body>
<%
Database_Path = Server.MapPath("/") & "\..\database\" & "mydatabase.mdb"
Table_Name = "MyTable"
Field_Names = "field1,field2,field3,field4,field5,field6" 'Separated by ,
'#####################All you need to update is above this line
Field_Name = Split(Field_Names, ",")
If Request.QueryString("updated") = "true" Then
      Set oRS = Server.CreateObject("ADODB.Recordset")
            oRS.CursorType = 2
            oRS.LockType = 3
            strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Database_Path & ";Persist Security Info=False"
            sSQL = "SELECT * FROM " & Table_Name
            oRS.Open sSQL, strCon
                  oRS.AddNew
                  For Field_Updates = 0 To Ubound(Field_Name)
                        oRS.Fields(Trim(Field_Name(Field_Updates))) = Request.Form(Trim(Field_Name(Field_Updates)))
                  Next
                  oRS.Update
            oRS.Close
      Set oRS = Nothing
Else
%>
<form id="form1" name="form1" method="post" action="">
<table border="1" cellspacing="0" cellpadding="0">
<%
For X = 0 To Ubound(Field_Name)
%>
  <tr>
    <td><%=Field_Name(X)%></td>
    <td>:</td>
    <td><input type="text" name="<%=Trim(Field_Name(X))%>" /></td>
  </tr>
<%
Next
%>
  <tr>
    <td colspan="3" align="right"><input type="submit" name="Submit" value="Submit" /></td>
  </tr>
</table>
</form>
<%
End If
%>
</body>
</html>
0
 

Author Comment

by:PrasadKPatil
ID: 19540612
Thanks for above code. I need code for same application when i create web application using
 NetBeans 5.5. The above code is for IIS server. Please send me code for  NetBeans 5.5. I think
  NetBeans 5.5 is having TomCat server.
 thanks
0
 
LVL 10

Expert Comment

by:effx
ID: 19540925
You said you were using IIS and ASP, ou cant change the question now.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview
Suggested Courses
Course of the Month16 days, 18 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question