CodeSnip: How to Query and Display Excel Data in GridView Control: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: How to Query and Display Excel Data in GridView Control

page 5 of 5

by Sushila Bowalekar Patel
Feedback

Average Rating:

Views (Total / Last 10 Days): 26151/ 112

Article Contents:

Conclusion

This sample shows how to query excel and display the data in GridView Control. We can choose to display specific columns by modifying the SQL String in the Select clause with required columns or by using GridView's BoundField or TemplateField Columns.

« (Page 4)

View Entire Article

User Comments

Title: Thanx
Name: Venkat
Date: 2007-06-08 11:07:54 AM
Comment:
Excellent worked first time itself thanx

Title: 10x!
Name: Amit
Date: 2007-06-05 4:04:37 AM
Comment:
Excellent code!.
A succefull in the first time!

Title: Problem
Name: Tony Ngo
Date: 2007-04-10 4:30:10 PM
Comment:
It's all work fine except if you column have the value '12345678' then the filed will be displayed as 1.23e+7

Title: How to Query and Display Excel Data in GridView Control
Name: Sushila Bowalekar Patel
Date: 2007-04-08 1:00:21 AM
Comment:
Hi,
this was very helpful to me while i doing one of my friends assignment.
thanks a lot

eric

Title: sheet's name ?
Name: CarlosW
Date: 2007-02-16 10:59:28 AM
Comment:
And what happen if i don't know the sheet's name ? how can i solve this problem ?

Title: WHY THIS KIND OF ERROR?
Name: DYANETHI MARAN PONTATI
Date: 2007-01-24 2:07:14 AM
Comment:
'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Title: Mr.
Name: NimeX
Date: 2007-01-05 2:36:18 AM
Comment:
Can we also enable paging with this??

Title: introlux
Name: Arif
Date: 2006-11-20 6:26:31 AM
Comment:
Really good code! top man! So easy to folow instructions! Wish everyone could demonstrate code like yourself!

thanks once again

Title: Mr.
Name: Vinod Merchant
Date: 2006-11-13 7:21:17 PM
Comment:
This is very good
Where can I find more such articles
Vinod
vinodmerch@yahoo.co.uk

Product Spotlight