export acces dta into CSV format

Question

Hiii plz help me how to export the access data or Table into CSV format using Asp.net with c#.

Bechir Bejaoui · Answer

List oList = new List (); foreach (DataTable t in ds.Tables) { oList.Add(t.TableName); oList.Add(Environment.NewLine); foreach (DataRow r in dt.Rows) { foreach (DataColumn c in dt.Columns) { oList.Add(c.Caption +   + r[c].ToString() +  ); } } oList.Add(Environment.NewLine); oList.Add(Environment.NewLine); } System.IO.File.WriteAllLines(@C:\myFile.csv oList.ToArray()); oConn.Close(); MessageBox.Show(Done);