Conversion from type DBNull to type String is invalid

  • Thread starter Thread starter Michel Vanderbeke
  • Start date Start date
M

Michel Vanderbeke

Hello,

When reading data from a SqlClient.SqlDataReader in VB.NET 2005, I want to
display fiels that sometimes are empty.

sUser = CStr(rdUser("Name") & Space(1) & CStr(rdUser("First_Name")

When the First_Name of a user is empty, I get an error telling me type
DBNull cannot be converted to String.
Is there a way of solving this problem?

Many thanks,

Michel
 
Hello,

When reading data from a SqlClient.SqlDataReader in VB.NET 2005, I want to
display fiels that sometimes are empty.

sUser = CStr(rdUser("Name") & Space(1) & CStr(rdUser("First_Name")

When the First_Name of a user is empty, I get an error telling me type
DBNull cannot be converted to String.
Is there a way of solving this problem?

Many thanks,

Michel
Click to expand...

Instead of:

sUser = CStr(rdUser("Name") & Space(1) & CStr(rdUser("First_Name")

Use:

sUser = rdUser("Name").ToString() & Space(1) & rdUser("First
Name")

or even better (imo):

sUser = String.Format("{0} {1}", rdUser("Name").ToString(),
rdUser("First_Name").ToString())


Thanks,

Seth Rowe
 
Instead of:

sUser = CStr(rdUser("Name") & Space(1) & CStr(rdUser("First_Name")

Use:

sUser = rdUser("Name").ToString() & Space(1) & rdUser("First
Name")

or even better (imo):

sUser = String.Format("{0} {1}", rdUser("Name").ToString(),
rdUser("First_Name").ToString())

Thanks,

Seth Rowe

sUser = rdUser("Name").ToString() & Space(1) & rdUser("First
Name")
Click to expand...

That should be:

sUser = rdUser("Name").ToString() & Space(1) &
rdUser("First_Name").ToString()


Thanks,

Seth Rowe
 
rowe_newsgroups said:
Instead of:

sUser = CStr(rdUser("Name") & Space(1) & CStr(rdUser("First_Name")

Use:

sUser = rdUser("Name").ToString() & Space(1) & rdUser("First
Name")

or even better (imo):

sUser = String.Format("{0} {1}", rdUser("Name").ToString(),
rdUser("First_Name").ToString())
Click to expand...


I am curious why this should be better. In addition, I'd write '... & " " &
....' instead of '... & Space(1) & ...'.
 
I am curious why this should be better. In addition, I'd write '... & " " &
...' instead of '... & Space(1) & ...'.
Click to expand...

I never said it was better - I was referring to String.Format - I too
would use & " ". I just left the code as the OP had it for
consistency.

Thanks,

Seth Rowe
 
Back
Top