sqlcommand parameters with null

  • Thread starter Thread starter gv
  • Start date Start date
G

gv

Is there an easier \ shorter way of doing this?

If txtreason.Text = "" Then
NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value
= vbNull
Else
NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value
= txtreason.Text
End If

thanks
gv
 
You could do it next way

NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = _
IIf(txtreason.Text = "", DBNull.Value, txtreason.Text)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stored Procedure with Output parameter 13
SqlCommand Parameters with SqlDbType and VarChar(MAX) 1
Caching Parameters Performance Issue When Using SQLHELPER 2
The variable name has already been declared error - SQL parameter insert 5
SQL Parameterized insert Problem (variable already declared) 1
expects parameter ??? , which was not supplied." 2
Must declare the scalar variable "@" - paramaterized sqlclient insert - HELP!! 1
Must declare the scalar variable "@" - paramaterized sqlclient insert 4

Back
Top