sql

Question

we have a table Holiday .

Id	bigint
holidayType	varchar(100)
status	bit

Id	holidayType	status
1	Honeymoon	1
2	Honeymoon	1
3	Honeymoon	1
4	holidayType	1

& i want to display the records in my page aspx  this format ....

holidayType(2)
Honeymoon(3)

Plz immideately i have an urgent


Thursday, May 02, 2013