How to create excel file with data using stored procedure in C# winform?

Question

0.00/5 (No votes)

See more:

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 0:29am

udusat13

Add a Solution

Comments

Joezer BH 14-Feb-13 6:50am

Which part exactly is your problem?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kiran Susarla · Answer 1 · 2013-02-14T01:09:00

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.