导出Excel的数值不正确

[ttg520]

下面是导出代码:
protected void btnOut_Click(object sender, EventArgs e)
{
int i = 1;
string orderType = string.Empty;
DataTable dt = (DataTable)Session["pageDataTable"];
StringWriter sw = new StringWriter();
sw.WriteLine("序号\t开户人\t开户账号\t开户银行");
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(i + "\t" + dr["AccountName"].ToString() + "\t" + dr["AccountNo"].ToString() + "\t" + dr["BankName"].ToString());
i++;
}
BankBind bankBind = new BankBind();
bankBind.update();
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{

}
但是dr["AccountNo"].ToString()这列 是用科学计数法 后面三位都变成0了 怎么改程序才行啊 不让他显示科学计数法

[孟子E章]

可参考
http://dotnet.aspx.cc/article/8a4cbf47-b888-4832-3389-ed3a3a3c8aab/read.aspx

例子
http://dotnet.aspx.cc/Exam/OutPutExcel.aspx

[BearRui]

try:

Convert.ToDouble(dr["AccountNo"]).ToString("#0.##");

[ttg520]

BearRui(AK-47)(奋斗目标:农妇,山泉,有点田)

导出来之后是这样了:'512,121,554,122,789,000
数据是这样的:512121554122788554