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]]

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:
http://datawebcontrols.com/faqs/CustomizingAppearance/CustomizeColumnValue.shtml

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


hth

 

[Paul D. Fox]

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

Paul

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:
http://datawebcontrols.com/faqs/CustomizingAppearance/CustomizeColumnValue.shtml

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


hth


--

Scott Mitchell [ASP.NET MVP]
(e-mail address removed)
http://www.4GuysFromRolla.com/ScottMitchell