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.

Cascading Dropdownlist in Asp.net Gridview with Example

Introduction:

Here I will explain how to implement cascading dropdownlist in gridview using asp.net with example or implement Ajax cascading dropdownlist in gridview using asp.net in c#. 

Description:

In Previous posts I explained clearly jQuery cascading dropdownlist example in asp.net, how to implement ajax cascading dropdownlist using asp.net  and lot of articles regarding Gridview. Now I will explain how to implement cascading dropdown list in gridview using asp.net. Here I am using previous implemented article ajax cascading dropdownlist in asp.net to bind data to dropdownlists. 

How to Get (Access) Gridview Footer Controls id in JavaScript

Introduction: 

Here I will explain how to access or get asp.net gridview footer control ids or values in JavaScript or find controls inside gridview in JavaScript or find asp.net gridview footer controls (textbox, dropdownlist, checkbox, radio button etc..) values or ids in JavaScript.

Description:

In previous posts I explained bind data to textbox control in asp.net gridview, Cascading Dropdownlist in inside of asp.net gridview, populate one dropdown based on another dropdown in asp.net, bind data to dropdownlist in asp.net gridview and many articles relating to gridview, asp.net, c#. Now I will explain how to get asp.net gridview footer control ids or values in JavaScript.

Get Textbox Value Placed in Asp.net Gridview using C#

Introduction: 

Here I will explain how to find or get text box value placed in gridview in asp.net or how to find controls (textbox, dropdownlist, checkbox,radio button etc..) in inside of asp.net gridview using c#.

Description:

In previous posts I explained bind data to textbox control in asp.net gridview, Cascading Dropdownlist in inside of asp.net gridview, populate one dropdown based on another dropdown in asp.net, bind data to dropdownlist in asp.net gridview and many articles relating to gridview, asp.net, c#. Now I will explain how to find or get text box value placed in gridview in asp.net.

C# - Convert Datatable to List Example using LINQ

Introduction: 

Here I will explain how to convert datatable to list in c# using linq with example or convert datatable to generic list  in c# using linq with example and other ways to convert datatable to list in c# and vb.net.

Description:
  
In previous articles I explained convert string to xml in c#, convert datatable to xml string in c#, convert datatable to json string in c#, convert datatable/dataset to arraylist in c# and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain how to convert datatable to list in c# using linq with example and other ways to convert datatable to list in c#.

Drop or Remove Foreign Key Constraint in SQL Server 2008

Introduction:

Here I will explain how to create or remove / drop foreign key constraint in sql server.  Foreign key constraint in one table point to primary key in another table in sql serverand foreign key constraint is used to prevent the actions that would destroy the links between two tables.

Description:

In previous articles I explained Primary key constraint in sql server, foreign key constraint in sql server, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to remove foreign key constraint in sql server.

How to make a simple USB Desktop Locker in C#

Introduction :
Today I will show you how to make a USB locker for your desktop in C# Windows Application which will keep your computer unlock unless until you plugged out the pen drive. Sounds interesting?  You will find this kind of software in the Internet by search it in Google or in any other search engine. But it comes more happiness when you did it yourself. So lets come make our own USB Desktop locker.

How to do?
First of all take a pen drive, don't get frighten, your pen drive will be safe and workable. Then open the Visual Studio and add a new Windows Application project. As a form is added by default, so you don't need to add any more. Its enough.

SQL Server Convert Table Data to XML Format using XML PATH, XML AUTO or XML RAW

Introduction:

Here I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server. We can convert sql server table data in xml format by using XML AUTO or XML PATH or XML RAW.

Description:

In previous articles I explained SQL Server Get Data in XML format  group by columns, Reading XML data file using SQL query, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server.

SQL Server - Get Data in XML Format Based on Group by Columns in SQL Server with Example

Introduction:

Here in sql server I will explain how to get data in xml format based on group by columns in sql server with example or sql server group columns and show in xml format.

Description:

In previous articles I explained cursor example in sql server, While loop example in sql server, nested while loop example 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 cursor how to get data in xml format based on group by columns in sql server with example.

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.

jQuery Get Dropdownlist Selected Value Onchange Event Example

Introduction: 

Here I will explain how to use jQuery to get dropdownlist selected value onchange Event or jQuery dropdown change event get selected value or jQuery get dropdownlist selected value onchange event.

Description:
  
In previous articles I explained jQuery check if checkbox is checked or not, jQuery change opacity of image on mouseover, jQuery change image on mouseover, jQuery dropdown with images, jQuery show alert message while leaving from website, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will explain how to get dropdownlist selected value during onchange event.

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.

C# - Create Windows Form Application Setup File in C#.Net

Introduction: 

Here I will explain how to create setup file for windows form application in visual studio 2008 in c# with example. To create setup file windows application in c# we need to use setup and deployment section templates in visual studio.

Description:
  
In previous articles I explained constructors in c# with examples, difference between virtual, override, new keywords in c#, Difference between sessionstate and viewstate, Highlight gridview rows on mouseover in jQuery and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to create setup file for windows form application in visual studio 2008 in c# with example.