How to Create and Download Excel File in Asp.net C#, VB.NET

Introduction: 

Here I will explain how to create and download excel file in asp.net using c#, vb.net or create & download excel file from datatable in asp.net using c#, vb.net.

Description:
  
In previous articles I explained export data to excel from datatable in asp.net, Get Controls inside gridview in asp.net, import data from excel to sql database in asp.net, export gridview data to excel in asp.net using c#, export gridview data to pdf in asp.net using c# and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain how to create and download excel file in asp.net using c#.

How to Export Data from SQL Server to Excel in Asp.net using C#

Introduction: 

Here I will explain how to export data from sql server to excel in asp.net using c# or export data from sql server database to excel in asp.net using c#.

Description:
  
In previous articles I explained sql injection attacks prevention in asp.net, ExecuteReader example in asp.net, import data from excel to sql database in asp.net, export gridview data to excel in asp.net using c# , export gridview data to pdf in asp.net using c# and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain how to export data from sql server to excel in asp.net using c#.

How to Export Data to Excel from Datatable or Gridview in Asp.net using c#, vb.net

Introduction: 

Here I will explain how to export data to excel from datatable or dataset in asp.net using c# and vb.net or export data to excel from gridview in asp.net using c# and vb.net.

Description:

In previous posts I explained export gridview data to csv file in asp.net, export gridview data to pdf file in asp.net, export data from excel to gridview in asp.net, import excel data to sql server in asp.net, asp.net Google currency converter and many articles relating to gridview, asp.net, c#. Now I will explain how to export data to excel from datatable or dataset in asp.net using c# and vb.net.

C# - Export Excel Data to Datatable or Dataset or Gridview in Asp.net

Introduction:

Here I will explain how to export excel data to datatable or dataset in C#, VB.NET or export data from excel to gridview in asp.net using OLEDB in C#, VB.NET.

Description:
  
In previous article I explained Export gridview data to excel in asp.net, How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to export excel data to datatable or dataset or gridview in asp.net using C#, VB.NET.

Show Alert Message in Asp.net from Code behind in C#, VB.NET

Introduction: 

Here I will explain how to show alert message in asp.net from code behind using c# and vb.net.

Description:

In previous posts I explained show alert message from code behind using JavaScript, jQuery generate years dropdown dynamically, asp.net Google currency converter, jQuery floating div on page scroll and many articles relating to gridview, asp.net, c#. Now I will explain how to show alert message in asp.net from code behind using c# and vb.net.

Sorting Columns in Repeater Control in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to implement sorting in repeater control in asp.net using c#, vb.net with example or how to sort columns in repeater control in asp.net using c#, vb.net.

Description:
  
In previous articles I explained Repeater Control Example in asp.net, Display time like facebook/twitter like 1 minute ago, hour ago, use of using statement in c#, make some cells read only in excel sheet and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to implement sorting in repeater control in asp.net using c#, vb.net with example.

ASP.Net - Add Items to Dropdownlist Programmatically on Button Click in C# and VB.Net

Introduction: 

Here I will explain how to add items to dropdownlist programmatically on button click in asp.net using c# and vb.net or dynamically add items to dropdownlist on button click in asp.net using c# and vb.net.

Description:
  
In previous articles I explained Cascading dropdownlist example in asp.net, highlight gridview records based on search in asp.net, filter gridview records based on dropdown selection in asp.net and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to add items to dropdownlist programmatically in asp.net using c# and vb.net.

Resizable Asp.net Gridview using jQuery with Example in C#, VB.NET

Introduction:

Here I will explain how to resize asp.net gridview using jQuery with example in c#, vb.net or resizable gridview using jQuery with example. To implement resizable gridview using jQuery we need to use jQuery & jQuery ui plugin because we need to set resizable() property for gridview to make it resizable in c#, vb.net.

Description:

In previous articles I explained Get asp.net gridview selected row values on button click, Create table dynamically in asp.net and bind to gridview, export gridview data to excel in asp.net, Group Gridview columns with header row in asp.net and many articles relating to asp.net, c#, vb.net and jQuery. Now I will explain how to resize asp.net gridview using jQuery with example in c#, vb.net.

C# - Create a ASPX Page Dynamically in ASP.NET using C#.NET, VB.NET

Introduction:

Here I will explain how to create aspx page dynamically in asp.net using c#, vb.net or Dynamically create aspx page in your project at runtime in asp.net using c#, vb.net.

Description:

In previous articles I explained Create table dynamically in asp.net and bind to gridview, Get name of the day from date in c#, Prevent sql injection attacks in asp.net, Asp.net convert numbers to words in c#, Display list of files from folder in asp.net gridview and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to create aspx page dynamically in asp.net using c#, vb.net.

Get Asp.net Gridview Selected Row Values on Button click in C#

Introduction:

Here I will explain how to add checkboxes in asp.net gridview and get gridview selected rows data on button click in asp.net and get checked rows data on button click and how to work with those checked rows in asp.net using c#, vb.net.

Description:

In previous articles I explained Create table dynamically in asp.net and bind to gridview, export gridview data to excel in asp.net, Group Gridview columns with header row in asp.net and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to add checkboxes to gridview and get gridview selected rows data on button click in asp.net.

C# - Get (Find) Name of the Day From Date in Asp.Net

Introduction:

Here I will explain how to find or get name of the day in a week in asp.net using c#, vb.net when user will input the date.

Description:

In previous articles I explained SQL Query to find first & last day of month, SQL Query to get month wise & year wise data, SQL Query exclude weekends to get data, SQL Server Get only month & year from date and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to find or get name of the day in a week in asp.net using c#, vb.net when user will input the date.

Asp.net Preventing SQL Injection Attacks using Parameterized Queries

Introduction:

Here I will explain how to prevent SQL injection attacks in asp.net website with example using c#, vb.net. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous posts I explained SQL injection example in Asp.net, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain how to prevent SQL injection attacks in asp.net website with example using c#, vb.net.

To prevent SQL injection attacks we need to use parameterized queries to pass values from code behind to database like as shown below

SQL Injection Attack Example in Asp.net using C#, VB.NET

Introduction:

Here I will explain what are sql injection attacks in asp.net website with example and how to prevent SQL injection attacks in asp.net using c#, vb.net with example. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous post I explained jQuery scroll to particular position of div when click on link, SQL Server remove duplicate records from table, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain what is sql injection attack in asp.net website with example.

Asp.Net Convert Numbers to Words (String) in C#

Introduction:

Here I will explain how to convert numbers to words in asp.net using c# with example or convert numbers to string in asp.net using c#.

Description:

In previous post I explained jQuery tag cloud example in asp.net, 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 convert numbers to words in asp.net using c# with example.

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.