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

On May 15, 10:33 am, "Michel Vanderbeke" <michel.vanderb...@skynet.be>
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

On May 15, 10:56 am, rowe_newsgroups <rowe_em...@yahoo.com> wrote:
> On May 15, 10:33 am, "Michel Vanderbeke" <michel.vanderb...@skynet.be>
> 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

"rowe_newsgroups" <(E-Mail Removed)> schrieb:
> 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/>

On May 15, 4:32 pm, "Herfried K. Wagner [MVP]" <hirf-spam-me-
h...@gmx.at> wrote:
> "rowe_newsgroups" <rowe_em...@yahoo.com> schrieb:
>
> > 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