Winner table

Question

I have a table contains two fields name and points.
i want to show top 10 members in asp.net form with
Name
Points
based on their points like c-sharpcorner winners
and their should be three links

Current month winner | Previous month winners | Top Most

same like c-sharpcorner which control should i use to show gridview of table

waiting for fast reply ...

Kirtan Patel · Answer

Hi Sonal  c-sharpcorner.com winners page uses DataList Control. to show winners . set RepeatColumn = 2 in data List then you will get Exact look like c-sharpcorner's winner page. just you have to modify its template and bind it to database.after using datalist control you need to just fire SQL where query to show users month by monthbecause if you use gridview you can not display like you seen in c-sharpcorner.com winners page . if my answer helps you then check do you like this answer check box :)

Kirtan Patel · Answer

Congrats !! your problem Solved !! See Below Screen Shot and Check your Mail for Solution !!

sonal saxena · Answer

Kirtan i have completed that task almost and i have check your answer okay as you said... thanks for help !

Hiren Soni · Answer

Why insert queries

sonal saxena · Answer

insert into login values ('jatin'15) insert into login values ('Sonal'25) insert into login values ('amit'65) insert into login values ('john'85) insert into login values ('krish'45) insert into login values ('rock'65) insert into login values ('ben'95) insert into login values ('mike'75)

Hiren Soni · Answer

Select TOP (10) name points from winners Order by points Desc

Kirtan Patel · Answer

ok i m on gtalk kirtan007@gmail.com

sonal saxena · Answer

Kirtan as you say use DataList i am using but this control only showing one value which is having highest points while my query is SELECT TOP 5 * FROM login ORDER BY points DESC i want to show top 10 with this month points : total points : KIRTAN CAN YOU TALK ME ON GTALK PLEASE i am sending you a request...

sonal saxena · Answer

Yes soni if you can ... i want to create like c-sharpcorner winners list (same) functionality... Previous month winner | Current month winners | top most what i have to do .... help

Hiren Soni · Answer

Do you required code 4 that?

Moni Patel · Answer

Ya you can use gridview to show top 10 member to dislpay. It is the simplest way to do your task...