What is the best way to save the Datagridview Content ?

Question

0.00/5 (No votes)

See more:

C#

What is the best way to save the Datagridview Content?
Thank you for any response I can get on this.

Posted 28-Mar-12 10:04am

Al Yambo

Updated 28-Mar-12 14:15pm

v2

Add a Solution

Comments

Thilina Chandima 28-Mar-12 21:15pm

explain more about your problem..

2 solutions

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)

Clifford Nelson · Accepted Answer · 2012-03-28T17:40:00

Solution 1

You have a number of different optiona: XML, text, or Excel. Normally would recommend either xml or excel. Excel has the adbantage in the users can open the file, and play with the data. XML is a standard that is easy to work with with software. You can also save in binary, which takes less space, but hard to debug since it is not human readable. One important note about excel, and that is you have to have Excel installed, and cannot be used on a server. There was a product called ExcelWriter that would work on a server without Excel.

Posted 28-Mar-12 17:40pm

Clifford Nelson

Updated 28-Mar-12 20:42pm

v2

Comments

Al Yambo 29-Mar-12 13:16pm

Thank you for your response. One more question -- So you cannnot open the excel file on your application if EXCEL spreadsheet software is not installed?

Clifford Nelson 29-Mar-12 13:45pm

To be able to do anything by read Excel file, you need Excel (this is what I understand from others, always have had excel installed). You can get a reader from the web, but that probably only helps the user, not your application. If you do not have excel installed, can create a CSV file, with is the cells with commas between elements. You will have to add quotes on cell items that contain commas.

Vinay Swa · Accepted Answer · 2012-03-28T19:33:00

Solution 2

Hi,

options are - XML, Excel, CSV.
In these i will prefer CSV files. It is very simple to transfer the data from datagridview to CSV files.

CSV, comma separated values, files are commonly used to transport large amounts of tabular data between either companies or applications that are not directly connected. The files are easily editable using common spreadsheet applications like Microsoft Excel.

Posted 28-Mar-12 19:33pm

Vinay Swa

Comments

Al Yambo 29-Mar-12 13:21pm

Thank you for your response. One more question -- Can these CSV files have colored cells and set fonts for instance when opened in Microsoft Excel?