Comments by JohnUSA (Top 34 by date)

Yes, my string is String sql = "SELECT * \nFROM \n[BooksTable] \nWHERE \n[author] = '" + author + "' \nAND \n[ISBN] = '" + ISBN + "'";

MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[BooksTable]
WHERE
[author] = 'George Elliot'
AND
[ISBN ] = '1234'' at line 3

at MySql.Data.MySqlClient.PacketReader.CheckForError()
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
at MySql.Data.MySqlClient.CommandResult..ctor(Driver d, Boolean isBinary)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at Books.Form1.tes1t() in C:\Users\Charis\Documents\Visual Studio 2010\Books\Books\Books\Form1.cs:line 175 Exception caught.
The thread 'vshost.RunParkingWindow' (0x1e94) has exited with code 0 (0x0).
The thread '' (0x158c) has exited with code 0 (0x0).
The program '[2508] Books.vshost.exe: Program Trace' has exited with code 0 (0x0).
The program '[2508] Books.vshost.exe: Managed (v4.0.30319)' has exited with code 0 (0x0).

Yes. Still the same problem.
MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[BooksTable] WHERE [author] ='George Elliot' AND [ISBN] ='1234'' at line 1
and at Books.Form1.tes1t() in C:\Users\Charis\Documents\Visual Studio 2010\Projects\Books\Books\Form1.cs:line 173 Exception caught.

Line 173: Reader = command.ExecuteReader();

The type i had was VARCHAR, tried know TEXT but still can't see anything!
What can be the mistake here ?=p everything seems well

sql null string

What information ? Can you point me at the exact link please?

What do you mean if the address is valid ? I want when i type New York in the text box and the press the Search button my map to be located on New York.

Just saw and used your trick. Thanks for this. A million thanks!

