Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

View data from another table in listview on ASP.NET web application

Home
Forums
Learn iOS Programming

View data from another table in listview on ASP.NET web application

Doda Ayman

6yAsked Jun 25, 2020, 10:43 AM704Learn iOS Programming

I need to show the Damagename (which is in another table) instead of the Damage ID on my listview, I did it correctly in (edit and Inset) but I need it also in the display..

I have 2 tables :

DamagesTypes:

DamTypeID

DamName

DamDescription

Damages

TicketNumber

SchoolID

DamTypeID (foreign key)

DateOfDam

MachineID

Action

Here is my aspx markup attached

Please help me. I had 3 days searching for solution ... thanks in advance

2 Replies

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Naruto Reddy6y ago
Since you have a foreign key relationship, you can use join the following way.

SELECT dt.DamName, dt.DamDescription,dmg.*
FROM Damages dmg JOIN DamagesTypes dt On dmg .DamTypeID = dt.DamtypeID;
Laxmidhar Sahoo6y ago
hi
Your design not opening due to the absent of the master page.
Bellow is the query

select t.DamName,t.DamDescription,d.TicketNumber,d.DateOfDam,d.MachineID
from Damages d inner join DamagesTypes t on d.DamTypeID = t.DamtypeID
Thanks and Regards
Laxmidhar sahoo