create an html table from MS access DB with asp or jquery

Question

I have an html table (3 cells per row) with each cell containing headshots (img) and then name, hometown, and class fields.

each headshot and name, hometown, and class relates to a member in a members table in an MS access DB. I want to write either asp or jquery script to go through each table record (member) and display their picture, name, hometown, and class.

This is a rough conceptual asp version of what I want to create : I would like to do this preferably in jquery... any help would be appreciated! thanks

<%
    Dim Sql = "select * from Sheet1"


DR = DataReader  (SQL)
While Not DR.EOF
    x = 1
    If  x < 4 Then %>
        <td><img src="avatar-blank.jpg" alt="headshot"/><br /><p>dr("Name") <br />Hometown: VarAddress <br /> Class: VarClass</p></td>
   <%  Else
       x = 0  %>  
        </tr>
        <tr>
        <td><img src="avatar-blank.jpg" alt="headshot" /><br /><p>VarName<br />Hometown: VarAddress<br />Class: VarClass</p></td>
   <%  End If
    x = x + 1
    DR.moveNext
Wend %>

I have this currently set up, its an html table inside a jquery-ui tabs. I want to make all this images and other fields filled with the information from a corresponding MS access DB Link to Image

jQuery is a client side scripting tool and is probably not relevant to this problem since you are writing a server side script in what looks like ASP classic. Anyway. What exactly is your question? — JohnFx
– JohnFx, Commented Nov 2, 2011 at 20:04
@JohnFx I want to dynamically create an html table with each cells contents being filled with an image and 2 text fields from an Access DB. I would be ok with doing this in either asp or jquery (using JSON or ajax) does that help? — JDV590
– JDV590, Commented Nov 2, 2011 at 20:08
@mumis2012 Your code example is in "Classic" ASP and is not appropriate for .NET 4 and your question about using jQuery demonstrates you are not familiar with the technology you are trying to use. Your question cannot be answered on this forum, you need to spend some time learning your technology, then come back with specific questions. — Sam
– Sam, Commented Nov 2, 2011 at 22:55

Community · Accepted Answer · 2017-05-23 12:21:10Z

1

jQuery is client-side and would require web services, there are plenty of examples, if you search here or on Google.

Here is an example using an asp:gridview and MS Access:

ind GridView with MS Access Database table in Asp.net

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Nov 2, 2011 at 20:19

rick schott

21.1k5 gold badges54 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create an html table from MS access DB with asp or jquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related