none
保存数据到sqlserver的xml型字段,出现_x000D_的问题 RRS feed

  • 问题

  • 保存到sqlserver的xml型字段,出现_x000D_,如下
    <NewDataSet><Table1><帐号>1111111111</帐号><姓名>kkll</姓名><金额_x000D_>6666.....

    请问是怎么回事,数据是先把excel数据粘贴到文本框中,然后再导入到datatable中。还有我发现只要是最后一列就会有该问题,是不是换行的问题
    2010年10月26日 9:24

全部回复

  • x000d是换行符

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    2010年10月26日 21:51
    版主
  • x000d是换行符

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP

    怎么去掉呢,我用replace好像去不掉啊
    2010年10月27日 0:05
  • 呃,去掉干什么?不去掉的话,读出来的Dataset内容有问题么?

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    2010年10月27日 0:33
    版主