Questions

How to display Microsoft Access Report via ASP.Net page

Tags:
+
0 Votes
Locked

How to display Microsoft Access Report via ASP.Net page

waikeatl
Hi,
Is there anyone can assist me how to display Microsoft Access Report in ASP.Net page. i would appreciate if anyone can help me.

Thank you,
WKLeong
  • +
    0 Votes
    jimmy-jam

    I would venture a guess to say there are lots of people here who can help you but you haven't given us much to work with.

    +
    0 Votes
    jimmy-jam

    Based on what you've told me so far you already have your access table and you simply want to display it on a web page.

    In its simplest form all you would really need to do is set up a database connection via a vbscript either by direct connection or an ODBC driver.

    Next bind you data results to a datagrid or a gridview on your page. If you only want to display it you could even set it up to trigger on page load.

    Basic structure

    <%@ Page Language="VB" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <script language=vbscript runat="server">
    Sub Page_Load()
    connection info goes here
    Dim an sql command
    Dim your datareader
    open your connection
    execute your command and bind it to you datagrid
    close you connection
    <body>
    your datagrid goes here
    </body>
    </html>

    We can get more specific with more specific questions. Post back when you have more questions.

  • +
    0 Votes
    jimmy-jam

    I would venture a guess to say there are lots of people here who can help you but you haven't given us much to work with.

    +
    0 Votes
    jimmy-jam

    Based on what you've told me so far you already have your access table and you simply want to display it on a web page.

    In its simplest form all you would really need to do is set up a database connection via a vbscript either by direct connection or an ODBC driver.

    Next bind you data results to a datagrid or a gridview on your page. If you only want to display it you could even set it up to trigger on page load.

    Basic structure

    <%@ Page Language="VB" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <script language=vbscript runat="server">
    Sub Page_Load()
    connection info goes here
    Dim an sql command
    Dim your datareader
    open your connection
    execute your command and bind it to you datagrid
    close you connection
    <body>
    your datagrid goes here
    </body>
    </html>

    We can get more specific with more specific questions. Post back when you have more questions.