Adding Oracle parameter in an If statement not working

Question

This question branches off of my last question located here

I can now add multiple parameters to my query but my next issue is that I am trying to add my parameter based on the checked status of my checkbox

Here's my code

OracleConn.Open()
OracleCommand = OracleConn.CreateCommand()
OracleCommand.BindByName = True
OracleCommand.CommandText = "UPDATE db SET column1 = :param1 WHERE column2 = :param2"
OracleCommand.CommandType = CommandType.Text
OracleCommand.Parameters.Add(New OracleParameter("param1", "1234"))

If cbCheckbox1.Checked = True Then
    OracleCommand.Parameters.Add(New OracleParameter("param2", "Y"))
Else
    OracleCommand.Parameters.Add(New OracleParameter("param2", "N"))
End If

OracleCommand.ExecuteNonQuery()

It doesn't error but it doesn't update the database either

If I take the If statement out and only have one parameter in like this

OracleCommand.Parameters.Add(New OracleParameter("param2", "Y"))

Then it works fine

Is there something i'm doing wrong?

Any ideas?

@Dan it doesn't throw an error it does nothing at all but if I take the `If` statement out then it runs fine — Jamie Taylor, May 19 '11 at 16:00
Do you mean you remove the if block and replace it with just the parameter adding line? Which one? — System Down, May 19 '11 at 16:13
If I remove the If block and replace it with either parameter adding line then it works — Jamie Taylor, May 19 '11 at 16:35

score 0 · Accepted Answer · answered May 20 '11 at 14:17

0

I solved this by wrapping my checkbox databind in a If Not Page.IsPostBack and that fixed the problem

answered May 20 '11 at 14:17

Jamie Taylor

3,500
21
65
99

Adding Oracle parameter in an If statement not working

1 Answers1