Add "/t" after the data or escape with/R
Ends.write (retreader["Statis_dt"]. ToString () +","); Ends.write (retreader["Branchcode"]. ToString () +","); Ends.write (retreader["Organcode"]. ToString () +","); Ends.write (retreader["Iou_no"]. ToString () +"/t,"); Ends.write (retreader["Contract_no"]. ToString () +"/t,"); Ends.write (retreader["Repay_term_no"]. ToString () +","); Ends.write (retreader["Plan_repay_dt"]. ToString () +","); Ends.write (retreader["Act_repay_dt"]. ToString () +","); Ends.write (retreader["Repay_capital"]. ToString () +","); Ends.write (retreader["Loan_bal"]. ToString () +","); Ends.write (retreader["Next_term_repay_capital"]. ToString () +","); Ends.write (retreader["Repay_status"]. ToString () +","); Ends.write (retreader["Inserttime"]. ToString () +",");
private void Writedatalines (StreamWriter StreamWriter)
{
foreach (DataRow DataRow in _datatable.rows)
{
foreach (DataColumn DataColumn in _datatable.columns)
{
WriteValue (StreamWriter, Datarow[datacolumn.columnname]. ToString () + "\ r");
}
Streamwriter.writeline ();
}
}
Ends.write (Ends.newline);
Writing data to a CSV file-a "scientific notation" issue