IOT Virtual Conference - Register now to book your ticket and get updates
x
WIN Surface Laptop 4, i7 Processor, 16GB RAM, 512GB SSD
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
RD Design
2k
25
15k
How to save datagridview as csv file?
May 30 2017 9:26 AM
Hi,
I have a datagridview windows form with some data.I want to export that as a csv file.Here is my code and it gives an error while export.My guess is becuase of some empty values in cells.How can I fix this issue?
public
void
writeCSV(DataGridView gridIn,
string
outputFile)
{
string
filename =
""
;
SaveFileDialog sfd =
new
SaveFileDialog();
sfd.Filter =
"CSV (*.csv)|*.csv"
;
sfd.FileName =
"Output.csv"
;
if
(sfd.ShowDialog() == DialogResult.OK)
{
MessageBox.Show(
"Data will be exported and you will be notified when it is ready."
);
if
(File.Exists(filename))
{
try
{
File.Delete(filename);
}
catch
(IOException ex)
{
MessageBox.Show(
"It wasn't possible to write the data to the disk."
+ ex.Message);
}
}
int
columnCount = dataGridView1.ColumnCount;
string
columnNames =
""
;
string
[] output =
new
string
[dataGridView1.RowCount + 1];
for
(
int
i = 0; i < columnCount; i++)
{
columnNames += dataGridView1.Columns[i].Name.ToString() +
","
;
}
output[0] += columnNames;
for
(
int
i = 1; (i - 1) < dataGridView1.RowCount; i++)
{
for
(
int
j = 0; j < columnCount; j++)
{
output[i] += dataGridView1.Rows[i - 1].Cells[j].Value.ToString() +
","
;
}
}
System.IO.File.WriteAllLines(sfd.FileName, output, System.Text.Encoding.UTF8);
MessageBox.Show(
"Your file was generated and its ready for use."
);
}
}
Reply
Answers (
6
)
How to insert whole partial view in bootstrap modal popup?
readonly keyword