How to build a html table using SQL data set

Hi all,

I have a SQL database extract with a number of columns/rows. One of the column is Approver.

I want to loop through the rows to pick up all the records for each Approver and store it in array. Then I want to convert it into HTML table and and I want to create an array of tables (objects). Is creating an array of tables possible?

I should be fine with building the tables , i am not sure how to loop through the data to get the set of rows for each approver (in an array) which i can use to then create an HTML table.

0 REPLIES 0

Helpful resources

Announcements

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Find Your Community Today

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Share Your Thoughts