How to change HTML tables in aspx based on query results fro

Mo Khan

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' "

	ABCD	ABCD
	ABCD	ABCD	ABCD
Enabled
ABCD	ABCD ABCD	ABCD ABCD ABCD	ABCD ABCD ABCD
ABCD	TABCDhere

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vertika Chauhan6y ago
Accepted answer
So what I understand is that you have 6 different case and for each set you have different set of label to display as you are using asp.net technology you can use gridview for displaying data to user and with gridview u can easily hide or change the column value from code behind. If you have to use html table only then you have to put id on each row and from code behid you can change the column text as well as hide it from user.
+1
Vertika Chauhan6y ago
Select * from table_name where email_column=@emailid @emailid= is id which user will enter
0
Mo Khan6y ago
Thanks, I kind of getting a grasp of what needs to be done. How would I structure my query based on email? for example, I want to search user email in the database and get their license type and zoom status and then show the label which needs to display.
0
Mo Khan6y ago
I have six tables and each table will show (Tick Mark or Cross) for "Enabled" based on user license type and there are text which will change based on license type as well.

For example: if Person A have E5 license type, then "Enabled" row will have all three tick marks and the last row will say select tool and each cell will have a hyperlink for their respective tool. However, if Person B have F1 license, then "Enabled" row will have cross all three cell and last row will change the text to "Host Only Option" and one cell will add a checkbox. I have six different scenarios and each scenario have their table with information.

My database table have, Name, Email, LicenseType and Status. On my page, I am asking user for their email id through text box and parsing it on my SQL query.
0
Vertika Chauhan6y ago
Hi Can you tell me what is your requirement i mean what you want to display and what your database contain so that i can help you with other solutions as well
0
Mo Khan6y ago
This is my first time creating asp.net page, can you help me how to get started? Will I need multiple sql query for each license type or will I do an If statement?
0
Vertika Chauhan6y ago
Put id on each tr and on code behind access with following code HtmlTable td = (HtmlTable)tblAssigned.FindControl("companyInfo"); And hide or label as based on your database query.
0