• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

Connect Web Page with Arena(Simulation Software)

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
PrasadKPatil
Asked:
PrasadKPatil
  • 3
  • 2
1 Solution
 
effxCommented:
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
 
PrasadKPatilAuthor Commented:
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
 
effxCommented:
<!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
 
PrasadKPatilAuthor Commented:
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
 
effxCommented:
You said you were using IIS and ASP, ou cant change the question now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now