How to Convert Rows to Columns in SQL Server Without Using Pivot

Introduction:

Here I will explain how to convert row values to column values without using pivot in SQL Server.

Description:

In previous articles I explained Query to get duplicate records count, Query to remove duplicate records and many articles relating to SQL Server. Now I will explain how to write a query to convert row values to column values without pivot in SQL Server. In database I have one table UserInformation that contain data like as shown below

Lost My PAN Card How to Apply For New One | Change Details in PAN Card

Introduction:

In this article I will explain how to apply for new pan card if pan card lost and how to make changes or corrections in pan card.

Description:

In previous articles I explained some of internettips like Setup DNS Server, Create desktop shortcut key to lock computer/laptop etc. Now I will explain how to change details in your pan card and how to apply for new pan card if old one lost.

Generally many of them will face problem like lost pan card or getting pan card with wrong details etc. After seen all these problems I realized that it’s better to write article to show how to get new pan card if existing one lost or how to make changes in pan card if any wrong details printed on card.

jQuery Highlight Gridview Row When CheckBox is Checked in Asp.Net

Introduction:

In this article I will explain how to highlight gridview rows when checkbox is checked or selected in asp.net using JQuery.

Description:

In previous article I explained select/deselect checkboxes in gridview using JQuery, select header checkbox when all child checkboxes selected in JQuery and many articles relating to JQuery. Here I am using select header checkbox when all child checkboxes selected in JQuery concept to highlight gridview row when checkbox is checked in JQuery.

If we want to highlight checkbox selected gridview rows using JQuery we need to write the code like this

Validate DropdownList Using JQuery in Asp.Net

Introduction: 

Here I will explain how to validate dropdownlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate checkboxlist in JQuery, validate radiobuttonlist using JQuery, validate email address using JQuery and many articles relating to JQuery. Now I will explain how to validate dropdownlist using JQuery in asp.net.

jQuery Validate CheckBoxList in Asp.Net Example

Introduction: 

Here I will explain how to validate checkboxlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate radiobuttonlist using JQuery, validate email address using JQuery, how to disable or enable all the controls on page using JQuery , validate phone number using JQuery and many articles relating to JQuery. Now I will explain how to validate checkboxlist using JQuery in asp.net.

JQuery Validate RadioButtonList in Asp.Net Example

Introduction: 

Here I will explain how to validate radiobuttonlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate email address using JQuery, how to disable or enable all the controls on page using JQuery , validate phone number using JQuery and many articles relating to JQuery. Now I will explain how to validate radiobuttonlist using JQuery in asp.net.

JQuery Select Header Checkbox When All Child Checkboxes Selected in Asp.net Gridview

Introduction:

In this article I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox using JQuery in asp.net.

Description:

In previous article I explained select/deselect checkboxes in gridview using JQuery and how to select/deselect checkboxes in gridview using JavaScript and many articles relating to JavaScript and JQuery. Now I will explain how to select/deselect header checkbox when all child checkboxes selected in gridvuew using JQuery.

Check Uncheck All Checkboxes in Gridview Using JQuery

Introduction:

In this article I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox using JQuery in asp.net.

Description:

In previous article I explained how to select/deselect checkboxes in gridview using JavaScript and many articles relating to JavaScript. Now I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox in JQuery.

SQL String or Binary Data Would be Truncated. The Statement has been Terminated

Introduction: 

Here I will explain how to solve the problem of “string or binary data would be truncated. The statement has been terminated.” in sql server. 

Description:

One day I am trying to insert data into one table using SQL queries at that time I got error like “String or binary data would be truncated. The statement has been terminated.” Actually this problem because of I declared column datatype varchar(25) but I am inserting data more than 25 characters in that column. To solve this problem I modified column datatype varcha (25) to varchar(50)

Best jquery password strength plugin Examples to show password strength

Introduction: 

Here I will explain different type of JQuery password strength meter or indicator plugins.

Description:
  
In previous posts I explained Show password strength meter using AJAX in asp.net and Show password strength using JQuery Plugin in asp.net and many articles relating to JQuery. Now I will explain different type of available JQuery password strength indicator plugins.

jQuery plugin: Password Validation

This plugin extends the jQuery validation plugin, providing two components:

     1)  A function that rates passwords for factors like mixed upper/lower case, mix of characters (digits, special characters), length and similarity to a username (optional).

How to Add Fade In Effect to Webpage using JQuery in asp.net

Introduction: 

Here I will explain how to load webpage content with fade in effect using jquery in asp.net.

Description:
  
In previous post I explained hide or show div content elements using JQuery and many articles relating to JQuery. Now I will explain how to add fade in effect to webpage using Jquery in asp.net.

If we want to implement fade in effect to webpage in jquery we need to write the code like as shown below

<script type="text/javascript"> $(document).ready(function() { $('#fadediv').fadeIn(2000); }); </script>

In above script fadediv is the id of the div which is used to load the inside of div content with fadein effect. If you want sample check below code

JQuery - How to Set Get Textbox Value using jQuery

Introduction: 

Here I will explain how to get textbox value using jquery or how to set textbox value in jquery.

Description:
  
In previous post I explained split the string using split function in jquery and many articles relating to JQuery. Now I will explain how to get or set textbox value in JQuery.

If we want to get textbox value in jquery or if we need to set value in textbox using jquery we need to write the code like as shown below

// Get textbox value $('#txtName').val() // Set textbox value $('#txtName').val("your message")

If you want check this code in sample check below code

Use Split Function in JQuery to Split the String in Asp.net

Introduction: 

