Subscribe to Subscribers
Talk to Webmaster Tony John

Online Members

Ramya
Christ
More...


Forums » .NET » .NET »

Missing data in data grid while exporting from Excel- C# Windows application


Posted Date: 05 Aug 2010      Posted By:: Aparna     Member Level: Silver    Member Rank: 1485     Points: 1   Responses: 2



hi,

i am triying to upload an excel to a datagrid... my code is correct, and also the data is been displayed in datagrid

but few data is missing... and also if i enter some new data in excel im able to view it only in excel but not in datagrid while exporting

i also tried removing the merge cells but dint work out

can any one give me a solution for this


Regards,
Aparna




Responses

#535287    Author: krishnagoluguri@gmail.com      Member Level: Gold      Member Rank: 92     Date: 06/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

try using repeater control it is dynamic than data grid


 
#535402    Author: Amit Nagar      Member Level: Silver      Member Rank: 1214     Date: 06/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

Hello friend,

Your code 90% correct, problem in u r excel, first set all column (value hold) and rows as TEXT(Format cell-> number -> text), if any numeric column then convert it again as general or numeric.

You got u'r values

if extra values coming then see what s u'r mandatroy feild , put condiotion on that in u'r code where u put u'r query with excel.

thx



 
Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.



Next : Access db problem
Previous : Pls give me download link for Microsoft Visual Studio 2008 express edition
Return to Discussion Forum
Post New Message
Category:

Related Messages



Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
2005 - 2012 All Rights Reserved.
.NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
Articles, tutorials and all other content offered here is for educational purpose only.
We are not associated with Microsoft or its partners.