,它将返回null
我要做的就是在文本框为空时使用数据库插入null。
--ACCOUNT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET IDENTITY_INSERT account ON
INSERT INTO dbo.account
(
AccntID ,
managedby ,
AccountHolder ,
Description ,
AccountType ,
ContactPerson ,
ContactNumber ,
EmailAddress ,
Address ,
ClientTYpe ,
SchemeType ,
SalesManager ,
DateCreated ,
Login ,
Password ,
Balance ,
FilterOption ,
Enable22 ,
AllowExtendedConfig
)
-- Insert statements for procedure here
VALUES (@AccntID, @managedby, @AccountHolder, @Description, @AccountType, @ContactPerson, @ContactNumber, @EmailAddress, @Address, @ClientType, @SchemeType, @SalesManager, @DateCreated, @Login, @Password, @Balance, @FilterOption, @Enable22, @AllowExtendedConfig)
SET IDENTITY_INSERT account OFF
END
当我的文本框为空时,在数据库中添加零值的最佳方法是什么
设置辅助功能,例如:
Public Function DbNullOrStringValue(ByVal value As String) As Object
If String.IsNullOrEmpty(value) Then
Return DBNull.Value
Else
Return value
End If
End Function
因此,通过调用第一个代码块可以简化:
Cmd.Parameters.AddWithValue("@AccntID", DbNullOrStringValue(TextBox1.Text))
Cmd.Parameters.AddWithValue("@managedby", DbNullOrStringValue(TextBox2.Text))
Cmd.Parameters.AddWithValue("@AccountHolder", DbNullOrStringValue(TextBox3.Text))
Cmd.Parameters.AddWithValue("@Description", DbNullOrStringValue(TextBox4.Text))
Cmd.Parameters.AddWithValue("@AccountType", DbNullOrStringValue(TextBox5.Text))
Cmd
是您的SqlCommanad
对象
考虑比新方法更轻的东西:
Cmd.Parameters.AddWithValue("@AccntID", IIF(String.IsNullOrEmpty(TextBox1.Text), DBNull.Value, TextBox1.Text))
但是,在其余的情况下,请按照以前建议使用SqlDataAdapter
。
最好的方法是继承的文本框,并向它添加其他功能
Public Class MyText
Inherits TextBox
'Either change default text property (but this will bug you while comparing text property)
Public Overrides Property Text() As String
Get
Return MyBase.Text
End Get
Set(ByVal value As String)
MyBase.Text = value
End Set
End Property
'Best way will be to write new property to use in sql query
Public ReadOnly Property TextSQL() As String
Get
If Me.Text = String.Empty Then
Return "NULL"
Else
Return Me.Text
'Return "'" & Me.Text & "'" 'or this
End If
End Get
End Property
End Class
现在在您的应用程序中使用此文本框
cmd.Parameters.AddWithValue("@accountholder", txt_accHolder.TextSQL)
在存储过程中,您可以使用以下:
假设:参数名称为@TextData
NULLIF(LTRIM(RTRIM(@TextData)),'')
如果@textdata =''。