select Nth salary from employee table using sql query with top query

SELECT MAX(EmpSalary) as 'EmpSalary' from tblEmployeeDetails

where Salary NOT IN

(

SELECT TOP n-1 (EmpSalary) from tblEmployeeDetails ORDER BY EmpSalary Desc

) 

// 2nd

SELECT MAX(EmpSalary) as 'EmpSalary' from tblEmployeeDetails

where Salary NOT IN

(

SELECT TOP 1 (EmpSalary) from tblEmployeeDetails ORDER BY EmpSalary Desc

) 

Result-14000

// 3nd

SELECT MAX(EmpSalary) as 'EmpSalary' from tblEmployeeDetails

where Salary NOT IN

(

SELECT TOP 2 (EmpSalary) from tblEmployeeDetails ORDER BY EmpSalary Desc

)

 Result-13000

Get Controls type inside Gridview in asp.net code behind

//HTML

<asp:GridView ID="GridView1" runat="server" ></asp:GridView>

//C#

foreach (Control clt in GridView1.Rows[0].Controls)

                {

                    foreach (Control clt1 in clt.Controls)

                    {

                        if (clt1 is TextBox)

                        {

                            ((TextBox)clt1).BackColor = validateColor;

                        }

                        else if (clt1 is DropDownList)

                        {

                            ((DropDownList)clt1).BackColor = validateColor;

                        }

                    }

                }