Export to CSV not working -handheld device-Smart Device App.

Question

I am working with Mobile Handheld device application using c#, trying to export datatable to csv file but none of method are working for me, Plateform Visual Studio 2008 and Smart Device Application.File.WriteALLText method is not working in smart device application. private void btnsubmit_Click( object sender, EventArgs e) { TextWriter txt = new StreamWriter( "logs.txt" ); try { if (! string .IsNullOrEmpty(txtOutput.Text) && ! string .IsNullOrEmpty(txtqty.Text)) { DataTable dt; dt = new DataTable(); dt.Columns.Add( "Barcode" , System.Type.GetType( "System.String" )); dt.Columns.Add( "Location" , System.Type.GetType( "System.String" )); dt.Columns.Add( "Quantity" , System.Type.GetType( "System.String" )); DataRow dr = dt.NewRow(); dr[ "Barcode" ] = txtOutput.Text.Trim(); dr[ "Location" ] = "123" ; dr[ "Quantity" ] = txtqty.Text.Trim(); dt.Rows.Add(dr); StringBuilder data = ConvertDataTableToCsvFile(dt); SaveData(data, @ "Data.csv" ); MessageBox.Show( "Data exported Success" ); } else { MessageBox.Show( "Please enter all value" ); } txt.Close(); } catch (Exception ex) { string errmsg = ex.Message.ToString(); MessageBox.Show( "error " + errmsg); } txt.Close(); } public StringBuilder ConvertDataTableToCsvFile(DataTable dtData) { StringBuilder data = new StringBuilder(); for ( int column = 0; column { //Making sure that end of the line, shoould not have comma delimiter. if (column == dtData.Columns.Count - 1) data.Append(dtData.Columns[column].ColumnName.ToString().Replace( "," , ";" )); else data.Append(dtData.Columns[column].ColumnName.ToString().Replace( "," , ";" ) + ',' ); } data.Append(Environment.NewLine); //New line after appending columns. for ( int row = 0; row { for ( int column = 0; column { if (column == dtData.Columns.Count - 1) data.Append(dtData.Rows[row][column].ToString().Replace( "," , ";" )); else data.Append(dtData.Rows[row][column].ToString().Replace( "," , ";" ) + ',' ); } if (row != dtData.Rows.Count - 1) data.Append(Environment.NewLine); } return data; } public void SaveData(StringBuilder data, string filePath) { using (StreamWriter objWriter = new StreamWriter(filePath)) { objWriter.WriteLine(data); objWriter.Flush(); } }

James Axsom · Answer

I hope my response provides you a source of inspiration and ideas for a solution. private void btnSubmit_Click( object sender, EventArgs e) { // Method: btnSubmit_Click(object sender, EventArgs e) // Return: none // Create a CSV file using a DataTable data source // Support Variables StringBuilder rowMaker = new StringBuilder(); string filePath = @ "C:\Users\jaxpr\Documents\DataExport.csv" ; // acquire the data DataTable dtProducts = GetDataSource(); // create a stream writer System.IO.StreamWriter swFileAuthor = new System.IO.StreamWriter(filePath); // write columns to the file foreach (DataColumn dc in dtProducts.Columns) { rowMaker.Append(dc.ColumnName); rowMaker.Append( "," ); } // replace last column delimter with row delimiter int rowLength = rowMaker.Length-1; rowMaker.Remove(rowLength, 1); rowMaker.Insert(rowLength, ";" ); // add columns to the file swFileAuthor.WriteLine(rowMaker.ToString()); // write all rows to the file foreach (DataRow dr in dtProducts.Rows) { rowMaker.Clear(); rowMaker.Append(dr[ "BarCode" ]); rowMaker.Append( "," ); rowMaker.Append(dr[ "Location" ]); rowMaker.Append( "," ); rowMaker.Append(dr[ "Quantity" ]); rowMaker.Append( ";" ); swFileAuthor.WriteLine(rowMaker.ToString()); } // close stream writer swFileAuthor.Close(); MessageBox.Show( "File is ready" ); } private DataTable GetDataSource() { // Method: GetDataSource // Return: System.Data.DataTable // Represents a hypothetical call to sql server stored procedure // create a data table from scratch DataTable dtProducts = new DataTable( "Products" ); // Columns dtProducts.Columns.Add( "BarCode" , System.Type.GetType( "System.String" )); dtProducts.Columns.Add( "Location" , System.Type.GetType( "System.String" )); dtProducts.Columns.Add( "Quantity" , System.Type.GetType( "System.String" )); // Populate Table With 5 DataRows // 1st Row DataRow drRow1 = dtProducts.NewRow(); drRow1[ "BarCode" ] = "Code1" ; drRow1[ "Location" ] = "Section 1" ; drRow1[ "Quantity" ] = "2000" ; dtProducts.Rows.Add(drRow1); // 2nd Row DataRow drRow2 = dtProducts.NewRow(); drRow2[ "BarCode" ] = "Code2" ; drRow2[ "Location" ] = "Section 2" ; drRow2[ "Quantity" ] = "5000" ; dtProducts.Rows.Add(drRow2); // 3rd Row DataRow drRow3 = dtProducts.NewRow(); drRow3[ "BarCode" ] = "Code3" ; drRow3[ "Location" ] = "Section 3" ; drRow3[ "Quantity" ] = "8000" ; dtProducts.Rows.Add(drRow3); // 4th Row DataRow drRow4 = dtProducts.NewRow(); drRow4[ "BarCode" ] = "Code4" ; drRow4[ "Location" ] = "Section 4" ; drRow4[ "Quantity" ] = "9000" ; dtProducts.Rows.Add(drRow4); // 5th Row DataRow drRow5 = dtProducts.NewRow(); drRow5[ "BarCode" ] = "Code5" ; drRow5[ "Location" ] = "Section 5" ; drRow5[ "Quantity" ] = "8000" ; dtProducts.Rows.Add(drRow5); return dtProducts; }