Click here to Skip to main content
15,896,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
{"FirstName", "LastName",

"Surya,Vemu", "Chandra", 
"Hari", "p", 
"Surya", "Chandra", 
"Hari", "p", 
"Surya", "Chandra", 
"Hari", "p", 
"Surya", "Chandra", 
"Hari", "p", 
"Surya", "Chandra", 
"Hari", "p", 
"Surya", "Chandra", 
"Hari", "p", 
"vemu,Surya", "Chandra", 
"Hari", "p", 
}


How to convert the above string builder as a format

FirstName LastName


Surya,vemu Chandra
Hari P
Surya Chandra



in CSV File...
Posted
Updated 20-Jun-13 23:37pm
v2
Comments
Thomas Daniels 21-Jun-13 5:43am    
Is that an array?
nandakishoreroyal 21-Jun-13 5:47am    
no its a string builder...

C#
if (objDataTable != null && objDataTable.Rows.Count > 0)
               {
                   StringBuilder sb = new StringBuilder();

                   foreach (DataColumn col in objDataTable.Columns)
                   {
                       sb.Append("\"" + col.ColumnName + "\"" + ", ");

                   }

                   sb.Append(Environment.NewLine);
                   sb.Append(Environment.NewLine);
<pre lang="c#">

foreach (DataRow row in objDataTable.Rows)
{
for (int i = 0; i < objDataTable.Columns.Count; i++)
{
sb.Append("\"" + row[i].ToString() + "\"" + ", ");

}
sb.Append(Environment.NewLine);
}

File.WriteAllText(filename, sb.ToString());
}
 
Share this answer
 
v2
C#
if (objDataTable != null && objDataTable.Rows.Count > 0)
                {
                    StringBuilder sb = new StringBuilder();
                    foreach (DataColumn col in objDataTable.Columns)
                    {
                        sb.Append(Constants.DataQualifierForCSVFile + col.ColumnName + Constants.DataQualifierForCSVFile + ",");
                        sb.Remove(sb.Length - 1, 1);
                    }
                    sb.Append("\r\n");

                    foreach (DataRow row in objDataTable.Rows)
                    {
                        for (int i = 0; i < objDataTable.Columns.Count; i++)
                        {
                            sb.Append(Constants.DataQualifierForCSVFile + row[i].ToString() + Constants.DataQualifierForCSVFile + ",");
                            sb.Remove(sb.Length - 1, 1);
                        }
                        sb.Append("\r\n");

                    }

                    File.WriteAllText(filename, sb.ToString());
                }
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900