Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WinForm
Hi Expert,
 
I am Uday Satardekar,
 
In C# winform application, i am using Datagridview as excel for data entry.
 
I am sending these data from Datagridview ( Emails, companies countries etc.) to server using
 
Xml and then using stored procedure to store the data into database.
 

Besides this now i want to store these information in excel File on server. And every time it must create separate excel file.
 
So please guide me ,how to create excel file with uniq name and store data as it is on same file on server.Here i am just creating excel with any name with data and then fetching that excel with name only.
 
My Server is on different computer.and there are multiple computers accessing it.
 

So please help me to sort out this problem.
Sorry for poor English.
 
Thanks in advance.
Posted 14-Feb-13 1:29am
udusat131.4K
Comments
Edo Tzumer at 14-Feb-13 6:50am
   
Which part exactly is your problem?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Exporting the data to excel is a quite common task. If you google, you will get many decent examples. The following link explains of exporting the XML data to excel:
 
http://social.msdn.microsoft.com/Forums/br/csharpgeneral/thread/ea02f8e8-edf5-4aca-8c74-ef3a94b5328d[^]
 
In the above example a dataset is converted to XML and then exported to excel. You can skip the part of converting dataset to xml and then try it.
 
All the best.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 280
1 Sergey Alexandrovich Kryukov 279
2 CPallini 205
3 Maciej Los 197
4 Afzaal Ahmad Zeeshan 160
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100