Query to Find Nth Highest Salary of Employee In Sql Server | Query to Find 2nd or 3rd highest salary of employee in SQL Server

Introduction:

In this article I will explain how to find nth highest salary of the employee in SQL Server.

Description:

In many sites we will find one frequent question that is like how to find 2^nd highest salary of employee or how to find 3^rd highest salary of employee or how to find nth highest salary of employee in SQL Server. To get required highest salary we are having different alternative ways.

Joins in sql server, Inner Join,Cross Join,Left Outer Join,Equi join, Right Outer Join, Full Outer Join

Introduction:

In this post I will explain what are the Joins in SQL Server and different types of Joins example (SQL LEFT outer Join, SQL RIGHT outer Join, SQL FULL outer Join, SQL Cross Join, SQL inner Join sample, Self Join example) and uses of Joins in SQL Server.

Description:

In SQL joins are used to get data from two or more tables based on relationship between some of the columns in tables. In most of the cases we will use primary key of first table and foreign key of secondary table to get data from tables by using this relationship we can reduce the duplication of data in every table.

Simple login form example in asp.net Check Username and Password availability in database

Introduction: 

In this post I will explain how to implement simple login form using asp.net and I will explain how to Check Username and Password Exists in database using asp.net .

Description: 

One day I got mail from one of the reader he has asked about how to implement simple login form to check username and password details of user in database. If user details exist in database then we need to redirect user to welcome page otherwise we need to display “Invalid Username/Password”. Mostly it’s common for all the websites before access the website. I know that many of them feel it’s very easy but for the people who have started learning .NET they don’t know how to implement this because of that I decided to write post to help for the persons who is in need with this requirement. 

A potentially dangerous Request.Form value was detected from the client in asp.net

Introduction:

In this post I will explain how to solve the problem “A potentially dangerous Request.Form value was detected from the client in ASP.NET WebForms” using asp.net.

Description: 

In previous post I explained clearly about Rich textbox sample in asp.net . After completion code if I try to insert some html formatted data in database using rich textbox I got error like “A potentially dangerous Request.Form value was detected from the client in ASP.NET WebForms”

Search Records In GridView And Highlight Results Using ASP.NET | how to highlight search results in gridview using asp.net

Introduction:

In this article I will explain how to search records in gridview and highlight search keywords in gridview using asp.net.

Description:

In Previous post I explained clearly about how to filter gridview records with dropdownlist selection. Now I will explain how to implement search functionality for gridview and highlight search keywords in gridview using asp.net. 

SQL Server Error - Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Introduction

Here I will explain how to enable prevent saving changes in sql server or to solve the problem of “Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created.etc” in SQL Server.

Description

I have installed SQL Server 2008 in my laptop after successfully installed I opened SQL Server Management studio and created new table like this 

how to set default home page in IE and Mozilla using JavaScript in asp.net

Introduction

Here I will explain how to set default home page in browser using JavaScript in asp.net.

Description

In many major websites we will see link like “Set as a home page” if we click on that home page link that will automatically change our browser default home page url to their particular page url. In IE browser we can easily set home page just by simple code but Mozilla we don’t have a chance to set home directly because of security concerns. If we want to set the home page in Mozilla first we need to set signed.applets.codebase_principal_support to true then run the below code to set home page initially that is in false mode. 

Add Bookmark link to website using javascript | Add to Favorites (IE) / Bookmark (Firefox) using Javascript

Introduction

Here I will explain how to add bookmark link to our website using JavaScript in asp.net.

Description

In many websites we will see link like “Bookmark this Site” if we click on that bookmark link that will prompts the user with dialog box to add that specified link in favorites list. If we want to add that type functionality to our website we can write in different ways. Here I will explain in two different ways to add Bookmark functionality

Disable browser back button functionality using JavaScript in asp.net | ASP.Net disable browser back button (using javascript)

Introduction

Here I will explain how to disable browser back button functionality using JavaScript in asp.net.

Description

One day I got requirement like disable browser back button to prevent users going back to previous page using back button of the browser. I search many sites for proper code to prevent users navigating back to previous page but there is no use because some of them work in IE but not in Mozilla and some of them will work in Mozilla but not in IE.

Read or Write connection strings in web.config file using asp.net

Introduction:

In this article I will explain how to read or write connection strings in web.config file using asp.net.

Description:

In Previous article I explained clearly about Encrypt or Decrypt connection strings in web.config file using asp.net. Now I will explain how to write connection strings in web.config file and how to read connection strings from web.config file using asp.net.