如何在asp.net上显示大写字母到普通字母 [英] How to show from capital letter to Normal letter on asp.net

问题描述

数据库中的所有名称都是大写字母。例如：公司详情。





但我需要在网站上显示公司详细信息。是否有可能？

我们可以获得公司详细信息。有可能吗？

all Name in database is in caps letter. for ex: COMPANY DETAILS.


but i need to show in website like Company Details. is it possible?
can we get like Company Details. Is it possible?

推荐答案

您可以使用与.ToUpper或.ToLower相同的.ToTitleCase方法

You can use the .ToTitleCase Method same as you use .ToUpper or .ToLower

如果你想要在 SQL 中执行此操作，没有直接的方法来执行此操作。但是通过创建函数的帮助，您可以实现这一目标。要了解更多细节，请参阅此处，



http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert -text-string-to-title-case-proper-case / [ ^ ]

http://stackoverflow.com/questions/16458112/change-lower-case- to-upper-title-case-using-sql-query [ ^ ]

If you wanted to do this in SQL there is no straight way to do this. But by the help of creating Functions you can achieve this. To know more in details refer here,

http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case/[^]
http://stackoverflow.com/questions/16458112/change-lower-case-to-upper-title-case-using-sql-query[^]

请访问此链接



http://stackoverflow.com/questions/1206019/converting-string-to-title-case-in-c-sharp [ ^ ]

这篇关于如何在asp.net上显示大写字母到普通字母的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！