Asp.net Display List of Files from Server Folder in Gridview

Introduction:

Here I will explain how to display list of files from server folder in asp.net Gridview or get files from folder or directory and bind to Gridview in asp.net using C#, VB.NET.

Description:

In previous articles I explained create zip files in asp.net, Delete files from uploaded folder in asp.net, create/delete directory in asp.net, Joins in SQL Server and many articles relating to Gridview, SQL, jQuery, asp.net, C#, VB.NET. Now I will explain how to display list of files from server folder in asp.net Gridview using C#, VB.NET.

SQL Server - Insert Multiple Rows with One Insert Statement

Introduction:

Here I will explain how to insert multiple rows into table with single insert query in sql server or sql server insert multiple records in table with one insert statement with example.

Description:

In previous articles I explained SQL Server Get total rows count in union query, SQL Server Difference between Union and Union All, SQL Server Replace multiple spaces in string with single space, SQL Server Remove html tags from string and many articles relating to SQL server. Now I will explain how to insert multiple rows into table with single insert query in sql server.

To insert multiple rows into table with single insert query in sql server we can follow different methods like as shown below

SQL Server - Get Total Records Count in Union Query

Introduction:

Here I will explain how to get total records count of union query in sql server 2008 or sql server query to get total records of union statement with example.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get total records count of union query in sql server 2008.

SQL Server - Difference between Union and Union All

Introduction:

Here I will explain difference between UNION and UNION ALL in SQL server. Union operator will return unique records from tables and Union All in SQL server will return all the records from the tables including duplicate values also.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain difference between UNION and UNION ALL in SQL server.

Generally Union Operators are used to combine the result of two or more select queries into single result set.

Asp.net Create DataTable Dynamically and Bind to Gridview in C#

Introduction: 

Here I will explain how to create datatable dynamically and bind to gridview in asp.net using c#, vb.net or bind asp.net gridview with dynamically created table in c#, vb.net or create temporary table and bind data to columns in datatable dynamically using asp.net in c#, vb.net.

Description: 

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. In many of articles I used datatable to bind data from database but in one situation I got requirement like dynamically build and bind data to datatable in asp.net.

Bind Asp.net Gridview with DataTable in C# Dynamically

Introduction:

Here I will explain how to bind gridview with datatable in asp.net using C# and VB.NET or create datatable dynamically and fill / bind gridview datasource in asp.net using C# and VB.NET.

Description:

In previous articles I explained insert xml data to sql table using stored procedure, Highlight gridview rows based on search in asp.net, create online poll system with percentage graphs in asp.net and many articles relating to xml, Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to bind gridview with datatable in asp.net using C# and VB.NET.

jQuery Higlight Table Row & Column on Mouseover in Asp.net

Introduction:

here I will explain how to use jQuery to highlight table row and column on mouse over in asp.net using jQuery, c#, vb.net with example or jQuery table highlight row & column on hover in asp.net using c#, vb.net.

Description:

In previous post I explained jQuery Tag cloud example in asp.net, jQuery show datatable on aspx page in asp.net, send html page as mail body in asp.net, how to send mail with attachment in asp.net and many more articles related to jQuery,asp.net, c# and vb.net. Now I will explain how to how to highlight table row and column on mouse hover in asp.net using jQuery, c#, vb.net with example.

Asp.Net Tag Cloud Example with Database in C#,VB.NET

Introduction:

Here I will explain how to create tag cloud in asp.net website using jQuery, c#, vb.net with example or generate tag cloud in asp.net with database using jQuery, c#, vb.net.

Description:

In previous post I explained sitemap control example, send html page as mail body in asp.net, send mail with images using gmail user credentials, send multiple attachments with email in asp.net, how to send mail with attachment in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to how to create tag cloud in asp.net website using jQuery, c#, vb.net with example.

Enable Gzip Compression in Asp.net using Web.Config to Improve Website Performance

Introduction:

Here I will explain how to enable gzip compression in asp.net using web.config file or add gzip compression in asp.net website using web.config file. Gzip compression is used to increase the page performance of website or application by compressing html, css, jquery, JavaScript etc files.

Description:

In previous post I explained Difference between cursor and while loop in sql server, Breadcrumb example in asp.net, how to pass table as parameter to stored procedure, Add Fade in effect to webpage using JQuery and many articles relating to asp.net, JQuery, Ajax etc. Now I will explain how to enable gzip compression in asp.net using web.config file to increase page performance of website.

SQL Server - Difference between Cursor and While Loop with Example

Introduction:

Here I will explain difference between cursor and while loop in sql server with example or explain cursor vs while loop with example in sql server. Cursors in sql server allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. While loop also same as cursor to fetch set of data and process each row in sql server.

Description:

In previous articles I explained While loop example in sql server, nested while loop example in sql server SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain difference between cursor and while loop in sql server.

Master page with Menu Control in Asp.net C# with Example

Introduction:

Here I will explain how to create master page with menu in asp.net example or how to use asp.net menu control in master page to create menu and submenus. Here I will use sitemap and sitemapdatasource control to bind asp.net menu in master page.

Description:

In previous post I explained Breadcrumb example in asp.net, how to pass table as parameter to stored procedure, Add Fade in effect to webpage using JQuery and many articles relating to asp.net, JQuery, Ajax etc. Now I will explain how to create master page with menu in asp.net example.

jQuery Clone (Copy) Dropdown List with Selected Value

Introduction: 

Here I will explain how to use jQuery to copy or clone dropdown list with selected option or jQuery copy dropdown value to another dropdown.

Description:
  
In previous articles I explained jQuery get radio button selected value by name, jQuery pdf viewer plugin examples, jQuery news ticker plugin examples, jQuery dropdown with images, jQuery Countdown timer script example and many articles relating to jQuery in asp.net. Now I will explain how to get clone dropdown list using jQuery.

jQuery Get Radio Button Selected Value by Name

Introduction: 

Here I will explain how to use jQuery to get radio button selected value by name or jQuery get radio button list / group selected value.

Description:
  
In previous articles I explained jQuery audio player plugin examples, jQuery check if checkbox checked or not, jQuery dropdown with images, jQuery pie chart example with database in asp.net, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will explain how to get radio button selected value by name in jQuery.

C# - How to Send Bulk Email in Asp.net with Example using C#, VB.NET

Introduction:

here I will explain how to send bulk email in asp.net using c#, vb.net with example. To send mail to bulk people in asp.net we need to get all the user email ids and send mail to each emailid by using foreach loop in asp.net using c#, vb.net.

Description:

In previous post I explained send html page as mail body in asp.net, send mail with images using gmail user credentials, send multiple attachments with email in asp.net, how to send mail with attachment in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to send bulk email in asp.net using c#, vb.net with example.

jQuery Check if Radio Button is Checked (Selected) or Not

Introduction: 

Here I will explain how to use jQuery to check if radio button checked / selected or not. In jQuery we can check if radio button selected / checked or not in different ways by using radio button properties prop or attr.

Description:
  
In previous articles I explained jQuery check if checkbox checked or not, jQuery dropdown with images, jQuery change style of controls, jQuery enable or disable hyperlinks, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will how to check if radio button checked / selected or not in jQuery.

We can check whether radio button checked or not in different ways those are