in my task, excel sheet is uploaded to web application and the i want to read the values i want to display in textboxs.
please give me an idea.........
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jaish MathewsPosted May 7, 2010, 1:24 PM
manohar vakkalaPosted May 7, 2010, 12:48 PM
Jaish MathewsPosted May 7, 2010, 12:20 PM
Use builtin OLEDB class fo read/write excel sheets. They supporting SQL queries like CREATE,SELECT etc..Below one simple article saying that how we can use OLEDB. There used CREATE query for creating a new excel sheet, but you can replace it with SELECT query.
http://www.c-sharpcorner.com/UploadFile/jaishmathews/861/?ArticleID=7b90e584-a5d5-4f02-a196-ea113f310d81