How to export database data into Excel file

Question

How to export database data into Excel file using C# Windows Forms application?

This is my code:

MySqlConnection con = new MySqlConnection(conne);
con.Open();

MySqlCommand com = new MySqlCommand ("SELECT * FROM aster",con);

MySqlDataAdapter data = new MySqlDataAdapter(com);
DataTable dat = new DataTable("aster");
data.Fill(dat);

dat.WriteXml("C:Downloads\\agent.xls");
MessageBox.Show("export data successfully");

The data exports successfully. But my problem is that again and again it saves in same file.

Please refer some link to help me.

Yeah, I that can be really better and simpler

Andrew
– Andrew

2016-01-14 06:44:40 +00:00
Commented Jan 14, 2016 at 6:44 — Andrew
– Andrew, Commented Jan 14, 2016 at 6:44
Because you're saving it as agent.xls all the time?

Liren Yeo
– Liren Yeo

2016-01-14 06:54:31 +00:00
Commented Jan 14, 2016 at 6:54 — Liren Yeo
– Liren Yeo, Commented Jan 14, 2016 at 6:54

Sklivvz · Accepted Answer · 2017-04-26 21:02:35Z

4

Use this datetime format:

DateTime date = DateTime.Now;
int t = date.Hour;
int t1 = date.Minute;
int t2 = date.Second;
int m = date.Month;
int d = date.Day;

dat.WriteXml("C:\\Downloads\\agent" + t + " - " + t1 + " - " + t2 + " - " + d + " - " + m + ".xls");

edited Apr 26, 2017 at 21:02

Sklivvz

31.3k24 gold badges123 silver badges174 bronze badges

answered Jan 14, 2016 at 6:51

user5788181

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to export database data into Excel file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related