I am very confused and i don't think i can't fix this error. I tried what you have told me. My new code is:
public partial class Form1 : Form {

[ComVisible(true)]
public class ScriptManager {
Form mForm;

public ScriptManager() {
}

public void MethodToCallFromScript() {
}
}

public void DoSomething()
{
MessageBox.Show("It works!");
//Will be used for calculations once x and y are retrieved from JavaScript MessageBox.Show("It works!");
}
public Form1()
{
InitializeComponent();
this.webBrowser1.Navigate(@"C:\Users\Charis\Documents\Visual Studio 2010\Projects\FlightScheduler\FlightScheduler\index.html");
webBrowser1.ObjectForScripting = new ScriptManager();
}
I am stuck with it. Can you please show me the way with this code fixed? This would be very helpful for me. As you have seen i am stuck on it :( Thanks again

Million thanks for you help once again. I did followed your instruction and came up with this:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;

namespace FlightScheduler
{
[ComVisible(true)]
public partial class Form1 : Form
{

public class ScriptManager {
Form mForm;

public ScriptManager(Form form){
mForm = form;
}
public void MethodToCallFromScript() {
}
}

public Form1()
{
InitializeComponent();
this.webBrowser1.Navigate(@"C:\Users\Charis\Documents\Visual Studio 2010\Projects\FlightScheduler\FlightScheduler\index.html");
webBrowser1.ObjectForScripting = new ScriptManager(this);
}

public void DoSomething(){
//Will be used for calculations once x and y are retrieved from JavaScript
MessageBox.Show("It works!");
}

I am on right track now ? Thanks again!!

I have give one more try with my code and i came up with something like this:

public class ScriptManager
{
Form1 mForm;
}

public Form1()
{
InitializeComponent();
this.webBrowser1.Navigate(@"C:\Users\Charis\Documents\Visual Studio 2010\Projects\FlightScheduler\FlightScheduler\index.html");
webBrowser1.ObjectForScripting = new ScriptManager();
}

public void DoSomething(){
//Will be used for calculations once x and y are retrieved from JavaScript
}

public void MethodToCallFromScript() {
mForm.DoSomething();
}

I get only one error which is: The name 'mForm' does not exist in the current context. I am not sure what i have done so far and what i have to change.

You mean?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace FlightScheduler
{
public partial class Form1 : Form
{

public Form1()
{
InitializeComponent();
this.webBrowser1.Navigate(@"C:\Users\Charis\Documents\Visual Studio 2010\Projects\FlightScheduler\FlightScheduler\index.html");
}

public void DoSomething(){

}

public void MethodToCallFromScript() {
Form1.DoSomething();
}

private void button1_Click(object sender, EventArgs e)
{

DateTime obj = new DateTime();
String travellingDate;
obj = monthCalendar1.SelectionStart;
travellingDate = obj.ToString();
label3.Text = travellingDate.Substring(0, 10);
}

private void button2_Click(object sender, EventArgs e)
{
DateTime obj1 = new DateTime();
String returingDate;
obj1 = monthCalendar2.SelectionStart;
returingDate = obj1.ToString();
label4.Text = returingDate.Substring(0, 10);
}

private void Form1_Load(object sender, EventArgs e)
{

}

}
}

No i haven't managed to fix the code. My C# Code looks like this:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace FlightScheduler
{
public class ScriptManager {
Form mForm;

public ScriptManager(Form form) {
mForm= form;

public void MethodToCallFromScript() {
mForm.DoSomething()
}
}
}
public partial class Form1 : Form
{

public Form1()
{
InitializeComponent();
this.webBrowser1.Navigate(@"C:\Users\John\Documents\Visual Studio 2010\Projects\FlightScheduler\FlightScheduler\index.html");
Webbrowser mBrowserCtrl = new Webbrowser();
mBrowserCtrl.ObjectForScripting = new ScriptManager(this);
}

private void button1_Click(object sender, EventArgs e)
{

DateTime obj = new DateTime();
String travellingDate;
obj = monthCalendar1.SelectionStart;
travellingDate = obj.ToString();
label3.Text = travellingDate.Substring(0, 10);
}

private void button2_Click(object sender, EventArgs e)
{
DateTime obj1 = new DateTime();
String returingDate;
obj1 = monthCalendar2.SelectionStart;
returingDate = obj1.ToString();
label4.Text = returingDate.Substring(0, 10);
}

private void Form1_Load(object sender, EventArgs e)
{

}

}
}

What are my mistakes on it ? What should i correct?

Hello again, i am now trying to pass the variable from JavaScript to C# but i haven't managed it yet. Do i have to do something to "Connect" the JavaScript to the project code? Whatever i have tried i wasn't able to pass the variable which contains x and y retrieved from the mouse click.

My application is a Visual C# Windows Form Application. Yes, Google Maps are hosted into a WebBrowser control in a Windows Forms application. WebBrowser navigates to my page (index.html). I am using Appserv to host this page on my localhost. This page is given above in the JavaScript code on the first part of my question.

public Form1()
{
InitializeComponent();
webBrowser1.Navigate("http://localhost/index.html");
}

Thanks for you help once again.

Yeah, i did read the article you gave to me but this is not what i want to do. I don't want the variable to be passed from JavaScript to C# with a button click. I want all of the to be stored in an array or something (the X and Y coordinates, each time i click the mouse) and then transfered to C# so i can use them for calculations. I need to say that my C# application is a Windows Form Application not a page.

As you can see i am new in C# and JavaScript that's why i have all this "stupid" questions, but document.write(latidute); is just used to check if x and y are taken with the mouse click. I have managed to see that the click works. Now the difficult part for me is to pass the variable to C#. Whatever i've tried didn't worked. I don't know what i should do now, what files to create and how to move on. I am stuck on it :(

Haven't managed anything!

The best thing on what i need to do is store x and y in table or something and then directly post them to C#. I think that i need a for loop when adding markers using function addMarker(location) { that will store all of the x's and y's and then passed to C#. Is there a way to add some code in my function addMarker to do this things ? i tried with:
var i=0;
for (i=0;i<=markersArray.Length();i++)
{
document.write(latidute);
}

but it doesn't work. any ideas?

Since i haven't managed to make it work i haven't updated the code. The thing that i want to do now is by using the function addMarker(location) to get all of the x and y each time the mouse is clicked in the map and then pass all of the variables to C# using an array or something else. So i have to create a new ASP.net page and include the code you provided above ? The code that has to be added in C# is protected void myButton_Click(object sender, EventArgs e)
{
myLabel.Text = "The Javascript told me: " + myHiddenData.Value;
} ?

Thanks for your help.

First of all sorry for my mistake replying as an answer. I am new here :) About the code, all of this code should be placed in my JavaScript file or i have to add some code in C# application ? I haven't managed to pass variables yet because i get an error on myHiddenData which C# can't recognise. What i've done is that i added this code on my JavaScript file below <div align="center" style="vertical-align:middle;"></div>line and above </body>. Thanks for your help once again.