Need to manipulate a column before displaying

[Paul D. Fox]

I am setting a datagrid's Datasource to a Dataset returned from a Web Service. However, I need to manipulate one of the columns. The column being returned is a relative URL, so I need to prefix the column's data with the first part of the URL to make it an Absolute URL. How can I do this so the datagrid column displays this? I'm thinking something like...
dgDatagrid.DataSource = ListAllDocuments.PTDocRetrieve(txtPTFolderID.Text)
dgDatagrid.DataBind()

'************************************************* *******
'strPTReturnURI will have the value http://machineName/server.pt"
'************************************************* *******

'I need to prefix the column with a string from strItem, this of course doesn't work, but you get the idea
strItem = strPTReturnURI & dgDatagrid.Items(6).DataItem
dgDatagrid.Items(6).DataItem() = strItem

Paul

[Scott Mitchell [MVP]]

Paul D. Fox wrote:

> I am setting a datagrid's Datasource to a Dataset returned from a Web
> Service. However, I need to manipulate one of the columns. The column
> being returned is a relative URL, so I need to prefix the column's data
> with the first part of the URL to make it an Absolute URL. How can I do
> this so the datagrid column displays this?

You have a couple of options. One option is to use an ItemTemplate and
call a helper method, passing in the URL field and manipulating it in
your method. You can see this method described in more detail here:
[url]http://datawebcontrols.com/faqs/CustomizingAppearance/CustomizeColumnValue.shtml[/url]

You could also modify the value in the ItemDataBound event. More info at:
[url]http://datawebcontrols.com/faqs/CustomizingAppearance/ConditionalFormatting.shtml[/url]


hth


--

Scott Mitchell [ASP.NET MVP]
[email]mitchell@4GuysFromRolla.com[/email]
[url]http://www.4GuysFromRolla.com/ScottMitchell[/url]

[Paul D. Fox]

Thanks Scott, I already figured out the first approach. However, your
second approach is pretty cool.

Paul

"Scott Mitchell [MVP]" <mitchell@4guysfromrolla.com> wrote in message
news:8bLYe.3463$Ba2.3318@newssvr27.news.prodigy.ne t...

> Paul D. Fox wrote:

>> I am setting a datagrid's Datasource to a Dataset returned from a Web
>> Service. However, I need to manipulate one of the columns. The column
>> being returned is a relative URL, so I need to prefix the column's data
>> with the first part of the URL to make it an Absolute URL. How can I do
>> this so the datagrid column displays this?

>
> You have a couple of options. One option is to use an ItemTemplate and
> call a helper method, passing in the URL field and manipulating it in your
> method. You can see this method described in more detail here:
> [url]http://datawebcontrols.com/faqs/CustomizingAppearance/CustomizeColumnValue.shtml[/url]
>
> You could also modify the value in the ItemDataBound event. More info at:
> [url]http://datawebcontrols.com/faqs/CustomizingAppearance/ConditionalFormatting.shtml[/url]
>
>
> hth
>
>
> --
>
> Scott Mitchell [ASP.NET MVP]
> [email]mitchell@4GuysFromRolla.com[/email]
> [url]http://www.4GuysFromRolla.com/ScottMitchell[/url]