sb.AppendLine("Employee Id,First Name,Last Name,Email,Username,Password,Role,Group Name,Country Code, Supervisor Id, Hire Date, Birth Date");
for (int i = 0; i < dt.Rows.Count; i )
{
String[] empid = dt.Rows[i]["EmpId"].ToString().Split(new Char[] { '-' });
sb.AppendLine(Convert.ToInt32(empid[0]).ToString("000000") "," dt.Rows[i]["FirstName"] "," dt.Rows[i]["LastName"].ToString().Replace(",", " ")
",," dt.Rows[i]["Email"] ",reward," dt.Rows[i]["Role"] ",CCCC," ",," ",," dt.Rows[i]["EmployeeHireDate"] "," dt.Rows[i]["EmployeeBirthDate"]);
}
電子郵件欄位需要為空，用戶名需要是電子郵件，國家代碼需要為空，主管ID需要為空，
uj5u.com熱心網友回復：
替換此段：
",CCCC," ",," ",,"
有了這個：
",CCCC,,,"
但是使用專用的 csv 庫確實會做得更好，其中在NuGet上有幾個不錯的選擇。
此外，如果您StringBuilder因為聽說它更快而使用它，請記住，更快是相對的。StringBuilder這種作業比字串連接要快，但如果您最終要寫入網路流、檔案或 Web 回應，則使用StreamWriter
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/495907.html