CODEWITHSUNDEEP
javascriptjqueryasp.nethtml
JDV590
JDV590

Reputation: 651

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

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

Upvotes: 1

Views: 1593

Answers (1)

rick schott
rick schott

Reputation: 21137

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

Upvotes: 1

Related Questions