Articles by Sandeep Singh Shekhawat

This article explains how to populate a child dropdown list depending on each new value as values are seelcted in the parent's dropdown list.

In this article I am going to explain the Take and Skip operators in LINQ to SQL. The Take operator is used to return a given number of rows from a database table and the Skip operator skips over a specifed number of rows in a database table.

Learn how to use SUM, Average, Count, Max, and Min aggregate functions in LINQ to SQL and SQL Server, including grouped employee salary queries.

In this article, I am explaining how to get the last inserted identity value of an auto-increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT()). Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value that is produced in a single session; in other words, a connection while IDENT_CURRENT() returns the last identity value according to the table for any session.

In this article I am going to explain how to insert multiple rows using a user defined table type.

Learn how to implement custom paging in an ASP.NET GridView using a stored procedure, PageIndex, PageSize, and a Repeater-based pager to reduce unnecessary data retrieval.

In this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.

In this article I explain most of the SQL Server functions for manipulating text.

In this article I am going to explain simple Select, Insert, Update and Delete operation using to LINQ to SQL.

In this article I am going to explain Inner join, Cross join and Left Join with LINQ to SQL.

JSON (JavaScript Object Notation) is an open and text-based data exchange format means it is a text format for the serialization of structured data. It is derived from object literals of javascript.

The purpose of a user control is to provide the ability to reuse common user interface functionality across our web applications.

The SqlCommand Class is used for T-SQL, SQL statements and stored procedures to execute against a SQL Server database. This class cannot be inherited because it is a sealed class.

Here we are developing a web application that is used for getting a conversion rate for converting from one currency to another currency. For developing this application we need a web service to find the current conversion rate of currencies.

Here I show steps to create console application using a text editor and compiling from a command window.