Conversion from type DBNull to type String is invalid

[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

[rowe_newsgroups]

On May 15, 10:33 am, "Michel Vanderbeke" <[e-mail]>
wrote:

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

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

[rowe_newsgroups]

On May 15, 10:56 am, rowe_newsgroups <[e-mail]:

On May 15, 10:33 am, "Michel Vanderbeke" <[e-mail]>
wrote:

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

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")

That should be:

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

Seth Rowe

[Herfried K. Wagner [MVP]]

"rowe_newsgroups" <ro********@yahoo.comschrieb:

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())

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

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[rowe_newsgroups]

On May 15, 4:32 pm, "Herfried K. Wagner [MVP]" <hirf-spam-me-
[e-mail]:

"rowe_newsgroups" <[e-mail]:

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())

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

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

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