|
I am trying to display markers held on a database on a google map, using VB.Net in aspx page. I am stuck with how to call the google map function from within the VB.Net code in the body of the aspx page. Can anyone help?
My code is:
<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="mapmysql.aspx.vb" Inherits="mapmysql" %>
<title>Untitled Page
//<![CDATA[
var map = new GMap2(document.getElementById("map"));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GScaleControl());
map.setCenter(new GLatLng(50.614, -3.591 ), 8);
// Creates a marker whose info window displays the given number
function createMarker(point, number)
{
var marker = new GMarker(point);
// Show this markers index in the info window when it is clicked
var html = number;
GEvent.addListener(marker, "click", function() {marker.openInfoWindowHtml(html);});
return marker;
};
//]]>
<% Dim conn As SqlConnection
conn = New SqlConnection("Data Source=beish2;Initial Catalog=HA4;Integrated Security=True")
conn.Open()
Dim sqlComm As New SqlCommand("SELECT PlaceID,PlaceName, PlaceLat, PlaceLng FROM Places ORDER BY PlaceName", conn)
Dim r As SqlDataReader = sqlComm.ExecuteReader()
While r.Read()
Dim username As String = CStr(r("PlaceName"))
Dim userID As Integer = CInt(r("PlaceID"))
Dim Lat As Double = CDbl(r("PlaceLat"))
Dim Lng As Double = CDbl(r("PlaceLng"))
****HOW TO CALL FUNCTION createMarker FROM HERE???? ****
Response.Write(Lat)
End While
r.Close()%>
|
|
|
|
|
|
Added this to try and re-centre map as test but nothing seems to happen - code must be in-correct but can't work out what is wronG. Anyone any ideas
Dim sb As StringBuilder = New StringBuilder
sb.Append("")
sb.Append("//<![CDATA[" & vbCrLf)
sb.Append("map.setCenter(new GLatLng(50.952803, -4.139785 ),9);")
sb.Append("//]]>")
sb.Append("")
ClientScript.RegisterClientScriptBlock(Me.GetType(), "sbf", sb.ToString())
|
|
|
|
|
I suspect you're going to have an order of operations problem here. When does this get called ? I'd say it probably gets called before your map is initialised.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
My complete code is below - I think the processes are in the correct order as the Response.Write(Lat) produces the latitude values from the database after the opening Google Map is displayed. If I move the map.addControl lines to the sb.append stringbuilder, they don't display - which would seem to indicate that the ClientScript.RegisterClientScriptBlock is incorrectly formatted, or the Stringbuilder. Not sure of what the "Type" is supposed to be or if the random name "sbf" I've given it should be something more specific.
<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="mapmysql.aspx.vb" Inherits="mapmysql" %>
<title>Untitled Page
//<![CDATA[
var map = new GMap2(document.getElementById("map"));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GScaleControl());
map.setCenter(new GLatLng(51.512161, -0.14110), 11);
// Creates a marker whose info window displays the given number
function createMarker(point, number)
{
var marker = new GMarker(point);
// Show this markers index in the info window when it is clicked
var html = number;
GEvent.addListener(marker, "click", function() {marker.openInfoWindowHtml(html);});
return marker;
};
//]]>
<% Dim conn As SqlConnection
conn = New SqlConnection("Data Source=beish2;Initial Catalog=HA4;Integrated Security=True")
conn.Open()
Dim sqlComm As New SqlCommand("SELECT PlaceID,PlaceName, PlaceLat, PlaceLng FROM Places ORDER BY PlaceName", conn)
Dim r As SqlDataReader = sqlComm.ExecuteReader()
While r.Read()
Dim username As String = CStr(r("PlaceName"))
Dim userID As Integer = CInt(r("PlaceID"))
Dim Lat As Double = CDbl(r("PlaceLat"))
Dim Lng As Double = CDbl(r("PlaceLng"))
Dim sb As StringBuilder = New StringBuilder
sb.Append("")
sb.Append("//<![CDATA[" & vbCrLf)
sb.Append("map.setCenter(new GLatLng(50.952803, -4.139785 ),9);")
sb.Append("//]]>")
sb.Append("")
ClientScript.RegisterClientScriptBlock(Me.GetType(), "sbf", sb.ToString())
Response.Write(Lat)
End While
r.Close()%>
|
|
|
|
|
Does the ClientScript.RegisterClientScriptBlock actually run the process or just "register" it for calling later?
|
|
|
|
|
Dear All,
I'm implementing a system add on using framework 1.1 and vb.net as a language
The requirement is to build "Outlook-Like" mailbox
I want to create three frames, left frame for the tree, top-right frame to display the incoming or outgoing messages, and bottom-right frame to display mail item content.
All that is doable but i guess my problems will start when i'm doing grouping, filtering, and changing icons for the tree items and same issues for the top-right frame. U know the group by sender,date,or flags
I want it to be fully customizable by the user.
So... What methods do u advice me to do,? what controls should i use (for the tree and grouper)? and what are the suggestions and advices that i need to know?
I would appreciate it alot 
Best Regards
3ala2
|
|
|
|
|
1) Use .NET Framework 2.0. Starting a new project using outdated technology is beyond reason.
2) Use C#. There are many more examples and toolsets build in C# than VB.net
3) Use third-party controls, such as, Component One, Telerik, etc. for the tree. They have already done the hard part.
4) Use Ajax
5) Don't use frames. Use divs and IFrames. Bring up GMail and use IE Developer Toolbar to see how they have made use these.
only two letters away from being an asset
|
|
|
|
|
hi friend's
i want to design a page that contain a flow window.
so i need to write a function with javascript when the element such as div has dragged,but i can't it.please tell me how do it!!!!!!!!!
thank you
msma
|
|
|
|
|
If you are using ASP.NET Ajax, it already supports Cross-browser drag and drop functionality.
I have tried http://wiki.script.aculo.us/scriptaculous/show/DragAndDrop and altas (previous version of ASP.NET Ajax [ check-out (here) if you need sample for Atlas ] ) in some of my projects. I was pretty happy with those libs.
Google it[^] for more example.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
Have you tried to search for it, there are plenty of examples for javascript drag and drop.
only two letters away from being an asset
|
|
|
|
|
Hi All,
I have some records stored sql 2000 server.
want to display a particular members record....and want to give option for members to edit and update their Records by using a datalist.....am using VS2000 and asp.net with c#(.NET1.1)......Kindly help me to solve my problem...
Thanks in advance
Bijesh
|
|
|
|
|
|
|
Hey All,
I have an app that is requesting and scraping a static html page and have just realised that the machine that it is going to be hosted on is running the site under medium trust (which is not negotiable). So now i have a whole lot of scraping stuff happening, but can no longer make the http request without a security exception on the production server.
The current code making the request is:
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url);
HttpWebResponse response;
try{
response = (HttpWebResponse)request.GetResponse();
}
catch(Exception ex){
throw new InvalidOperationException("Could not retrieve requested page.",ex);
}
....then reading the stream in and putting into a string for use.
Does anyone know of a way to make a request for a static html page on another site without running into security problems?
Thanks
|
|
|
|
|
Good day everybody...
I am facing this problem I tried to solve it, but I couldn't. I tried to selete some parameters and add , but all my tries failed. If any body could help me with it.
"ObjectDataSource 'ODSIPAddress' could not find a non-generic method 'UpdateQuery' that has parameters: OrgCode, Original_OrgCode, original_IPAddress."
Thanks a lot.
|
|
|
|
|
constring = System.Configuration.ConfigurationManager.AppSettings["conString"];
con = new SqlConnection(constring);
Label Label1 = (Label)GridView1.Rows[e.RowIndex].Cells[0].FindControl("Label1");
TextBox txtFname = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].FindControl("txtFname");
TextBox txtLname = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].FindControl("txtLname");
TextBox txtAddress = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].FindControl("txtAddress");
TextBox txtPhone = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].FindControl("txtPhone");
cmd = new SqlCommand("Update Employee set(Fname,Lname,Address,Phone)values(@Fname,@Lname,@Address,@Phone)",con);
cmd.Parameters.AddWithValue("@Fname",txtFname.Text);
cmd.Parameters.AddWithValue("@Lname", txtLname.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
con.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
lblmsg.Text = "Record has been successfully updated";
else
lblmsg.Text = "";
con.Close();
|
|
|
|
|
Thanks for your reply.
However, how about if I want to do it by using the proprity that is built in ASP.Net. I tried my query inside SQL server and it is working right, but when I am using it by binding it withthe GridView it does not work. Either it give me an error or it run without error, but it doesn't update.
Looking for an answer.
|
|
|
|
|
Hi,
Previously I was working on Asp.net 1.0 with vb.net. Now I am working on asp.net 2.0 with C#. I am confused about how to use GridView in asp.net 2.0.
What is the syntax for that.
Can any one send me sample code for Gridview with EDIT,DELETE,SELECT etc.
Thank in advance!![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
www.google.com
Make sure you put the dots in all the right places.
Seriously though...
Go to http://www.asp.net[^] and click the "Learn link at the top of the page. On the next page you see, you'll see HUNDREDS of .Net tutorials.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi,
I am using the following code to delibarately generate an error on a page:
Dim exNew As Exception = New Exception("This is a phony exception")
Throw exNew
On the page's error event, I use Server.Transfer("../errorHandler.aspx") to pass error handling on to a custom error notification page (see below). If I handle the error at page level, all works fine and I get the error message "This is a phony exception" as expected.
However, if I change error handling to application level (again just using Server.Transfer in the Application_Error sub in global.asax), the custom error notification page displays again, but this time the message is "Exception of type 'System.Web.HttpUnhandledException' was thrown."
I have a feeling this has something to do with the customErrors tag in web.config as it was all fine until I modified this, currently set to:
<customErrors mode="RemoteOnly" defaultRedirect="../errorHandler.aspx"/>
Can anyone shed any light on this? Have been playing around with it but just can't get it to work...
The error notification page code is:
Protected Function errorDetails(ByVal emailLog As Boolean, ByVal emailToAddress As String, ByVal emailFromAddress As String, ByVal emailAppName As String) As String
' Declarations
Dim unhandledException As Exception = _
Server.GetLastError
Dim errorDateTime As String = Now().ToString
Dim errorLog As String
Dim lineBreak As String = Chr(13) & Chr(10)
Dim currentLog As String
' Returns error message for output on page
errorDetails = "<p>" _
+ "<strong>Date/Time: </strong>" + errorDateTime _
+ "<br /><strong>Message: </strong>" + unhandledException.Message.ToString() _
+ "</p>"
' Generates error log for email/text file
errorLog = "Date/Time: " + errorDateTime _
+ lineBreak + "Message: " + unhandledException.Message.ToString() _
+ lineBreak + "Source: " + unhandledException.Source.ToString() _
+ lineBreak + "Target Site: " + unhandledException.TargetSite.ToString() _
+ lineBreak + "Stack Trace: " + unhandledException.StackTrace.ToString()
' Emails log
If emailLog Then
Emailer.Send(emailToAddress, emailFromAddress, "Website Error Notification from: " & emailAppName, errorLog)
End If
' Gets existing error log from text file
Dim fsIn As FileStream = File.OpenRead(Server.MapPath("../ErrorLog.txt"))
Dim sr As StreamReader = New StreamReader(fsIn)
currentLog = sr.ReadToEnd.ToString()
sr.Close()
' Writes error log to text file
Dim fsOut As FileStream = File.OpenWrite(Server.MapPath("../ErrorLog.txt"))
Dim sw As StreamWriter = New StreamWriter(fsOut)
sw.WriteLine(currentLog + errorLog)
sw.WriteLine(lineBreak + "***********************************************" _
+ lineBreak)
sw.Flush()
sw.Close()
' Clears error from server
Server.ClearError()
End Function
|
|
|
|
|
Hi, I have deployed my asp.net applications to a remote server by using FTP. All aspx pages worked fine on my computer but they ceased to to work when deployed to a remote server. All aspx pages stopped working, except for the html pages. The error message I get was "The current custom error settings for this application prevent the details of the application error from being viewed remotely". What could be the cause of this problem? Please help me resolve this problem, thank you in advance for your help.
|
|
|
|
|
Your core problem is that the web.config is setup for remote clients to not see debug errors, which is good, but unless you can test it directly on the server, you need to change it, to find out what the actual error is.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
can we have more than one sitemap ina project?
if yes how?
how can we display just a part of a site map by a menu?
|
|
|
|
|
I have a dropdownlist control that I want to populate via a function in the code behind. I'm using a a table adapter to actuyally retrieve the fdata, (and when I "previewData", the expected data is displayed. This is what I have so far:
(userType is the dropdownlist control on the aspx page)
STAFFTYPESTableAdapter adapter = new STAFFTYPESTableAdapter();
userType.DataSource = adapter.GetStaffTypes();
All of the items in the dropdown read as follows:
System.Data.DataRowView
There are exactly n occurrences, where n is the number of records in the table. In other words, there are 7 records I expect to see, and there are 7 entries in the dropdown list.
The table I'm retrieving contains two fields - a numeric ID and a text description. What am I doing wrong?
Before you suggest letting the form handle it, I don't want to do it that way.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
