Default NULL parameter

[martin]

Hi,

I am using vb.net and I would like to define one of my function parameters
to have a default value of null (in this case an sqltranaction object)

however I am having a great deal of trouble doing this.

my (incorrect) function declaration is below and I would appreciate somebody
pointing out my error.

Public Function EnterPractice(ByVal strPracticeName As String, ByVal
strUserName As String, ByVal objTran As SqlTransaction = dbnull) As Integer
Also, how would I explicitly pass a null argument to the function.

many thnaks in advance.

martin.

[Steve C. Orr [MVP, MCSD]]

Try this:
Public Function EnterPractice(ByVal strPracticeName As String, ByVal
strUserName As String, Optional ByVal objTran As SqlTransaction = Nothing)
As Integer

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"martin" <St**************@yahoo.com> wrote in message
news:uQ*************@TK2MSFTNGP10.phx.gbl...

Hi,

I am using vb.net and I would like to define one of my function parameters
to have a default value of null (in this case an sqltranaction object)

however I am having a great deal of trouble doing this.

my (incorrect) function declaration is below and I would appreciate somebody pointing out my error.

Public Function EnterPractice(ByVal strPracticeName As String, ByVal
strUserName As String, ByVal objTran As SqlTransaction = dbnull) As Integer

Also, how would I explicitly pass a null argument to the function.

many thnaks in advance.

martin.

[Hans Kesting]

"martin" <St**************@yahoo.com> wrote in message news:uQ*************@TK2MSFTNGP10.phx.gbl...

Hi,

I am using vb.net and I would like to define one of my function parameters
to have a default value of null (in this case an sqltranaction object)

however I am having a great deal of trouble doing this.

my (incorrect) function declaration is below and I would appreciate somebody
pointing out my error.

Public Function EnterPractice(ByVal strPracticeName As String, ByVal
strUserName As String, ByVal objTran As SqlTransaction = dbnull) As Integer

I have no experience with vb.net, but I guess you need "DBNull.Value" here.
(DBNull is the class, DBNull.Value is an ("the") instance)
Also, how would I explicitly pass a null argument to the function.

Just write "null" as the argument (by the way: "null" is NOT equal to "DBNull.Value")

Integer res = EnterPractice("thePracticeName", "theUserName", null)

(or should the C# "null" be translated in vb as "Nothing" ??)
many thnaks in advance.

martin.

[Martin]

Thanks guys

cheers

martin
"Hans Kesting" <ne***********@spamgourmet.com> wrote in message
news:uE**************@TK2MSFTNGP10.phx.gbl...

"martin" <St**************@yahoo.com> wrote in message news:uQ*************@TK2MSFTNGP10.phx.gbl...

Hi,

I am using vb.net and I would like to define one of my function parameters to have a default value of null (in this case an sqltranaction object)

however I am having a great deal of trouble doing this.

my (incorrect) function declaration is below and I would appreciate somebody pointing out my error.

Public Function EnterPractice(ByVal strPracticeName As String, ByVal
strUserName As String, ByVal objTran As SqlTransaction = dbnull) As Integer

I have no experience with vb.net, but I guess you need "DBNull.Value"

here. (DBNull is the class, DBNull.Value is an ("the") instance)

Also, how would I explicitly pass a null argument to the function.

Just write "null" as the argument (by the way: "null" is NOT equal to

"DBNull.Value")
Integer res = EnterPractice("thePracticeName", "theUserName", null)

(or should the C# "null" be translated in vb as "Nothing" ??)

many thnaks in advance.

martin.