Use Case Statement with Select Query in SQL Server | Case Statement Example in SQL Server

Introduction:

In this article I will explain how to write SQL  query to use case statement with select in SQL Server or case statement example in SQL Server.

Description:

In previous posts I explained Distinct keyword with top statement, Replace function, substring function to get particular part of string and many articles relating to SQL Server. Now I will explain how to write query to use case statement in SQL Server.

Generally case statement is conditional statement that will return column value based on the evaluation of set conditions. We can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING.

Jquery autocomplete textbox with multiple words separated by comma or semicolon in asp.net

Introduction:

In this article I will explain how to implement JQuery UI autocomplete textbox with multiple words or values with comma separated or semi colon separated in asp.net.

Description:

In previous articles I explained JQuery autocomplete textbox with asp.net and JQuery autocomplete textbox with images in asp.net and many articles relating to JQuery. Now I will explain how to implement autocomplete textbox with multiple word selection in asp.net.

SQL Server - Query to use Distinct Keyword with Top Statement in SQL Server

Introduction:

In this article I will explain how to write SQL query to use distinct keyword with Top statement in SQL Server.

Description:

In previous posts I explained Replace function, substring function to get particular part of string and many articles relating to SQL Server. Now I will explain how to use distinct keyword with top statement in sql server.

Generally by using Distinct keyword we can get distinct records from datatable that declaration will be like this

SQL Server - Query to Get Last Inserted Record Id

Introduction:

In this article I will explain how to write query to get last inserted record id in sql server or last modified record id value in SQL Server.

Description:

In previous post I explained how to set identity property or auto increment column in data table and many articles relating to SQL Server. Now I will explain how to write a query to get last inserted record id value or last modifies record id in SQL Server. Generally if we create data table we will set identity column or auto increment column in table to increase column id value automatically whenever new record inserted in SQL Server. In one situation I got requirement like to get last inserted record Id from data table in SQL Server.

JQuery html or asp button click event in asp.net

Introduction

In this article I will explain how to use html button click event or asp button click events in asp.net using JQuery.

Description:

In previous article I explained how to show session timeout message before session expires in JQuery. In one situation I got requirement like implement some functionality in html button click event for that I used JQuery button click events. Here I will explain how to implement button click functionality in JQuery for html and asp button controls for that first open visual studio create new application and design your aspx page like this 

JQuery Show Session Timeout message before session expires in asp.net

Introduction: 

In this article I will explain how to show session timeout message before session expires or redirect to login page when user inactive on website using JQuery in asp.net.

Description:
  
In previous article I explained show alert message when user idle or inactive on website using JQuery. I am using that concept here to show session timeout message before session expires when user idle or inactive on website using JQuery in asp.net.

Generally in banking sites if we stay idle for sometime automatically we will get alert like your session is going to expire and it will show options like do you want to continue or Signout. Whenever we click on continue our session will active in that site without any session expire if we click on Sign Out option it will signout from that site and return to home page. We can implement this functionality easily by using available JQuery plug-in.

JQuery show alert when user idle on website for sometime in asp.net

Introduction: 

In this article I will explain how to show alter message when user idle or inactive for sometime on website in asp.net using JQuery.

Description:
  
In previous articles I explained many articles on JQuery. Now I will explain how to show alert message when user idle for sometime on website in asp.net using JQuery.

Generally in banking sites if we stay ideal for sometime automatically we will get alert like your idle for this much time on site and your session is going to expire within 5 minutes or something else we can implement this functionality easily by using available JQuery plug-in. For that first create new website write the following code in your aspx page 

How to access asp.net content page controls from master page

Introduction: 

In this article I will explain how to access or get content or child page controls from master page in asp.net.

Description:

In previous post I explained how to access master page controls from content page in asp.net. Now I will explain how to access content page controls from master page in asp.net.

How to access asp.net master page controls from content page

Introduction: 

In this article I will explain how to access or get master page controls from child or content page in asp.net

Description:

In previous posts I explained many articles relating to asp.net, gridview, SQL Server, JQuery, JavaScript and etc. Now I will explain how to access master page controls from child page or content page in asp.net.

update delete statement with inner join in sql server

Introduction:

In this article I will explain how to use delete or update statement with inner join in SQL Server.

Description:

In previous post I explained how to use update statement with replace function in SQL Server and many articles relating to SQL Server. Now I will explain how to use delete or update statement with inner join in SQL Server.  In one application I got requirement like delete data from database based on multiple table column values in SQL Server. Generally we will use joins concept to get data from multiple tables and if we want to delete data based on the column values of multiple tables we will use subqueries instead of use multiple subqueries we can reduce it by using inner join with delete statement.