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

Showing posts with label ExcelSheet. Show all posts
Showing posts with label ExcelSheet. Show all posts

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

Dec 18, 2012 7 comments
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

Dec 17, 2012 46 comments
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.

Export selected rows of gridview to Excel or word in ASP.Net

Dec 12, 2011 15 comments
Introduction:

Here I will explain how to export only selected or checked rows or records from gridview to Word or Excel sheet using asp.net.


Description:

In my previous posts I explained clearly how to export gridview data to Excel or word using asp.net and how to export gridview data to PDF using asp.net and explained another post that is Export gridview data to CSV file using asp.net. After explain all the concepts one of the user has asked me a question i.e. how to export gridview records to excel/word based on checkbox selection in gridview. To implement this one first design one table in database as shown below and give name as “UserInformation” 

Export gridview data to Excel/word document in asp.net C#

Apr 2, 2011 76 comments
Introduction:

Here I will explain how to export gridview to Word or Excel document using asp.net in c#.


Description:

I have one gridview that has filled with user details now I need to export gridview data to word or excel document based on selection. To implement this functionality first we need to design aspx page like this 

how to Import data from EXCEL to SQL Database in ASP.NET

Sep 15, 2010 184 comments
Introduction

Here I will explain how to Import or insert data into SQL database from Excel spreadsheet using Sqlbulkcopy method.

Description

 I have searched for so many posts that explain static manner some of the posts are not clearly some of the posts are not supporting for latest excel files so many problems i faced by using those examples I have done application that will support for all excel versions and it will work for you without having any problems and it will dynamically you can upload excel sheet from anywhere from your computer.

First of all create Excel workbook as shown in image below and insert some data into it. Please design excel sheet like whatever I shown in image

Read the data from Excel Sheet and bind it to Gridview in asp.net

Jun 21, 2010 32 comments
Here i will explain how to read the data from Excel sheet and bind that data to gridview in asp.net

1) First take one upload control, one button and one gridview like this


How to Make Some cells Read only in Excel Sheet and other should be editable

8 comments
In Excel sheet we can make some cells read only and some cells editable by using these following steps

1) First Select whole Excel Sheet by Ctrl+A After that

2) Right Click on excel sheet you will find Format Cells Option that screen look like this



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.