Insert Null Value

[RN1]

How do I insert NULL values in a SQL Server DB table in a column whose
datatype is int? This is what I am trying currently (in the
UpdateCommand event function of a DataGrid):

----------------------------
Dim strSQL As String
Dim objErrorPercentage As Object

If (CType(ea.Item.Cells(8).Controls(0), TextBox).Text = "") Then
objErrorPercentage = DBNull.Value
Else
objErrorPercentage = CType(ea.Item.Cells(8).Controls(0),
TextBox).Text
End If

strSQL = "UPDATE Table1 SET.......ErrorPerc = " & objErrorPercentage &
".....WHERE....."
----------------------------

But the above generates the "Incoorrect syntax" error if the TextBox
is empty.

[Alexey Smirnov]

On Oct 12, 2:28*pm, RN1 <[e-mail]:

How do I insert NULL values in a SQL Server DB table in a column whose
datatype is int? This is what I am trying currently (in the
UpdateCommand event function of a DataGrid):

----------------------------
Dim strSQL As String
Dim objErrorPercentage As Object

If (CType(ea.Item.Cells(8).Controls(0), TextBox).Text = "") Then
* * objErrorPercentage = DBNull.Value
Else
* * objErrorPercentage = CType(ea.Item.Cells(8).Controls(0),
TextBox).Text
End If

strSQL = "UPDATE Table1 SET.......ErrorPerc = " & objErrorPercentage &
".....WHERE....."
----------------------------

But the above generates the "Incoorrect syntax" error if the TextBox
is empty.

1. Be careful with the sql injections.

2. If (CType(ea.Item.Cells(8).Controls(0), TextBox).Text = "") Then
objErrorPercentage = "NULL"

[Riki]

RN1 wrote:

How do I insert NULL values in a SQL Server DB table in a column whose
datatype is int? This is what I am trying currently (in the
UpdateCommand event function of a DataGrid):

----------------------------
Dim strSQL As String
Dim objErrorPercentage As Object

If (CType(ea.Item.Cells(8).Controls(0), TextBox).Text = "") Then
objErrorPercentage = DBNull.Value
Else
objErrorPercentage = CType(ea.Item.Cells(8).Controls(0),
TextBox).Text
End If

strSQL = "UPDATE Table1 SET.......ErrorPerc = " & objErrorPercentage &
".....WHERE....."
----------------------------

But the above generates the "Incoorrect syntax" error if the TextBox
is empty.

1) See Alexey's response
2) Use parameters instead of string concatenation:
strSQL = "UPDATE Table1 SET.......ErrorPerc =
@ParamErrorPerc.....WHERE....."
and
myCommand.Parameters.AddValue("ParamErrorPerc", objErrorPercentage)

--

Riki