如何 ... [英] How to ...

问题描述

....确定DataColumns的比例和精度？

.... determine DataColumns scale and precision?

推荐答案

嗨Jacek，


基于根据我的理解，你想确定一个表中某个数据列的'b $ b&b规模和精度。


你从Sql Server获取数据吗？


您可以使用SqlDataReader.GetSqlDecimal来获取SqlDecimal对象，然后您可以通过SqlDecimal.Scale和
$ b获得规模和精度。 $ b SqlDecimal.Precision属性。


============================
请在上面提出我的建议并告诉我它是否有助于解决您的

问题。


感谢您的耐心与合作。如果您有任何疑问或

担忧，请随时将其发布在小组中。我正准备等待

的帮助。


祝你好运，

Jeffrey Tan

Microsoft在线合作伙伴支持

安全！ - www.microsoft.com/security

此帖子按原样提供没有保证，也没有授予任何权利。

Hi Jacek,

Based on my understanding, you want to determine a certain datacolumn''s
scale and precision in a table.

Do you get your data from Sql Server?

You may use SqlDataReader.GetSqlDecimal to get SqlDecimal object, then you
may get the scale and precision through SqlDecimal.Scale and
SqlDecimal.Precision properties.

============================
Please apply my suggestion above and let me know if it helps resolve your
problem.

Thank you for your patience and cooperation. If you have any questions or
concerns, please feel free to post it in the group. I am standing by to be
of assistance.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Jeffrey我不知道桌面来源。

我只有一些表和我想

确定列精度和比例

Jeffrey I don''t know the table source.
I just have some table and i would like to
determine column precision and scale

根据我的理解，你想确定一个特定的数据列'<​​br />表格中的比例和精度。

您是从Sql Server获取数据吗？

您可以使用SqlDataReader.GetSqlDecimal来获取SqlDecimal对象，然后您可以
通过SqlDecimal.Scale和SqlDecimal.Precision属性获得规模和精度。

======================= =====
请在上面提出我的建议并告诉我它是否有助于解决您的问题。

感谢您的耐心与合作。如果您有任何疑问或担忧，请随时在小组中发布。我很乐意帮助您。

致以最诚挚的问候，
Jeffrey Tan
Microsoft在线合作伙伴支持
获得安全保障！ - www.microsoft.com/security
此帖子提供就像没有保证，也没有授予任何权利。

Based on my understanding, you want to determine a certain datacolumn''s
scale and precision in a table.

Do you get your data from Sql Server?

You may use SqlDataReader.GetSqlDecimal to get SqlDecimal object, then you
may get the scale and precision through SqlDecimal.Scale and
SqlDecimal.Precision properties.

============================
Please apply my suggestion above and let me know if it helps resolve your
problem.

Thank you for your patience and cooperation. If you have any questions or
concerns, please feel free to post it in the group. I am standing by to be
of assistance.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

您好Jacek，


感谢您的反馈。


您的数据表来自哪里？它来自数据库吗？


我认为您可以使用DataColumn.DataType属性来确定列

类型。只有十进制类型具有比例和精度。如果您的列''

数据类型不是小数，那么您的请求没有意义。


祝你好运，

Jeffrey Tan

Microsoft在线合作伙伴支持

安全！ - www.microsoft.com/security

此帖子按原样提供没有保证，也没有赋予任何权利。

Hi Jacek,

Thanks for your feedback.

Where does your datatable come from? Is it from database?

I think you may use DataColumn.DataType property to determine the column
type first. Only Decimal type has scale and precision. If your columns''
data type is not decimal, then your request makes no sense.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

这篇关于如何 ...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！