{"id":120,"date":"2010-12-18T11:52:00","date_gmt":"2010-12-18T17:52:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=120"},"modified":"2010-12-18T11:52:00","modified_gmt":"2010-12-18T17:52:00","slug":"save-dataset-to-comma-delimited-file","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=120","title":{"rendered":"Save Dataset To Comma-Delimited File"},"content":{"rendered":"

\/\/save dataset to file<\/span><\/p>\n

<\/span> <\/p>\n

<\/span> private<\/span> void<\/span> saveFile()<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>try<\/span><\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>saveFileDialog1.Filter = “Text File|*.csv”<\/span>;<\/span><\/p>\n

<\/span>DialogResult dr = saveFileDialog1.ShowDialog();<\/span><\/p>\n

<\/span>if<\/span> (dr.Equals(DialogResult.OK))<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>Stream saveStream = saveFileDialog1.OpenFile();<\/span><\/p>\n

<\/span>StreamWriter saveWriter = new<\/span> StreamWriter(saveStream);<\/span><\/p>\n

<\/span>string<\/span> delim = “”<\/span>;<\/span><\/p>\n

<\/span> <\/p>\n

<\/span>foreach<\/span> (DataColumn c in<\/span> usmDataSet_LocateEst.qLocateEst.Columns)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>saveWriter.Write(delim);<\/span><\/p>\n

<\/span>saveWriter.Write(c.ColumnName);<\/span><\/p>\n

<\/span>delim = “,”<\/span>;<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span>saveWriter.WriteLine();<\/span><\/p>\n

<\/span> <\/p>\n

<\/span>foreach<\/span> (DataRow r in<\/span> usmDataSet_LocateEst.qLocateEst.Rows)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>delim = “”<\/span>;<\/span><\/p>\n

<\/span> <\/p>\n

<\/span>foreach<\/span> (DataColumn c in<\/span> usmDataSet_LocateEst.qLocateEst.Columns)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span>saveWriter.Write(delim);<\/span><\/p>\n

<\/span>saveWriter.Write(r[c]);<\/span><\/p>\n

<\/span>delim = “,”<\/span>;<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span>saveWriter.WriteLine();<\/span><\/p>\n

<\/span> <\/span>}<\/span><\/p>\n

<\/span>saveWriter.Close();<\/span><\/p>\n

<\/span>MessageBox.Show(“File Saved!”<\/span>, “Save Results”<\/span>, MessageBoxButtons.OK, MessageBoxIcon.Information);<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span>catch<\/span> (Exception ex)<\/span><\/p>\n

<\/span>{<\/span><\/p>\n

<\/span> <\/span>MessageBox.Show(“Error Saving File: “<\/span> + ex.Message, “Error!”<\/span>, MessageBoxButtons.OK, MessageBoxIcon.Error);<\/span><\/p>\n

<\/span>}<\/span><\/p>\n

<\/span>}<\/span> <\/span><\/span> <\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\/\/save dataset to file private void saveFile() { try { saveFileDialog1.Filter = “Text File|*.csv”; DialogResult dr = saveFileDialog1.ShowDialog(); if (dr.Equals(DialogResult.OK)) { Stream saveStream = saveFileDialog1.OpenFile(); StreamWriter saveWriter = new StreamWriter(saveStream); string delim = “”; foreach (DataColumn c in usmDataSet_LocateEst.qLocateEst.Columns) { saveWriter.Write(delim); saveWriter.Write(c.ColumnName); delim = “,”; } saveWriter.WriteLine(); foreach (DataRow r in usmDataSet_LocateEst.qLocateEst.Rows) { delim = … Continue reading “Save Dataset To Comma-Delimited File”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/120"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=120"}],"version-history":[{"count":0,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/120\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}