C#- Import/Upload Data from Excel to SQL Server 2008 in Asp.net using C#, VB.Net.

Introduction:

Here I will explain how to upload or import data from excel to SQL Server using asp.net in c#, vb.net.

Description:
  
In previous article I explained Import Excel data to gridview 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 upload or import data from excel to SQL Server using asp.net in c#, vb.net.

Import/Upload Excel Data to Asp.net Gridview in C#, VB.NET

Introduction:

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

Description:
  
In previous article I explained 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 import data from excel to gridview in asp.net.

Asp.net- How to Get Full File Path from Fileupload Control in Firefox or IE

Introduction:

Here I will explain how to get full path of uploaded file from fileupload control from client machine in Firefox or IE in asp.net using C#, VB.NET.

Description:

In previous posts I explained Ajax AsyncFileUpload control example in asp.net, upload and download files from folder in asp.net, asp.net, C#, SQL Server Interview Questions, jQuery validate file extension in file upload control and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to get full path from fileupload control in asp.net using C#, VB.NET.

Find Null/Empty Values in Asp.net Datatable and Replace with Other Values

Introduction:

Here I will explain how to find null or empty values in datatable and replace with other values in asp.net using C#, VB.NET.

Description:

In previous posts I explained Dynamically create datatable in asp.net, jQuery display average rating with decimal values, jQuery generate thumbnails from you tube videos, jQuery redirect to another page after some time delay, send forgot password as email in asp.net and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to find null values in datatable and replace with other values in asp.net using C#, VB.NET.

c#- How to Convert Dataset to XML String in Asp.net, VB.NET

Introduction:

Here I will explain how to convert dataset to xml string in asp.net using C#, VB.NET.

Description:

In previous posts I explained Convert datatable to xml in asp.net, asp.net, C#, SQL Server Interview Questions, jQuery validate file extension in file upload control, send forgot password as email in asp.net and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to convert dataset to xml string in asp.net using C#, VB.NET.

C#.Net- How to Convert DataTable to XML String in Asp.net, VB.NET

Introduction:

Here I will explain how to convert datatable to xml string in asp.net using C#, VB.NET.

Description:

In previous posts I explained asp.net, C#, SQL Server Interview Questions, send gridview as email body, upload and download files from gridview and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to convert datatable to xml string in asp.net using C#, VB.NET.

SQL Sever- Reading XML Data File using SQL Query Example | Read XML Data Type in SQL Server

Introduction:

Here I will explain how to write a query to read xml data file or read xml data type with simple example using SQL Server.

Description:

In previous articles I explained Pass XML file as a parameter to stored procedure, read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to write a query to read xml data in SQL Server.

Pass XML as Parameter from C# to SQL Stored Procedure in VB.NET

Introduction:

Here I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Description:

In previous articles I explained read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Delete a File from Asp.net Uploaded Folder using C#, VB.NET

Introduction: 

Here I will explain how to delete a file from a folder in asp.net using c# and vb.net.

Description:
  
In previous articles I explained 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 delete a file from a folder in asp.net using c# and vb.net.

Show jQuery Version | Check What Version of jQuery is Loaded for Website

Introduction: 

Here I will explain how to check or show what version of jQuery is used in web application.

Description:
  
In previous articles I explained jQuery change background color randomly, jQuery create rounded corner textbox, Get latest or recent tweets using jQuery, jQuery get cursor position and many articles relating to JQuery and asp.net. Now I will explain how to check or show version of jQuery used in web application.