• How to import data from Excel to DataTable C#

    by  • June 24, 2013 • Microsoft .NET C# (C-Sharp), Microsoft ASP.NET • 0 Comments

    I have explained in one of my previous articles that how to export data from DataTable to Excel C#. We also need data from excel and we might need it in DataTable so this article will explain how we can get data from Excel to DataTable C#.

    Well, the process of C# Excel to DataTable is simple. You just need to get connection with excel file, retrieve data and store it in a DataTable or you may use DataSet.

    Here is the code to import data from excel to DataTable C#. You can download complete source code at the end.

    Later, you can use DataTable object for your purpose. I am using a GridView  to display data.

    . You can download complete source code at the end.




    Best WordPress Themes and Plugins with Great Team and Support!

    Avatar of GetCodeSnippet.com

    About

    GetCodeSnippet.com provides you high quality Microsoft .NET development related articles, tutorials and sample code for ASP.NET, C#, VB.NET, AJAX, WCF, WPF, Web Services, Windows Services, SQL Server and other technologies.

    Leave a Reply