从Gridview中删除重复行 [英] Remove Duplicate Rows from Gridview
问题描述
大家好,
我的sql表有一些重复的项目如下:
id- - item_id - user_name - basket
1 1 - John - Empty
2 1 - John - order_1
3 2 - Mike - order_2
4 2 - Mike - order_3
5 2 - Mike - order_4
6 3 - Daniel - order_5
7 4 - Simon - order_6
8 4 - Simon - order_7
9 5 - Jane - order_8
当我从sql到gridview获取此数据时,想要删除项目ID中的dublicate项目
我的gridview应该是这样的:
id-- item_id - user_name
1 1 - John
3 2 - Mike
6 3 - Daniel
7 4 - 西莫n
9 5 - 简
我该怎么做?
我看过这篇文章:
[ ^ ]
但在这篇帖子中gridview有一些空单元格,我不知道想要看到任何空单元格。
谢谢。
Hello everyone ,
My sql table has some duplicate item like this :
id-- item_id -- user_name -- basket
1 1 - John - Empty
2 1 - John - order_1
3 2 - Mike - order_2
4 2 - Mike - order_3
5 2 - Mike - order_4
6 3 - Daniel - order_5
7 4 - Simon - order_6
8 4 - Simon - order_7
9 5 - Jane - order_8
when i take this data from sql to gridview , want to delete dublicate items in item id
my gridview should be like this :
id-- item_id -- user_name
1 1 - John
3 2 - Mike
6 3 - Daniel
7 4 - Simon
9 5 - Jane
How can i do this ?
I saw this post :
[^]
But in this post gridview has some empty cells , i don't want to see any empty cells.
Thank you.
推荐答案
这不是gridview问题但是一个SQL问题。您的加入不正确或数据不正确。您需要在SQL中修复它。
This is not a gridview problem but a sql problem. Either your join is not correct or you have bad data. You'll want to fix it in SQL.
这篇关于从Gridview中删除重复行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!