Mo Khan

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>&nbsp;</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>&nbsp;</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 -->

Answers (7)