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.