Sajid Hussain

Sajid Hussain

  • 1.1k
  • 509
  • 94.3k

count NO of values from a column base on same value of anoth

Nov 24 2014 3:25 AM
i have a table in which i have two columns like
 
EmployeeStatusType     Sector_Id
1                                          1

1                                          1

2                                           1

3                                            1

2                                            1

1 is for absent

2 is for Leave

3 for MEdical

i have a dropdown list of sector in the form ,i want that when user click on any dropdown list each an event is fire that return no of absent leave,medical in to the textbox of the form.

txt.absent.text = sectorAbsent.TOSTRING();

 

Answers (1)