如何在VB.NET sqlserver中将大写改为大小写 [英] How to change uppercase to propercase in VB.NET sqlserver

问题描述

我想在加载到datagridview时将文本的格式从UpperCase更改为Proper Case，如下图所示。



图片正确案例



我的vb.net代码

I want to change the format of my text from UpperCase to Proper Case when loading to datagridview just like shown in the image below.

Image Proper Case

my vb.net code

Using cmd As New SqlClient.SqlCommand("dbo.uspSELECTALL", cn)
    dgv1.DataSource = Nothing
    da.SelectCommand = cmd
    dt.Clear()
    da.Fill(dt)
    dgv1.RowTemplate.Height = 30
    dgv1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders
    dgv1.ColumnCount = 7
    dgv1.AutoGenerateColumns = False
    dgv1.Columns(0).Name = "Student ID"
    dgv1.Columns(0).DataPropertyName = "StudentID"
    dgv1.Columns(1).Name = "Last Name"
    dgv1.Columns(1).DataPropertyName = ("SurName")
    dgv1.Columns(2).Name = "First Name"
    dgv1.Columns(2).DataPropertyName = ("FirstName")
    dgv1.Columns(3).Name = "Middle Name"
    dgv1.Columns(3).DataPropertyName = "MiddleName"
    dgv1.Columns(4).Name = "Gender"
    dgv1.Columns(4).DataPropertyName = "Gender"
    dgv1.Columns(5).Name = "Birthday"
    dgv1.Columns(5).DataPropertyName = "Birthday"
    dgv1.Columns(6).Name = "Age"
    dgv1.Columns(6).DataPropertyName = "Age"

End Using

SQLSERVER代码

SQLSERVER code

ALTER PROCEDURE [dbo].[uspSELECTALL]
	

AS
BEGIN

	SET NOCOUNT ON;
	SELECT  
			Birthday,getdate() AS [Today],
			Datediff(yy,BirthDay,getdate()) -
			CASE
				WHEN DATEADD(YY, DATEDIFF(YY,BirthDay,getdate()),BirthDay)
				>GETDATE() THEN 1
				ELSE 0
			
			END AS [age],
			StudentID,Surname
			,FirstName,
			MiddleName, 
			Gender,BirthDay,TelNum
			FROM StudentInformation
END

我尝试了什么：



我把正确的功能放到了我的sql server但没有运气。有人可以帮我修改我的代码。任何帮助将非常感谢。谢谢

What I have tried:

I put proper functions to my sql server but no luck. Can someone Help me to fix my codes. any help would be very much appreciated. Thanks

SELECT  
            Birthday,getdate() AS [Today],
            Datediff(yy,BirthDay,getdate()) -
            CASE
                WHEN DATEADD(YY, DATEDIFF(YY,BirthDay,getdate()),BirthDay)
                >GETDATE() THEN 1
                ELSE 0

            END AS [age],
            StudentID,
            PROPER(Surname) AS Surname,
            PROPER(FirstName) AS FirstName,
            PROPER(MiddleName) AS MiddleName,
            Gender,BirthDay,TelNum
            FROM StudentInformation

推荐答案

也许这可以提供帮助：

InitCap / String Capitalization Function [ ^ ]

Maybe that can help:
InitCap / String Capitalization Function[^]

这篇关于如何在VB.NET sqlserver中将大写改为大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！