Tutorial for adding the excel sheet data to the database(SQL server) using ASP.NET with C#

Hi friends !! This is Priya here......First of all ..How are you all ?Hope that you all are fine..

I am sharing a tutorial with you that is completely useful for .NET developers as I was trying to import the excel sheet data in the database i.e. SQL server 2008 and after a lot of effort , I became successful in doing this task.This tutorial help you how to import excel sheet data into sql server 2008 using c#.
database-excel-data

Here are the code for this :
You have to follow some steps and then you'll be able to do this successfully . Just follow each and every step carefully :

Before doing this, your system must have following application software :

A) Visual Studio 2008 or later version(Here I am using VS 12) and framework must be 3.5 or later version.
B)SQL Server 2005 or later version
C)MS Office 2007 or later version
D)  Any Browser
Suppose you have to insert a question bank data (which is in excel sheet) in the database . This excel sheet looks like this :
You have to import this excel sheet data into the database . Just follow the below steps :

Steps::

1)Open Visual Studio 2008 or later version.
Go to File--->New Website----> Choose Empty website----->give a name to your website----> OK.
2)Open the source code and just add the following code in the same.
3) This source code will look like this in the front end:
4) Now you have to add this C# code on the click event of link button("insert data") :
C# code :
after this, add the following code just below this code ::
And then save the website and debug it and then run it ; you'll be able to transfer your excel data in the database .

Thank you  guys!! Keep on visiting www.TricksWay.com..
We'll provide you more and more tutorials for you ....
For any queries, you can contact  at priya@tricksway.com

Originally Shared by Guest Author : Priya.

* Do you like this story? Then why not share it with your Friends *
If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to our regular Email Updates!

Himanshu is a young engineer living in India. Currently working at LiveCareer as a software engineer. He is an ethical hacker & blogger too, doing lots of crazy stuff... If you seem interesting, go through his portfolio: www.himstar.info : "Open Source. Millions of open minds can't be wrong!"

20 comments: On Tutorial for adding the excel sheet data to the database(SQL server) using ASP.NET with C#

  • Avatar
    Hipolito M. Wiseman

    I simply want to say I'm beginner to blogging and site-building and honestly enjoyed this blog site. Very likely I’m want to bookmark your website . You surely have awesome articles. Cheers for sharing your blog site.

  • Avatar

    I just want to mention I'm all new to weblog and actually liked this blog. More than likely I’m likely to bookmark your website . You surely have fantastic well written articles. Thank you for revealing your webpage.

  • Avatar

    This is a topic that is close to my heart...

    Cheers! Exactly where are your contact details though?

  • Avatar

    Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something.

    I think that you can do with some pics to drive the message home a
    little bit, but other than that, this is fantastic blog.
    An excellent read. I will certainly be back.

  • Avatar

    I got this site from my buddy who informed me regarding this web page and
    at the moment this time I am visiting this web site and reading very informative articles or reviews here.

  • Avatar

    It's fantastic that you are getting ideas from this post as well as from
    our discussion made here.

  • Avatar

    Admiring the time and effort you put into your website and in depth
    information you present. It's awesome to come across a blog every
    once in a while that isn't the same old rehashed material.
    Great read! I've bookmarked your site and I'm adding your RSS feeds to my
    Google account.

  • Avatar

    Hi there very nice web site!! Guy .. Beautiful .. Amazing ..
    I will bookmark your site and take the feeds additionally?
    I'm happy to find so many useful info right here within
    the publish, we want work out extra strategies in this
    regard, thanks for sharing. . . . . .

  • Avatar

    Hello I am so thrilled I found your site, I really found you by accident,
    while I was browsing on Google for something else, Nonetheless I am
    here now and would just like to say kudos for a tremendous post and
    a all round enjoyable blog (I also love the theme/design), I don’t have time to
    browse it all at the minute but I have saved it and also included
    your RSS feeds, so when I have time I will be back to
    read more, Please do keep up the great work.

  • Avatar

    I like the valuable info you supply in your articles.

    I'll bookmark your blog and check once more here frequently.

    I'm fairly certain I will learn many new
    stuff proper right here! Good luck for the next!

  • Avatar

    I blog quite often and I truly appreciate your content.
    This article has truly peaked my interest. I am going to take a note of your site and keep checking for new details about once
    per week. I subscribed to your RSS feed too.

  • Avatar

    you are truly a good webmaster. The website loading velocity is amazing.
    It seems that you're doing any unique trick. Also, The contents are masterpiece.
    you have done a magnificent activity in this subject!

  • Avatar

    This is my first time go to seе at heгe and i am genuinely imprеssed to read еverthing at single place.

  • Avatar

    Hi there, after reading this awesome paragraph i
    am too glad to share my knowledge here with colleagues.

    my website :: Robert

  • Avatar

    Attractive component to content. I simply stumbled upon your website and in
    accession capital to say that I get in fact loved account your weblog posts.
    Any way I will be subscribing in your augment and
    even I fulfillment you get admission to consistently rapidly.

    Feel free to surf to my web site :: Mora

  • Avatar

    I believe this is one of the so much vital info for me.
    And i am happy studying your article. However want to statement
    on few basic things, The site taste is perfect, the articles is really great : D.

    Just right process, cheers

    Visit my site; Dominica

Leave a reply:

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Site Footer

Sliding Sidebar

We are India’s largest Startup Community


We are team of ' Delhi Startups ' , most active startup community with strict spam policy.
We are making !deas happen..for future, business and jobs without charging anything, with connecting entrepreneurs.. It's a reason to trust on us.
Come and join or subscribe, we will defiantly give a reason to like us.

Our Facebook Page