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

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 < dtData.Columns.Count; 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 < dtData.Rows.Count; row++)
{
for (int column = 0;
column < dtData.Columns.Count; 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();
}
}

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;
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

James Axsom8y ago
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;
}