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: 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: 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
Today

Last 7 Days

more...

Awards & Gifts

Email subscription