Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 07, 2011 07:07 PM by vinaynagpal
Jul 08, 2008 10:53 AM|LINK
I worked out for google map with ASP.Net / VB.Net. below steps you have to follow,
1. You need to get encrpyted key from google which key for your own website.
2. create a table as below,
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[map]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[map]
CREATE TABLE [dbo].[map] (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[lat] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[lon] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[cid] [numeric](18, 0) NOT NULL ---cid meant centerID
) ON [PRIMARY]
3. Copy below code for map_test.aspx page
4. Below code for map_test.aspx.vb
strmap = strmap +
clsSearch.ConnectionString() ' calling connectionstring function
drResult = SqlHelper.ExecuteReader(clsSearch.t_IncidentStr, CommandType.Text, SQLResult) ' executing sql query by using sql helper class
Please free to ask your queries and if this code is useful for you, kindly post response.
Ajax xml-script Tabstrip
Code sample sql script countries country province Provinces server 2000
.Net FAQ Links
daily Free Code
asp .net ... c# ... SQL
.NET Interview Question
.net interview faqs
.net layered design
Jul 08, 2008 11:34 AM|LINK
i think you should write it as an article or blog...
in that way more people could get advantage of your work
thanks and regards
Jul 08, 2008 04:54 PM|LINK
Thanks for suggestion.
Jul 23, 2008 01:02 PM|LINK
Tell me how to get Encrypted key for our website from google.....
And describe the what the Map table contains and their colums..I am unable to know about that
Thanks In Adv :)
Jul 24, 2008 11:23 AM|LINK
You can get the encrypted key from
you will get unique key for the google map.
the table which i given the post is enough for the map. just copy and paste to create the table.
if it is useful information , pls mark it as ANSWER.
Jul 24, 2008 11:40 AM|LINK
How to fill that Table??
What does lat,lon,Cid Stands for ??
Always DataReader gives empty because there are no rows in Table
How to give a particular locations to find ?? like giving input
I ran your code but i got blank map image with out location :( and some java script error when we are dragging
Please help me in this issue
Jul 25, 2008 06:09 AM|LINK
get the location's longitude and latitude for your place(where you want to point it out n the map) from web
CID which is primary key( not neccessary, it depends on ur requirements)
lat - latitude ( which latitude for your place)
Please post ur code
find the longitude and latitude of the locations from the web ( example :
Jul 25, 2008 06:32 AM|LINK
Thanks a lot for ur help
I jst copied ur code. but its giving one error " We are sorry ,But we dont have maps at this zoom level .Please look broader level"
How to give zoom level ?? Where are giving that in your code??
I instered in Map Table as for ex Hongkong city lat as 22 15 N lat as
114 10 E .. is this fine or any changes??
Jul 25, 2008 07:12 AM|LINK
You must use 22 15N as 22.15 in the coordinates n the table.
mail me firstname.lastname@example.org or i m online.
Sep 10, 2008 06:53 AM|LINK
I got error on
clsSearch , CommandType not declared
let me know...
actually wat it shows..
wat is the use of creating table .
how you store the data...
let me know in detail...