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 ...
Loading
Kirtan PatelPosted Dec 13, 2009, 6:15 AM
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 month"because 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 PatelPosted Dec 13, 2009, 8:48 AM
See Below Screen Shot and Check your Mail for Solution !!
sonal saxenaPosted Dec 13, 2009, 7:54 AM
thanks for help !
Hiren SoniPosted Dec 13, 2009, 6:52 AM
sonal saxenaPosted Dec 13, 2009, 6:48 AM
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 SoniPosted Dec 13, 2009, 6:29 AM
Kirtan PatelPosted Dec 13, 2009, 6:24 AM
sonal saxenaPosted Dec 13, 2009, 6:22 AM
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 saxenaPosted Dec 13, 2009, 6:16 AM
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 SoniPosted Dec 13, 2009, 6:05 AM
Moni PatelPosted Dec 13, 2009, 5:59 AM