Gridview Duplicate removal.

Yuan,
You could put the keyword "distinct" after your select and before
your columns in your SQL statement. This will remove all the duplicated
rows.

Bill Gregg


*** Sent via Developersdex http://www.developersdex.com ***

Bill Gregg

Can you show an example of that Bill?

J

"Bill Gregg" <> wrote in message
news:...
>
> Yuan,
> You could put the keyword "distinct" after your select and before
> your columns in your SQL statement. This will remove all the duplicated
> rows.
>
> Bill Gregg
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Hi J,

Thanks for your reply!

First of all, thanks for Bill's reminder. Since I don't use the SQL Server
with a long time, I forget there is the "distinct" keyword is more
appropriate at the current stage. For example, there is a table likes below:
num name
1 a
1 a
2 a
2 b
2 b

So, if you use the statement below:
select distinct * from tblduplicated

You will get the result:
1 a
2 a
2 b

Thanks for your understanding!

Regards,

Yuan Ren [MSFT]
Microsoft Online Support

Yuan Ren[MSFT]