TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mo Khan
NA
14
499
How to change HTML tables in aspx based on query results fro
May 19 2020 10:59 AM
I am trying to understand how to change "Table" data in aspx based on the search results I get from SQL query. I have six different tables which corresponds to the information related to the license type a user have in my organization. How do I display other content or change text on the table which to a completely different set of information. I am not trying to show data from database table. I have html tables and I want to change those based on query results.
I am not trying to bind the data from database to html. The other tables have the same format as the code below but with different text.
Any kind of help or get started will be helpful.
Here is my SQL query which searches for the result:
SELECT * FROM [DBNNAME].[dbo].[TableName] Where UPN like '%'+@UPN+'%' And LicenseType in ('(Plan E3)' , '(Plan E5)' , '(Plan F1)', 'Conferencing') And ZoomStatus IS NULL OR UPN like '%'+@UPN+'%' And LicenseType in ((Plan E3)' , '(Plan E5)' , '(Plan F1)', 'Conferencing') And ZoomStatus = 'active' "
<!-- begin snippet: js hide: false console: true babel: false -->
<!-- language: lang-html -->
<div><table>
<thead>
<tr>
<th> </th>
<th style="text-align:center" class="auto-style1">ABCD</th>
<th colspan="2" style="text-align:center">ABCD</th>
</tr>
</thead>
<tbody>
<tr>
<td> </td>
<td data-column="Standard" style="text-align:center" class="auto-style1">ABCD</td>
<td data-column="Premium" style="text-align:center">ABCD</td>
<td data-column="Premium" style="text-align:center">ABCD</td>
</tr>
<tr>
<td data-column="Enabled" style="text-align:left;">Enabled</td>
<td id="Value1" runat="server" style="text-align:center; font-size:150%; font-weight:bold; color:green;" class="auto-style1"></td>
<td id="Value2" runat="server" style="text-align:center; font-size: 150%; font-weight:bold; color:green;"></td>
<td id="Value3" runat="server" style="text-align:center; font-size: 150%; font-weight:bold; color:green;"></td>
</tr>
<tr>
<td data-column="Highlights" style="text-align:left;">ABCD</td>
<td data-column="ABCD" class="auto-style1">
<ul>
<li>ABCD</li>
<br />
<li>ABCD</li>
</ul>
</td>
<td data-column="ABCD">
<ul>
<li>ABCD</li>
<br />
<li>ABCD</li>
<br />
<li>ABCD</li>
</ul>
</td>
<td data-column="ABCD">
<ul>
<li>ABCD</li>
<br />
<li>ABCD</li>
<br />
<li>ABCD</li>
</ul>
</td>
</tr>
<tr>
<td id="Value4" runat="server" data-column="Host">ABCD</td>
<td colspan="2">TABCD<a href="test">here</a></td>
<td>
<asp:CheckBox ID="HostOnly" type="checkbox" name="HostOnly" value="HostOnly" runat="server" />
</td>
</tr>
</tbody>
</table>
<!-- end snippet -->
Reply
Answers (
7
)
How to login an application through linkedin
Where I can find good examples of REST web API