Member Avatar for RickCJ7

I have a table that has information of fire departments around the state. I am trying to set up the gridview so that the address is a hyperlink with google maps. For example, In my address column, I have an address such as 745 W Colfax Ave Denver CO 80204, I want to change it so the DataNavigateUrlFormatString would read "https://maps.google.com/maps?q=" + the address with the spaces replaced with a '+' symbol so it would end up being like this 745 W Colfax Ave Denver CO 80204. Here's my ASP.Net code snippet:

<Columns>
    <asp:BoundField DataField="resource" HeaderText="Resource" />
    <asp:BoundField DataField="name" HeaderText="Name" />
    <asp:BoundField DataField="description" HeaderText="Description" />
    <asp:BoundField DataField="kind" HeaderText="Kind" />
    <asp:BoundField DataField="type" HeaderText="Type" />
    <asp:HyperLinkField DataNavigateUrlFields="address" DataNavigateUrlFormatString="https://maps.google.com/maps?q=745+W+Colfax+Ave+Denver+CO+80204" DataTextField="address" HeaderText="Address" />
</Columns>

How do I go about doing this?

Thanks!

  • 2 Contributors
  • 3 Replies
  • 706 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

Two things that come to mind....

DataNavigateUrlFormatString would be ... http://maps.google.com/maps?q={0}. The data will be filled from the DataNavigateUrlFields.

To replace spaces for +, I would handle that part in the SQL query.

Member Avatar for RickCJ7

That seems to work good. I guess Google Maps does not really need the + between each string in the address. Thanks!

Member Avatar for JorgeM

Good to hear. Feel free to mark the thread as solved if you do not need additional help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.