replace '

[Mike]

I'm getting a data set returned from a web service and populating a datalist
on my page. There are times that a dataitem has ' in it (ex: car's, truck's,
etc), how can I remove the ' from the words?

instead of seeing car's i want to see cars, trucks, etc.
in VB.NET

[Jeff Dillon]

Use the Replace function:

dim strTest as string = "g't"

strTest = Replace(strTest, "'", "")

msgbox strTest

"Mike" <Mi**@discussions.microsoft.com> wrote in message
news:14**********************************@microsof t.com...

I'm getting a data set returned from a web service and populating a datalist on my page. There are times that a dataitem has ' in it (ex: car's, truck's, etc), how can I remove the ' from the words?

instead of seeing car's i want to see cars, trucks, etc.
in VB.NET

[Tampa .NET Koder]

Well, of course you would have to loop throught each row value in the dataset
and use the replace function on those values. I just wanted to make sure
that is pointed out.

"Jeff Dillon" wrote:

Use the Replace function:

dim strTest as string = "g't"

strTest = Replace(strTest, "'", "")

msgbox strTest

"Mike" <Mi**@discussions.microsoft.com> wrote in message
news:14**********************************@microsof t.com...

I'm getting a data set returned from a web service and populating a

datalist

on my page. There are times that a dataitem has ' in it (ex: car's,

truck's,

etc), how can I remove the ' from the words?

instead of seeing car's i want to see cars, trucks, etc.
in VB.NET

[Amar]

Hi,

Instead of doing that for every row, SQL Server can do this for you.
Modify your select statement of the dataset from what is now eg.

Select col1 from table1 (col1 is the column with the data like "car's"
to
Select replace(col1,char(61),'') from table1
char(61) is the "'"

"Tampa .NET Koder" <Ta***********@discussions.microsoft.com> wrote in message news:<2C**********************************@microso ft.com>...

Well, of course you would have to loop throught each row value in the dataset
and use the replace function on those values. I just wanted to make sure
that is pointed out.

"Jeff Dillon" wrote:

Use the Replace function:

dim strTest as string = "g't"

strTest = Replace(strTest, "'", "")

msgbox strTest

"Mike" <Mi**@discussions.microsoft.com> wrote in message
news:14**********************************@microsof t.com...

I'm getting a data set returned from a web service and populating a datalist on my page. There are times that a dataitem has ' in it (ex: car's, truck's, etc), how can I remove the ' from the words?

instead of seeing car's i want to see cars, trucks, etc.
in VB.NET