Get Third Highest Salary Sql Query

Get Third Highest Salary 


SELECT TOP (1) * FROM
   (SELECT TOP (3) Empsalary FROM employeeMaster ORDER BY empsalary DESC) T
ORDER BY empsalary ASC

json

  public class address
    {
        public string address1, address2,city,state,country;
        public int pin;
   
    }

    public class person
    {
        public string firstname, lastname, department;

        public address adr = new address();

        public string[] technologies;
    }



 public void serialize_json()
    {
 
        person p1 = new person();
        p1.firstname = "Sapna";
        p1.lastname = "Giyanwani";
        p1.department = "Asp.net";
        p1.adr.address1 = "Saijpur Bogha";
        p1.adr.address2 = "Naroda Road";
        p1.adr.city = "Ahmedabad";
        p1.adr.state = "Gujarat";
        p1.adr.country = "India";
        p1.adr.pin=382345;
        p1.technologies = new string[] {"C","C++" ,"ASp.net" };

        str = js.Serialize(p1);
     

    }

    public void deserialize_json()
    {
        person p2 = js.Deserialize<person>(str);

        Response.Write(p2.firstname);
    }

How to create EXE in Visual Studio

1. Open Visual Studio.
2. Open your Project.
3. From Solution Explorer right-click Solution (project)--> Add -->New Project ...

4. Select Other Project Types --> Setup and Deployment --> Visual Studio Installer --> Select Setup Wizard. Write a name and click OK.

5. Click Next.

6. Select Create a setup for windows application.

7. Click Next.

8. Select Primary Output from Project.

9. Click Next.

10. Click Add and select your app config file.

11. Click Open.

12. Click Next and then Finish.

13. Click Finish.

14. Click the Application folder at the left side.

15. Right Click Application Folder and add Project Icon that you want to set.

16. Select Icon.

18. Now Right Click Primary Output and Click Create a shortcut to Primary Output from Project.

19. Give a name to exe. and from shortcut property set Icon.

20. Now Drag and Drop Exe to User's Desktop.

21. Now-Again Create shortcut and Drag and Drop it to User's Program Menu.

22. Now From Solution Explorer -- > Select Project and From--> View -- >Select Properties Window.

23. Set Publisher name and company name. 

24. Now Right Click Setup from Solution Explorer. And click Build.

25. In Project Folder you will find EXE in the Release folder.

26. Install Exe and check.

Passing QueryString in Asp.net

1. Open Visual Studio
2. Create a New Website
3. Add web page

4. from Website - >Add New Item -> WebPage- > Click Add.

5. Add Button Control.

6. Write code in button click event as below

   protected void Button1_Click(object sender, EventArgs e)

    {

        Response.Redirect("DashBoard.aspx?username=sapna&password=123456");

    }

7. Add New Page named DashBoard.aspx

8. Add Two label controls in DashBoard.aspx.

9. Write code inside Page_Load Event as below.

 protected void Page_Load(object sender, EventArgs e)

    {

        if (Request.QueryString["username"] != null && Request.QueryString["password"]!=null)

        {

            lblusername.Text = Request.QueryString["username"].ToString();

            lblpassword.Text = Request.QueryString["password"].ToString();

        }

    }

10. Run Code you will get querystring values in two labels.