Conversion from type DBNull to type String is invalid

[Michel Vanderbeke]

Hello,

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

sUser = CStr(rdUser("Na me") & Space(1) & CStr(rdUser("Fi rst_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" <michel.vanderb [e-mail]>
wrote:

Hello,

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

sUser = CStr(rdUser("Na me") & Space(1) & CStr(rdUser("Fi rst_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("Na me") & Space(1) & CStr(rdUser("Fi rst_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_N ame").ToString( ))
Thanks,

Seth Rowe

[rowe_newsgroups]

On May 15, 10:56 am, rowe_newsgroups <rowe_em...@yah oo.comwrote:

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

Hello,

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

sUser = CStr(rdUser("Na me") & Space(1) & CStr(rdUser("Fi rst_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("Na me") & Space(1) & CStr(rdUser("Fi rst_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_N ame").ToString( ))

Thanks,

Seth Rowe

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

That should be:

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

Seth Rowe

[Herfried K. Wagner [MVP]]

"rowe_newsgroup s" <ro********@yah oo.comschrieb:

Instead of:

sUser = CStr(rdUser("Na me") & Space(1) & CStr(rdUser("Fi rst_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_N ame").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] e:

"rowe_newsgroup s" <rowe_em...@yah oo.comschrieb:

Instead of:

sUser = CStr(rdUser("Na me") & Space(1) & CStr(rdUser("Fi rst_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_N ame").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