如何使用CSV将数据值存储在sqlserver中的单行中 [英] How to store array values in sqlserver in single row using CSV

问题描述

先生，
我正在使用microsoft.ink dll进行笔迹合成的一个项目，我有笔触的某些贝塞尔曲线点.
我想使用逗号分隔值在SQL Server单行中存储数组的bezier点集

请向我建议如何操作，之后病房要从CSV(逗号分隔值)中拆分所有期望点以重新生成笔划
请帮助我



感谢和问候
GoogleJumbo

sir,
I am working on one of my project of handwriting synthesis using microsoft.ink dll, i have certain bezier points of the ink stroke
i want store set of bezier points of array in sql server single row using comma separated values

kindly suggest me how to do this , and after wards want to split all desire point from CSV (comma separated values) to regenerate the stroke
kindly help me out



thanks and regards
GoogleJumbo

推荐答案

只需考虑将CSV作为存储在单个列中的字符串类型.将所有这些值作为单独的值发送到数据库服务器并在那里进行串联并不是很有效.拆分也一样，只需在您的C#代码中执行即可.因此它实际上是一个简单的text/ntext或varchar列.

祝你好运！

Just consider the CSV as a string type that you store into a single column. It''s not very efficient to send those values all as separate values to the database server and concatenate them there. The same goes for splitting, just do this in your c# code. So it''s actually a simple text/ntext or varchar column.

Good luck!

这篇关于如何使用CSV将数据值存储在sqlserver中的单行中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！