9 Replies - 1095 Views - Last Post: 25 June 2013 - 01:51 PM Rate Topic: -----

#1 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 11:09 AM

I'm very new to ASP.NET and tried to learn it last week, since I learned my company uses IIS. I've done a lot of research and attempts to get this working, but I end up unsure of what to do because of how asp.net is.

I have IIS installed, downloaded VS Express for Web 2012, and looked at many tutorials. I was hoping for an out-of-the-box solution since many of these tutorials were downloadable, but I kept getting errors in web.config. W3schools doesn't cover web.config (it probably does, but I couldn't find it) and VS Express automatically creates its web.config. I wasn't afraid of messing with web.config, but now it can't find a Sql connection.

My question is what are the steps I should take to get a working Google Maps with database markers. I want to use a test database of 200 rows and use odbc to talk to it.

Is This A Good Question/Topic? 0
  • +

Replies To: I'm lost- Want to get a working Google Maps with database markers

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9287
  • View blog
  • Posts: 34,808
  • Joined: 12-June 08

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 11:18 AM

You need to format the data to shove it towards google.

Look at this guy's formatting:

https://www.informit...679546&seqNum=7

http://www.aspdotnet...-on-google.html
Was This Post Helpful? 0
  • +
  • -

#3 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 11:37 AM

That second one is actually the last one I tried before I gave up. My problem is not really Google's API. It's the database I need and figure out, along with using asp.net to import it.

Asp.net's the big hassle for me in this. When I tried php, I used XAMPP's phpmyadmin and AJAX jQuery to import my coordinates. For ASP.net, I'm not even sure how to load a database from anywhere. I do know how to manually create one if I used VS Express.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9287
  • View blog
  • Posts: 34,808
  • Joined: 12-June 08

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 11:40 AM

Okay.. so what - just pulling data back is a problem? What's the database? Which flavor of ASP.NET are you using? C# or VB.NET? It should be a pretty straight forward 'code behind' method that creates your SQL objects, uses the connection string form the webconfig, queries the DB with a SELECT statement, and shoves the results in a dataset.
Was This Post Helpful? 0
  • +
  • -

#5 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 11:59 AM

I'm not sure what database. I was hoping odbc would be open ended enough to let me to use any database I wanted, including a mysql database. I don't have the database right now, just a excel sheet to work with. I'm open to using any flavor, but webforms seem to be the easiest one for me. I'm gonna be learning C# in the future, so C#.
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9287
  • View blog
  • Posts: 34,808
  • Joined: 12-June 08

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 12:05 PM

Okay.. so let's work with saying you will be using a MYSQL database, C#, and some sort of webform. Here's some examples of database interaction with C# forms.. it's a similar process of having a page access a db on the same server!


http://www.dreaminco...a-mysql-server/
http://www.dreaminco...iew-using-c%23/
http://www.dreaminco...e__hl__database
Was This Post Helpful? 0
  • +
  • -

#7 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 12:07 PM

Well, like I said. I'm lost. I don't know how to get started with the 'code behind' and I don't have the database.

EDIT: Whoops. Ignore this message. Gonna read those links.

This post has been edited by Emwat Oon: 25 June 2013 - 12:08 PM

Was This Post Helpful? 0
  • +
  • -

#8 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 469
  • View blog
  • Posts: 3,199
  • Joined: 12-January 10

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 12:25 PM

To actually use google maps correctly as a mapping system you need to pay google for the rights to use it. costs about $5k
Was This Post Helpful? 0
  • +
  • -

#9 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 12:33 PM

For my purposes, it's only for testing and evaluation for right now. I'm not the go-to person on this subject though.
Was This Post Helpful? 0
  • +
  • -

#10 Emwat Oon  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 54
  • Joined: 07-January 12

Re: I'm lost- Want to get a working Google Maps with database markers

Posted 25 June 2013 - 01:51 PM

I feel reluctant to go down that route. I did try to install MySql. Thought I did, since it said MySql Server in the installation. But now I'm tackling more problems.

I've done a lot of downloading today and got little progress.

I'm gonna try... versing around VS Express one more time and look up some books for more help on the issue. With everything that's been bundled with VS Express for Web, there's gotta be some solution I didn't see before.

EDIT: I'll be back on the forum tomorrow. Thank you for your time and patience.

This post has been edited by Emwat Oon: 25 June 2013 - 01:51 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1