新书推介：《语义网技术体系》
作者：瞿裕忠，胡伟，程龚
   XML论坛     W3CHINA.ORG讨论区     计算机科学论坛     SOAChina论坛     Blog     开放翻译计划     新浪微博  
 
  • 首页
  • 登录
  • 注册
  • 软件下载
  • 资料下载
  • 核心成员
  • 帮助
    		•   Add to Google

    >> Oracle, SQL Server与XML,XML在数据挖掘中的应用, PMML.
    [返回] 中文XML论坛 - 专业的XML技术讨论区 → XML.ORG.CN讨论区 - 高级XML应用 → 『 XML 与 数据库 』 → Access的附件导入XML,XML然后导入Sql server的问题!求救! ◇查看新帖 ◇ 用户列表 ◇

      发表一个新主题  发表一个新投票  回复主题  (订阅本版) 您是本帖的第 6859 个阅读者浏览上一篇主题  刷新本主题   树形显示贴子　浏览下一篇主题
     * 贴子主题： Access的附件导入XML,XML然后导入Sql server的问题!求救! 举报  打印  推荐  IE收藏夹 
       本主题类别:     
     huangdun 帅哥哟，离线，有人找我吗？
      
      
      等级：大一新生
      文章：2
      积分：60
      门派：XML.ORG.CN
      注册：2006/5/28

    姓名：(无权查看)
    城市：(无权查看)
    院校：(无权查看)
    给huangdun发送一个短消息 把huangdun加入好友 查看huangdun的个人资料 搜索huangdun在『 XML 与 数据库 』的所有贴子 引用回复这个贴子 回复这个贴子 查看huangdun的博客楼主
    发贴心情 Access的附件导入XML,XML然后导入Sql server的问题!求救!

    我们做一个单机版和web结合的程序,单机版为Access数据库,Web版为Sql server数据库.
    我用winform把附件读到access数据库(数据类型为OLE)，然后把数据库用DataSet导出为XML(XML附件内容显示的一排字母)
    然后把XMl导入Web程序，用DateSet读,
    我再把XML读到DataSet 的时候没有问题,但是想把附件插入Web的数据库Sql server 时就有问题了，
    这时接受DataSet的附件内容字段都不能接受，用byte[]   sarr   =   System.Text.Encoding.Default.GetBytes(DataSet.Table[0].rows[0]["附件"])也不行
    XML的数据只有string类型阿！那我读到Web 的DataSet的附件内容的类型到底是什么呢？很多方法都不行!
    请高人指点一二!谢谢!

       收藏   分享  
    顶(0)
      




    点击查看用户来源及管理<br>发贴IP：*.*.*.* 2006/5/28 1:31:00
     
     huangdun 帅哥哟，离线，有人找我吗？
      
      
      等级：大一新生
      文章：2
      积分：60
      门派：XML.ORG.CN
      注册：2006/5/28

    姓名：(无权查看)
    城市：(无权查看)
    院校：(无权查看)
    给huangdun发送一个短消息 把huangdun加入好友 查看huangdun的个人资料 搜索huangdun在『 XML 与 数据库 』的所有贴子 引用回复这个贴子 回复这个贴子 查看huangdun的博客第2楼
    发贴心情 
    我是做.net 开发的,而且在DS中没有对应的数据可以转换这个节点:XML中节点如下:

    <附件>PD94bWwgdmVyc2lvbj0iMS4wIiBzdGFuZGFsb25lPSJ5ZXMiPz4NCjxOZXdEYXRhU2V0Pg0KICA85Z+656GA5pWw5o2uPg0KICAgIDxqdW5kYWlzaGk+MDA8L2p1bmRhaXNoaT4NCiAgPC/ln7rnoYDmlbDmja4+DQogIDxyZWNvcmQ+DQogICAgPG51bWJlcj4xMDAwMjU8L251bWJlcj4NCiAgICA8Y21waWQ+MDEwMTwvY21waWQ+DQogICAgPHN5c3RlbXRpbWU+MjAwNi0wNS0yN1QwMDowMDowMC4wMDAwMDAwKzA4OjAwPC9zeXN0ZW10aW1lPg0KICAgIDxhdXRvVHlwZT7liJ3lrqE8L2F1dG9UeXBlPg0KICA8L3JlY29yZD4NCiAgPOS4jeWQiOagvOmhueaKpeWRij4NCiAgICA85a6h5p+lSUQ+MTAwMDI1PC/lrqHmn6VJRD4NCiAgICA85Y2V5L2N5ZCN56ewPuWMl+S6rOaYk+iBlOmAmuenkeaKgOaciemZkOWFrOWPuDwv5Y2V5L2N5ZCN56ewPg0KICAgIDzkuI3lkIjmoLzljZXkvY0+5YyX5Lqs5piT6IGU6YCa56eR5oqA5pyJ6ZmQ5YWs5Y+4PC/kuI3lkIjmoLzljZXkvY0+DQogICAgPOWPl+WuoeafpeaXtumXtD4yMDA2LTA1LTI3VDAwOjAwOjAwLjAwMDAwMDArMDg6MDA8L+WPl+WuoeafpeaXtumXtD4NCiAgICA85a6h5p+l57G75Z6LPuWIneWuoTwv5a6h5p+l57G75Z6LPg0KICAgIDzlj5flrqHmn6XljZXkvY3ku6PooaggLz4NCiAgICA85a6h5p+l5L6d5o2uIC8+DQogICAgPOWuoeafpeaWueW8j+mDqOmXqCAvPg0KICAgIDzpmarlkIzkurrlkZggLz4NCiAgICA85a6h5p+l6aG555uu6YeN6KaB56iL5bqmPuWFs+mUrjwv5a6h5p+l6aG555uu6YeN6KaB56iL5bqmPg0KICAgIDzmj4/lj5kgLz4NCiAgICA85a6h5p+l5Lq65ZGYPmRzYTwv5a6h5p+l5Lq65ZGYPg0KICAgIDzml7bpl7QxPjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv5pe26Ze0MT4NCiAgICA85a6h5p+l57uE6ZW/PmRzYTwv5a6h5p+l57uE6ZW/Pg0KICAgIDzml7bpl7QyPjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv5pe26Ze0Mj4NCiAgICA85Y2V5L2N5Luj6KGoIC8+DQogICAgPOaXtumXtDM+MjAwNi0wNS0yN1QwMDowMDowMC4wMDAwMDAwKzA4OjAwPC/ml7bpl7QzPg0KICAgIDzmlbTmlLnmg4XlhrUgLz4NCiAgICA85Y+X5a6h5Luj6KGoIC8+DQogICAgPOaXtumXtDQ+MjAwNi0wNS0yN1QwMDowMDowMC4wMDAwMDAwKzA4OjAwPC/ml7bpl7Q0Pg0KICAgIDzmlbTmlLnorqTor4Hmg4XlhrUgLz4NCiAgICA85Yab5Luj6KGoPmRzYTwv5Yab5Luj6KGoPg0KICAgIDzml7bpl7Q1PjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv5pe26Ze0NT4NCiAgICA85pW05pS56aqM6K+B5oOF5Ya1IC8+DQogICAgPOWuoeafpee7hOmVvzI+ZHNhPC/lrqHmn6Xnu4Tplb8yPg0KICAgIDzml7bpl7Q2PjIwMDYtNS0yNzwv5pe26Ze0Nj4NCiAgICA85Y+X5a6h6YOo6ZeoPuW8gOWPkemDqDwv5Y+X5a6h6YOo6ZeoPg0KICAgIDzpobnnm64+ZGFzPC/pobnnm64+DQogICAgPOe8luWPtzE+ZGFzPC/nvJblj7cxPg0KICAgIDznvJblj7cyIC8+DQogICAgPOe8luWPtzMgLz4NCiAgPC/kuI3lkIjmoLzpobnmiqXlkYo+DQogIDzotKLliqHotYTph5Hmg4XlhrXooag+DQogICAgPOWuoeafpUlEPjEwMDAyNTwv5a6h5p+lSUQ+DQogICAgPOazqOWGjOi1hOacrCAvPg0KICAgIDzotYTkuqfmgLvpop0gLz4NCiAgICA85Zu65a6a6LWE5LqnIC8+DQogICAgPOenkeeglOWbuuWumui1hOS6p+WOn+WAvCAvPg0KICAgIDznp5HnoJTlm7rlrprotYTkuqflh4DlgLwgLz4NCiAgICA85Zu65a6a6LWE5Lqn5YeA6aKdIC8+DQogICAgPOa1geWKqOi1hOS6pyAvPg0KICAgIDzlrp7mlLbotYTmnKwgLz4NCiAgICA85Zu95pyJ6LWE5pysIC8+DQogICAgPOazleS6uui1hOacrCAvPg0KICAgIDzlhbbku5botYTmnKwgLz4NCiAgICA85Y2V5L2N5oC75pS25YWlIC8+DQogICAgPOWIqea2puaAu+minSAvPg0KICAgIDzmiYDlvpfnqI4gLz4NCiAgICA85YeA5Yip5ramIC8+DQogICAgPOiQpeS4muWIqea2piAvPg0KICAgIDzotYTkuqfotJ/lgLrnjocgLz4NCiAgICA85oC76LWE5Lqn5oql6YWs546HIC8+DQogICAgPOWHgOi1hOS6p+WIqea2pueOhyAvPg0KICAgIDzplIDllK7liKnmtqbnjocgLz4NCiAgICA85rWB5Yqo5q+U546HIC8+DQogICAgPOiOt+WIqeWAjeaVsCAvPg0KICAgIDzlpIfms6ggLz4NCiAgPC/otKLliqHotYTph5Hmg4XlhrXooag+DQogIDzmib/liLbljZXkvY3otYTmoLzlrqHmn6Xlrp7mlr3ooag+DQogICAgPOWuoeafpUlEPjEwMDAyNTwv5a6h5p+lSUQ+DQogICAgPOWNleS9jUlEPjAxMDE8L+WNleS9jUlEPg0KICAgIDzlrqHmn6XlvaLlir8+6YeN6KaBPC/lrqHmn6XlvaLlir8+DQogICAgPOWuoeafpeaXpeacnz4yMDA2LTA1LTI3VDAwOjAwOjAwLjAwMDAwMDArMDg6MDA8L+WuoeafpeaXpeacnz4NCiAgICA85a6h5p+l57uE57uH5Y2V5L2NIC8+DQogICAgPOWPguWKoOWNleS9jSAvPg0KICAgIDzlj4LliqDljZXkvY3kvJrnrb4gLz4NCiAgICA86KOF5Lia5oSP6KeBIC8+DQogICAgPOijheiuoeaEj+ingSAvPg0KICAgIDzljZXkvY3lkI3np7A+5YyX5Lqs5piT6IGU6YCa56eR5oqA5pyJ6ZmQ5YWs5Y+4PC/ljZXkvY3lkI3np7A+DQogICAgPOWNleS9jeS7o+eggT5kc2E8L+WNleS9jeS7o+eggT4NCiAgICA85omA5bGe6YOo6ZeoPuW8gOWPkemDqDwv5omA5bGe6YOo6ZeoPg0KICAgIDzljZXkvY3mgKfotKg+5Zyw5pa55LyB5LiaPC/ljZXkvY3mgKfotKg+DQogICAgPOazleWumuS7o+ihqOS6uiAvPg0KICAgIDzms5Xkurror4Hkuablj7cgLz4NCiAgICA86IGM5YqhIC8+DQogICAgPOiBlOezu+mDqOmXqCAvPg0KICAgIDzlrqHmn6Xnsbvlnos+5Yid5a6hPC/lrqHmn6Xnsbvlnos+DQogICAgPOWNleS9jeWcsOWdgD7ljJfkuqzluILntKvnq7npmaLot68zM+WPt+e+juael+iKseWbrTTlj7fmpbw4Qjwv5Y2V5L2N5Zyw5Z2APg0KICAgIDznlLPor7fljZXkvY3nroDku4sgLz4NCiAgICA86LSo566h5rC05bmz5ZKM6LSo5L+d6IO95YqbIC8+DQogICAgPOe7j+iQpeS/oeiqiSAvPg0KICAgIDzkv53lr4botYTmoLwgLz4NCiAgICA86KOF5aSH6YeH6LSt5Lia5Yqh6YOo6ZeoIC8+DQogICAgPOe9keWdgCAvPg0KICAgIDzpgJrkv6HlnLDlnYA+ZHNhPC/pgJrkv6HlnLDlnYA+DQogICAgPOmCruaUv+e8lueggT5kc2E8L+mCruaUv+e8lueggT4NCiAgICA86IGU57O75Lq6PmRzYTwv6IGU57O75Lq6Pg0KICAgIDzkurrlkZjmgLvmlbAgLz4NCiAgICA85oqA5pyv5Lq65ZGY5oC75pWwIC8+DQogICAgPOiBlOezu+eUteivnT4wMTAtODg1NTA5ODk8L+iBlOezu+eUteivnT4NCiAgICA85rOo5YaM6LWE6YeRIC8+DQogICAgPOi1hOS6p+aAu+minSAvPg0KICAgIDzorr7lpIfmgLvmlbAgLz4NCiAgICA86K6+5aSH5YeA5YC8IC8+DQogICAgPOWNoOWcsOmdouenryAvPg0KICAgIDzlu7rnrZHpnaLnp68gLz4NCiAgICA86LSo6YeP566h55CG5L2T57O76K6k6K+BIC8+DQogICAgPOS8oOecn+WPt+eggT5kc2E8L+S8oOecn+WPt+eggT4NCiAgICA85LiN6Imv6K6w5b2VIC8+DQogICAgPOWuoeafpeebrueahD5kc2E8L+WuoeafpeebrueahD4NCiAgICA85paH5Lu25a6h5p+l5pe26Ze0PjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv5paH5Lu25a6h5p+l5pe26Ze0Pg0KICAgIDzmlofku7blrqHmn6XlhoXlrrkgLz4NCiAgICA8546w5Zy65a6h5p+l5pe26Ze0PjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv546w5Zy65a6h5p+l5pe26Ze0Pg0KICAgIDznjrDlnLrlrqHmn6XlhoXlrrkgLz4NCiAgICA85a6h5p+l5YeG5aSH5pe26Ze0PjIwMDYtMDUtMjdUMDA6MDA6MDAuMDAwMDAwMCswODowMDwv5a6h5p+l5YeG5aSH5pe26Ze0Pg0KICAgIDzpppbmrKHkvJrorq7ml7bpl7Q+MjAwNi0wNS0yN1QwMDowMDowMC4wMDAwMDAwKzA4OjAwPC/pppbmrKHkvJrorq7ml7bpl7Q+DQogICAgPOacq+asoeS8muiuruaXtumXtD4yMDA2LTA1LTI3VDAwOjAwOjAwLjAwMDAwMDArMDg6MDA8L+acq+asoeS8muiuruaXtumXtD4NCiAgICA85a6h5p+l6IyD5Zu0PmRzYTwv5a6h5p+l6IyD5Zu0Pg0KICAgIDzlj5flrqHmn6XljZXkvY3kuLvopoHkurrlkZggLz4NCiAgICA85YW25LuW5Lq65ZGYIC8+DQogICAgPOaDheWGteivtOaYjiAvPg0KICAgIDznjrDlnLror7TmmI4gLz4NCiAgICA85LiN5ZCI5qC86K+05piOIC8+DQogICAgPOWuoeafpee7k+iuuj5kYXM8L+Wuoeafpee7k+iuuj4NCiAgICA85a6h5p+l57uE57uE6ZW/Pua1i+ivlTwv5a6h5p+l57uE57uE6ZW/Pg0KICAgIDzmhI/op4E+ZGFzPC/mhI/op4E+DQogICAgPOacuuWFsz5kc2E8L+acuuWFsz4NCiAgICA85aSH5rOoIC8+DQogICAgPOWvhue6pz7np5jlr4Y8L+Wvhue6pz4NCiAgPC/mib/liLbljZXkvY3otYTmoLzlrqHmn6Xlrp7mlr3ooag+DQogIDzms5XkurrotYTmoLw+DQogICAgPOWuoeafpUlEPjEwMDAyNTwv5a6h5p+lSUQ+DQogICAgPOazleS6uuivgeS5puazqOWGjOWPtyAvPg0KICAgIDzms6jlhozotYTph5HlvIDlip7otYTph5EgLz4NCiAgICA857uP6JCl6IyD5Zu05Lia5Yqh6IyD5Zu0IC8+DQogICAgPOe7hOe7h+acuuaehOS7o+eggSAvPg0KICAgIDzlm73mnInlnJ/lnLDkvb/nlKjor4HnvJblj7cgLz4NCiAgICA85oi/5bGL5omA5pyJ5p2D6K+B57yW5Y+3IC8+DQogICAgPOe7hOe7h+e7k+aehOiuvue9riAvPg0KICA8L+azleS6uui1hOagvD4NCiAgPOiuvuWkh+WunuaWvT4NCiAgICA85a6h5p+lSUQ+MTAwMDI1PC/lrqHmn6VJRD4NCiAgICA85oC75L2T5biD5bGA5LiO5Y2g5Zyw6Z2i56evIC8+DQogICAgPOeUn+S6p+iuvuWkh+WSjOWfuuehgOiuvuaWvSAvPg0KICAgIDzmo4DmtYvorqHph4/orr7lpIcgLz4NCiAgICA855u45YWz6K645Y+vIC8+DQogICAgPOiuvuWkh+aAu+WPsOaVsCAvPg0KICAgIDzorr7lpIfmgLvlip/njocgLz4NCiAgICA86K6+5aSH5Y6f5YC8IC8+DQogICAgPOiuvuWkh+WHgOWAvCAvPg0KICA8L+iuvuWkh+WunuaWvT4NCiAgPOWuoeafpeiusOW9lT4NCiAgICA857yW5Y+3PjY8L+e8luWPtz4NCiAgICA85a6h5p+lSUQ+MTAwMDI1PC/lrqHmn6VJRD4NCiAgICA85pe26Ze0PjIwMDYtMDUtMjdUMjM6MjQ6MTQuMDAwMDAwMCswODowMDwv5pe26Ze0Pg0KICAgIDzlrqHmn6XlhoXlrrk+ZHNhPC/lrqHmn6XlhoXlrrk+DQogICAgPOWvueW6lOagh+WHhuadoeasvj5kc2E8L+WvueW6lOagh+WHhuadoeasvj4NCiAgICA85a6h5p+l6K6w5b2VPmRzYTwv5a6h5p+l6K6w5b2VPg0KICAgIDzkuI3lkIjmoLzmoIforrA+ZHNhPC/kuI3lkIjmoLzmoIforrA+DQogIDwv5a6h5p+l6K6w5b2VPg0KICA85a6h5p+l57uE5oiQ5ZGY6KGoPg0KICAgIDzlrqHmn6VJRD4xMDAwMjU8L+WuoeafpUlEPg0KICAgIDznvJblj7c+MTE8L+e8luWPtz4NCiAgICA85oiQ5ZGY5aeT5ZCNPua1i+ivlTwv5oiQ5ZGY5aeT5ZCNPg0KICAgIDzlt6XkvZzljZXkvY3lj4rogYzliKs+5rWL6K+VPC/lt6XkvZzljZXkvY3lj4rogYzliKs+DQogICAgPOWIhuW3pT7mtYvor5U8L+WIhuW3pT4NCiAgICA85a6h5p+l5ZGY5rOo5YaM6LWE5qC8Pua1i+ivlTwv5a6h5p+l5ZGY5rOo5YaM6LWE5qC8Pg0KICAgIDzor4HkuabnvJblj7c+5rWL6K+VZXdxPC/or4HkuabnvJblj7c+DQogIDwv5a6h5p+l57uE5oiQ5ZGY6KGoPg0KPC9OZXdEYXRhU2V0Pg==</附件>

    点击查看用户来源及管理<br>发贴IP：*.*.*.* 2006/5/28 1:32:00
     
     huangdun 帅哥哟，离线，有人找我吗？
      
      
      等级：大一新生
      文章：2
      积分：60
      门派：XML.ORG.CN
      注册：2006/5/28

    姓名：(无权查看)
    城市：(无权查看)
    院校：(无权查看)
    给huangdun发送一个短消息 把huangdun加入好友 查看huangdun的个人资料 搜索huangdun在『 XML 与 数据库 』的所有贴子 引用回复这个贴子 回复这个贴子 查看huangdun的博客第3楼
    发贴心情 
    自己 顶
    点击查看用户来源及管理<br>发贴IP：*.*.*.* 2006/5/28 21:47:00
     
     sundowner 帅哥哟，离线，有人找我吗？水瓶座1981-1-24
      
      
      等级：大一(高数修炼中)
      文章：12
      积分：108
      门派：XML.ORG.CN
      注册：2006/5/27

    姓名：(无权查看)
    城市：(无权查看)
    院校：(无权查看)
    给sundowner发送一个短消息 把sundowner加入好友 查看sundowner的个人资料 搜索sundowner在『 XML 与 数据库 』的所有贴子 引用回复这个贴子 回复这个贴子 查看sundowner的博客第4楼
    发贴心情 
    OLE字段的存放形式都是二进制流。所以，读出来的都是一串字符流！

    ----------------------------------------------
    qq：272313535

    点击查看用户来源及管理<br>发贴IP：*.*.*.* 2006/7/24 17:07:00
     
     yuhuan 帅哥哟，离线，有人找我吗？
      
      
      等级：大一新生
      文章：3
      积分：71
      门派：XML.ORG.CN
      注册：2006/5/30

    姓名：(无权查看)
    城市：(无权查看)
    院校：(无权查看)
    给yuhuan发送一个短消息 把yuhuan加入好友 查看yuhuan的个人资料 搜索yuhuan在『 XML 与 数据库 』的所有贴子 引用回复这个贴子 回复这个贴子 查看yuhuan的博客第5楼
    发贴心情 
    完全不知道什么来的~~~
    点击查看用户来源及管理<br>发贴IP：*.*.*.* 2006/8/1 11:21:00
     
     GoogleAdSense
      
      
      等级：大一新生
      文章：1
      积分：50
      门派：无门无派
      院校：未填写
      注册：2007-01-01
    给Google AdSense发送一个短消息 把Google AdSense加入好友 查看Google AdSense的个人资料 搜索Google AdSense在『 XML 与 数据库 』的所有贴子 访问Google AdSense的主页 引用回复这个贴子 回复这个贴子 查看Google AdSense的博客广告
    2024/4/28 17:05:20

    本主题贴数5，分页： [1]

    管理选项： 修改tag | 锁定 | 解锁 | 提升 | 删除 | 移动 | 固顶 | 总固顶 | 奖励 | 惩罚 | 发布公告
    W3C Contributing Supporter! W 3 C h i n a ( since 2003 ) 旗 下 站 点
    苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
    		 78.125ms