reference

http://www.dotnet-tricks.com/Tutorial/mvc/D8I4270712-MVC-Data-Annotations-for-Model-Validation.html

(@"^(([A-za-z]+[\s]{1}[A-ZA-Z]+))$",Errmsg

Create procedure procedurename
as
@gender nvarchar(20),
@EmployeeCount int Output,
begin
Select @EmployeeCount = Count(id) from tableEmployee Where Gender = @gender
End

Create Procedure Procedurename
@gender nvarchar
@Employe Int Output
as
begin
select @EmployeeCount = Count(id) from tableEmployee Where Gender = @gender
End
Declare @TotalCount int

Execute SpGetEmployee


http://bootsnipp.com/snippets/featured/panel-tables-with-filter

http://bootsnipp.com/snippets/featured/multi-level-dropdown-menu-bs3


begin
select @EmployeeCount = Count(id) from tableEmployee Where Gender = @gender
End
Declare @TotalCount int

Execute SpGetEmployee