Asp.net confirmation box with yes/no button options using modalpopup

Introduction: 

Here I will explain how to implement confirmation box with Yes/No button options and change the style of Confirmation box in asp.net using Ajax ModalPopupExtender.

Description:

In many situations we will use confirmation box ex: During delete one record we will ask confirmation of user like “Are you sure you want to delete record?” if user clicks on Ok button we will delete particular record otherwise if clicks on Cancel button then we won’t delete users. Initially our default confirmation box will be like this

Bind or add tooltip for dropdownlist items in asp.net | Handle Long text problem in dropdownlist using asp.net

Introduction:

In this article I will explain how to add tooltip for dropdownlist item in asp.net.

Description:
  
In Previous article I explained clearly how to bind images to dropdownlist. Now I will explain how to add tooltips for dropdownlist item in asp.net. In many situations we will use dropdownlists in our application if it contain less length of data then it will display the data correctly otherwise if it contains more length of data then user will not be able to see entire data that would be like this 

JQuery change the style of tooltip in asp.net | Gridview header and columns tooltip in asp.net

Introduction:

In this article I will explain how to change the style of tooltips in asp.net using JQuery.

Description:

In my previous posts I explained clearly how to show the tooltip for girdiview rows and columns and show tooltip for gridview header here I am using these posts to bind gridview with tooltips. In our websites we will apply tooltips for many controls whenever we apply tooltips for controls initially that would be like this

JQuery Bind images to dropdownlist in asp.net

Introduction:

In this article I will explain how to bind images to dropdownlist in asp.net using JQuery.

Description:
  
In previous articles I explained about how to implement cascading dropdownlist  and Ajax Cascading dropdownlist. Now I will explain how to bind dropdownlist with images dynamically in asp.net using JQuery. In one of website I saw one dropdownlist that contains Country names along with country flags. I feel it’s better to write post to explain how to bind images to dropdownlist in asp.net. To implement this concept by using JQuery plugin we can achieve this easily.  

JQuery lightbox image slideshow gallery in asp.net

Introduction:

In this article I will explain how to create lightbox image slideshow in asp.net using JQuery.

Description:
  
In previous post I explained about Ajax SlideshowExtender sample to display images slideshow. Now in this article I will explain how to create lightbox image slideshow in asp.net using JQuery. In many websites generally we will see different types of slideshows like whenever we click on image that is automatically open with lightbox effect and we have a chance to see all the remaining images by press next or previous options in slideshow. All these Slideshows are implemented by using JQuery plugins. After seen those slideshows I decided to write post to use JQuery plugins to implement beautiful slideshown in asp.net. 

Failed to access IIS metabase in ASP.NET

Introduction: 

Here I will explain how to solve the problem “Failed to access IIS metabase ASP.NET” when we try to browse website using asp.net

Description:

In my machine I tried to access one of the website from IIS at that time I got error like “Failed to access IIS metabase ASP.NET”. I realized that problem because of process model user account (in our case, ASPNET) does not have the correct user rights for the required system files and folders to run the ASP.NET worker process and apparently there is a bug in the ASP.NET install.

Method error 500/12031 in ajax cascadingdropdown extender | AJAX CascadingDropDown - Method Error 500

Introduction: 

Here I will explain how to solve the problem “Method error 500/12031 in ajax cascadingdropdown extender” using asp.net. 

Description:

In previous post I explained clearly about Ajax cascading dropdownlist sample. Generally during implementation of cascading dropdonlist we will see our dropdowns shows error like “Method error 500 or Method Error 12031”. This error is occurred because of missing following line of code in WebService.

Export selected rows of gridview to Excel or word in ASP.Net

Introduction:

Here I will explain how to export only selected or checked rows or records from gridview to Word or Excel sheet using asp.net.

Description:

In my previous posts I explained clearly how to export gridview data to Excel or word using asp.net and how to export gridview data to PDF using asp.net and explained another post that is Export gridview data to CSV file using asp.net. After explain all the concepts one of the user has asked me a question i.e. how to export gridview records to excel/word based on checkbox selection in gridview. To implement this one first design one table in database as shown below and give name as “UserInformation” 

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.