Last post Dec 28, 2017 02:06 AM by Cathy Zou
Dec 27, 2017 04:11 PM|Euthaf|LINK
I got two gridviews, but I want my application to create many gridviews depending on the products name. I use two different tables from my database.
it's currently showing
All products list 1
All products list 2
I want my app to show something a little more like this(please forgive me for this paint edit)
Product A List 1
Product A List 2
Product B List 1
Product B List 2
Product C List 1
Product C List 2
Sorry for my English, my first language is French.
I want it to look something like this. I currently use two different sql request for both of my tables.
current code for the first table
FROM [AC].[dbo].[Suivi_AC] as suivi
left join [ac].dbo.[Tache] as tache
on suivi.[No_ Tache] = tache.No_
where [No_ AC] = @No_AC
Current code for the 2nd table
SELECT [No_ AC]
WHERE [Action] NOT LIKE '' AND ([No_ AC] = @No_AC);
Dec 28, 2017 02:06 AM|Cathy Zou|LINK
From your description, Your problem is unclear for me
I didn’t get the relationship between the following picture, so it is hard for me to got the idea about how to get the result what you want.
Would you please provided us with more explanation about this.
You could explain us with simple table structure and row data.