Here I will explain how to split the string using split function in JQuery with asp.net.

Description:
  
In previous posts I explained many articles relating to JQuery. Now I will explain how to split the string using split function in JQuery.

To split the string we have function called Split() in JQuery by using that we can split string based on our specific character that would like as shown below

Asp.net Get Dropdown Selected value and text in JavaScript

Introduction: 

Here I will explain how to get dropdownlist selected value or selected item text using JavaScript in asp.net.

Description:
  
In previous article I explained Fire Dropdownlist selectedindexchanged event  and many articles relating to JavaScript. Now I will explain how to get dropdownlist selected value using JavaScript in asp.net.

Asp.net Dropdownlist Selectedindexchanged Event in JavaScript

Introduction: 

Here I will explain how to raise dropdownlist selectedindexchanged event in JavaScript using asp.net.

Description:
  
In previous articles I explained How to bind dropdownlist using JQuery and how to get dropdownlist selected value and text using JQuery and many articles relating to JQuery. Now I will explain how to raise dropdownlist selectedindexchanged event in JavaScript using asp.net.

Asp.net Dropdownlist SelectedIndexChanged Event in JQuery

Introduction: 

Here I will explain how to raise dropdownlist selectedindexchanged event in jquery using asp.net.

Description:
  
In previous articles I explained How to bind dropdownlist using JQuery and how to get dropdownlist selected value and text using JQuery and many articles relating to JQuery. Now I will explain how to raise dropdownlist selectedindexchanged event in JQuery using asp.net.

JQuery get dropdown selected value and text in asp.net

Introduction: 

Here I will explain how to get dropdownlist selected value or selected item text using JQuery in asp.net.

Description:
  
In previous articles I explained How to bind dropdownlist using JQuery and many articles relating to JQuery. Now I will explain how to get dropdownlist selected value using JQuery in asp.net.

If we want to get dropdownlist selected value or selected item text in JQuery we need to write the code like as shown below

How to Get Selected Value from Jquery Autocomplete textbox in asp.net

Introduction: 

In this article I will explain how to get id or value of selected item from jquery autocomplete textbox using webservice in asp.net.

Description:
  
In previous articles I explained AutoComplete with webservice, JQuery autocomplete textbox example, Ajax autocomplete extender example and many articles in JQuery using asp.net. In this article I will explain how to get id or values of selected item from jquery autocomplete textbox in asp.net.

the files use a different language which is not allowed since they need to be compiled together

Introduction: 

Here I will explain how to solve the problem “the files use a different language which is not allowed since they need to be compiled together” when running web application using asp.net. 

Description:

In previous article I explained JQuery autocomplete text with webservice. During work with that sample I created WebService in both the languages C# and VB.NET and I placed both languages code behind files in App_Code folder and I tried to run the application at that time I got error like “the files use a different language which is not allowed since they need to be compiled together” as shown below

Jquery Autocomplete Textbox With Asp.net Web Service

Introduction:

In this article I will explain how to implement jquery autocomplete textbox with webservice in asp.net.

Description:
  
In previous articles I explained JQuery autocomplete textbox example, Ajax autocomplete extender example and many articles in JQuery using asp.net. In previous explained JQuery autocomplete textbox sample article I used page methods directly calling from the page because of that it’s not possible to use that automcomplete functionality in master pages. We can solve this problem by create webservice and use that service to get data from database in asp.net.

Blogspot.com,Other Sites not Opening in My System Laptop PC

Introduction

Here I will explain how to solve the problem of not opening blogspot or other websites in your laptop, system or pc.

Description:

Few days back I faced some strange problem like the sites which contains blogspot.com at the end like www.aspdotnet-suresh.blogspot.com those kind of sites not opened in my laptop. I thought may be internet problem but other sites are opening correctly If I try to open same blogspot url in some other system it’s working fine but in my laptop if I opened that it’s showing error like cannot find the server at www.aspdotnet-suresh.blogspot.com as shown below

How to Setup-Configure DNS Server in Windows 7 system/laptop

Introduction

Here I will explain how to configure or setup or add DNS server in windows 7 system or laptop or pc.

Description:

In Previous article I explained how to create desktop shortcut to lock computer just by single click. Now I will explain how to setup or configure dns server in windows 7. To add or setup or configure dns server we need to follow below steps

jQuery Open All External Links in New Window

Introduction: 

Here I will explain how to use jQuery to open all external links in new window or open all external links in new window using jQuery

Description:
  
In previous article I explained open all hyperlinks in new window, expand textbox on focus and disable right click on image using JQuery and many articles relating to JQuery. Now I will explain how to open external links in new window using JQuery in asp.net.

Previous post open all hyperlinks in new window will open all internal and external links in new window. In many situations everybody prefer to open their website internal links in same window and external links (other website links) should be open in new window

jQuery Open All Links in New Window | jQuery Open Hyperlinks in New Window

Introduction: 

Here I will explain how to use jQuery to open all links in New Window or jQuery make all links open in new window or jquery open hyperlink in new window.

Description:
  
In previous article I explained expand textbox on focus and disable right click on image using JQuery and many articles relating to JQuery. Now I will explain how to open all hyperlinks in new window using JQuery in asp.net.

how to get current datetime in jquery/JavaScript

Introduction: 

Here I will explain how to get current datetime in jquery or JavaScript.

Description:
  
In previous articles I explained auto refresh page , expand textbox on focus and disable right click on image using JQuery and many articles relating to JQuery. Now I will explain how to get current datetime in JQuery or JavaScript in asp.net.

Get current datetime in jquery

Please check below code to get current datetime using jquery