Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

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.
To implement this concept check below posts here I explained two ways to insert data into database



If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email

8 comments :

Anonymous said...

mmm

Jaya Kumar said...

Hello Sir,

Please give idea for Excel sheet to SQl server insetion using the asp.net C#.

Anonymous said...

http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html

Dinesh Behera said...

but how to import excel data row by row to database checking blank row

Prhemnath Raju said...

Mr. suresh , when i apply this code locally its is executed but when i try to do it over internet it's not working, should i add any reference file to so that i can upload it over internet?

karthik k said...

Hello sir,
when i am trying to import data from excel to DB,it shows Violation of primary key Constraint.
how can i add data in to table using exception.
Can you help me to solve this problem.

Admin kavin said...

Dear sir,
Please provide me an idea to save excel data to the sql server 2005.

Jerk Du said...
This comment has been removed by a blog administrator.

Give your Valuable Comments

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.