Suppose I have 3 tables. But I want to show them it in same gridview and want to update and delete operations in parallel. How can I do that?
table 1: workshop
id contents demonstration coursefee proviedMaterial 1 oneday NULL 400 NULL 2 twoday NULL 1200 NULL
table 2: demonstration
id DayWorkshop demonstration 1 oneday SQLInjection 2 oneday XSS Demo 3 oneday HTTrack 4 twoday Tools demo 5 twoday Firewall 6 twoday Cryptography
table 3: providedMaterial
id DayWorkshop providedMaterial 1 oneday Participation Certificate. 2 oneday List of Our Latest short or long term courses . 3 twoday Participation Certificate. 4 twoday List of Our Latest short or long term courses Conducted.
Reason I took 3 table because I want to update all contents. Also, can I combine these 3 table into a single table so that I can easily show it in a gridview?