ExecuteNonQuery Example in Asp.Net Using C# and VB.NET

Introduction:

In this article I will explain executenonquery example in asp.net using C#.net and VB.NET.

Description:

In previous post I explained differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteNonQuery concept with one example in asp.net using C#.net, VB.NET.

ExecuteNonQuery

ExecuteNonQuery method will return number of rows effected with INSERT, DELETE or UPDATE operations. This ExecuteNonQuery method will be used only for insert, update and delete, Create, and SET statements.

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar

Introduction:

In this article I will explain differences between executereader, executenonquery and executescalar in asp.net.

Description:

In previous posts I explained difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between executereader, executenonquery and executescalar in asp.net

Difference Between LEN and DATALENGTH Functions in SQL Server

Introduction:

In this article I will explain differences between Len() and DataLength() functions in sql server.

Description:

In previous post I explained differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain differences between Len() and DataLength() functions in SQL Server.

JQuery Textbox with Clear Button | Clearable Textbox With JQuery Plugin

Introduction:

Here I will explain how to use JQuery to implement clearable textbox or textbox with clear button in JQuery using asp.net.

Description:

In previous article I explained Generate thumbnails from youtube video, Generate thumbnails from images using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to create or implement textbox with clear button using JQuery in asp.net.

How to Send Gridview in Email Body in Asp.Net Using C#, VB.NET

Introduction:

In this article I will explain how to send Gridview as email body in asp.net using C# and VB.NET.

Description:

In previous article I explained Send HTML file as Email body in asp.net, Send Mail in asp.net, Send mail with images using gmail credentials, Send mail with attachment in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to send Gridview as email body in asp.net using C# and VB.NET.

How to Send HTML Page As Email Body in Asp.Net Using C#.NET,VB.NET

Introduction:

In this article I will explain how to send html page as email body in asp.net using C# and VB.NET.

Description:

In previous article I explained Send Mail in asp.net, Send mail with images using gmail credentials, Send mail with attachment in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to send html page as email body in asp.net using C# and VB.NET.

JQuery Show Large Image Preview When Hover On Link In Asp.Net

Introduction:

In this article I will explain how to show large image preview when hover on link or image using JQuery in asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net, Generate thumbnails from YouTube videos using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to show large image preview when hover on link or image using JQuery in asp.net.

Generate/Create Thumbnails From Images in JQuery using Asp.net

Introduction:

In this article I will explain how to create or generate thumbnails from Images in JQuery using asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net, Generate thumbnails from YouTube videos using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to generate or create thumbnails from Images using JQuery in asp.net.

Generate/Create Thumbnails From YouTube Video in JQuery Using Asp.net

Introduction:

In this article I will explain how to create or generate thumbnails from YouTube videos in JQuery using Asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to generate or create thumbnails from YouTube videos using JQuery in asp.net.

To generate thumbnails from YouTube videos we can use YouTube API URL that would be like this

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