如何避免datagridview中的重复列 [英] How to avoid duplicate column in datagridview

问题描述

Microsoft OneDrive - 随处访问文件。使用免费的Office Online创建文档。 [ ^ ]



以上是我的datagrid ..在TickectName中，Group正在重复...只是想一次显示两个并且对于其他行保持空白.. plz帮助我..



我尝试了什么： < br $> b $ b

https://onedrive.live.com/redir?resid=53870F6D1012733F!274&authkey=!AMYliRKNBs0uLdg&v=3&ithint=photo%2cpng



以上是我的datagrid ..在TickectName中，Group正在重复..我只想一次显示两个并且对其他行保持空白.. plz帮帮我..

Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.[^]

above is my datagrid.. in that TickectName,Group is repeating..i just want to display both at one time and remains blank for other rows.. plz help me..

What I have tried:

https://onedrive.live.com/redir?resid=53870F6D1012733F!274&authkey=!AMYliRKNBs0uLdg&v=3&ithint=photo%2cpng

above is my datagrid.. in that TickectName,Group is repeating..i just want to display both at one time and remains blank for other rows.. plz help me..

推荐答案

<pre lang="SQL">
SELECT        tb_Ticket.TicketName, tb_Ticket.TicketGroup, tb_PrizeNumbers.PrizePosition,
                             (SELECT        PrizeAmount
                               FROM            tb_PrizeDetails
                               WHERE        (TID = tb_PrizeNumbers.TID) AND (tb_PrizeNumbers.PrizePosition = PrizePosition)) AS Amount, tb_WinningTable.WinningDate, 
                         tb_PrizeNumbers.PrizeNo
FROM            tb_PrizeNumbers CROSS JOIN
                         tb_Ticket INNER JOIN
                         tb_WinningTable ON tb_Ticket.TicketID = tb_WinningTable.TicketID

sql查询我用过..有六个奖项位置的票证..我想只显示一次票号名称..

sql query i used.. there are six prize position for a ticketname..i want to display ticket name only once..

这篇关于如何避免datagridview中的重复列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！