Connect Web Page with Arena(Simulation Software)

Posted on 2007-07-20
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
Question by:PrasadKPatil
    LVL 10

    Expert Comment

    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.

    Author Comment

    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
    LVL 10

    Accepted Solution

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
    <html xmlns="">
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Database Example</title>

    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
                      For Field_Updates = 0 To Ubound(Field_Name)
                            oRS.Fields(Trim(Field_Name(Field_Updates))) = Request.Form(Trim(Field_Name(Field_Updates)))
          Set oRS = Nothing
    <form id="form1" name="form1" method="post" action="">
    <table border="1" cellspacing="0" cellpadding="0">
    For X = 0 To Ubound(Field_Name)
        <td><input type="text" name="<%=Trim(Field_Name(X))%>" /></td>
        <td colspan="3" align="right"><input type="submit" name="Submit" value="Submit" /></td>
    End If

    Author Comment

    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.
    LVL 10

    Expert Comment

    You said you were using IIS and ASP, ou cant change the question now.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now