Hi I have developed a c# Windows forms application, which will connect to SQL and execute an SQL Query and shows the output data in a Message Box only when the data got changed from the previous output. Now i have developed a new form in the same Project and added web browser to the new form. SO now i have stored the output values of SQL in 2 variables namely lati and longi. Now i have passed them to my new form.
And when i execute my browser with that "url + lati+ longi" valu its not returning any output. Atleast it is not opening any browser form also.
I have tried the following in form2:-
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 LeakLocationFinder
{
public partial class Maps : Form
{
public string lati;
public string longi;
public MainForm lat, lon;
public Maps()
{
InitializeComponent();
}
private void Maps_Load(object sender, EventArgs e)
{
string url = "https://www.google.co.in/maps/place/";
webBrowser1.Navigate(url + lati + "," + longi);
}
}
}
I have following in form 1:-
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.Data.SqlClient;
namespace LeakLocationFinder
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
public void MainForm_Load(object sender, EventArgs e)
{
String old_value = "";
while (true)
{
String connetionString = null;
SqlConnection conn;
SqlCommand cmd;
String sql = null;
SqlDataReader reader;
connetionString = "server=(local);database=modelDb;user id=sa;pwd=Esi2008*";
sql = "DECLARE @var varchar(1000) = (SELECT TOP 1 Text FROM Alarms WHERE AlarmDefinitionId=139 ORDER BY EventTime DESC) DECLARE @start_position int, @end_position int SELECT @start_position = PATINDEX('% at%', @var) SELECT @end_position = PATINDEX('%kilometers%', @var) DECLARE @VALUE VARCHAR(10) = (Select SUBSTRING(@var, @start_position+5,5)) Select Top 1 @VALUE,RouteTable.Latitude,Routetable.Longitude,Alarms.ApplicationTime,RouteTable.StationName,RouteTable.SectionName FROM Alarms INNER JOIN Routetable ON Routetable.Location BETWEEN FLOOR(@VALUE)-1 AND CEILING(@VALUE)+1 WHERE AlarmDefinitionId=139 ORDER BY EventTime DESC";
conn = new SqlConnection(connetionString);
try
{
conn.Open();
cmd = new SqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (old_value.ToString() != reader.GetValue(0).ToString())
{
MessageBox.Show("Leak Location:-" + " " + reader.GetValue(0) + Environment.NewLine + "Latitude:-" + " " + reader.GetValue(1) + Environment.NewLine + "Longitude:-" + " " + reader.GetValue(2) + Environment.NewLine + "Leak Occured Time:-" + " " + reader.GetValue(3) + Environment.NewLine + "Station Name:-" + " " + reader.GetValue(4) + Environment.NewLine + "Section Name:-" + " " + reader.GetValue(5));
string lat = reader.GetValue(1).ToString();
string lon = reader.GetValue(2).ToString();
Maps form = new Maps();
{
string lati = lat;
string longi = lon;
};
}
else
{
}
old_value = reader.GetValue(0).ToString();
}
reader.Close();
cmd.Dispose();
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Cannot Open Connection...! ");
}
System.Threading.Thread.Sleep(5 * 1000);
}
}
private void aboutToolStripMenuItem_Click(object sender, EventArgs e)
{
About_LeakLocationFinder formhelp = new About_LeakLocationFinder();
formhelp.Show();
}
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
The url will be executed with url + lati value and longi value between lati and longi there will be a comma (",").
Please help