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
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
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
Subscribe to:
Posts
(
Atom
)
- Asp.net insert, Edit, update, delete data in gridview
- Introduction to Object Oriented Programming Concepts (OOPS) in C#.net
- Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutorial for Beginners
- 3 tier architecture example in asp.net with C#
- how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net
- Simple login form example in asp.net Check Username and Password availability in database
- Interview Questions in ASP.NET,C#.NET,SQL Server,.NET Framework
- Ajax ModalPopUpExtender Example to edit the gridview row values in asp.net
- Ajax Cascading Dropdownlist Sample with database using asp.net
- how to save images into folder and images path in database and display images from folder in gridview based on images path in database using asp.net
