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 WindowsFormsApplication2
{
public partial class Form1 : Form
{
private static string ConnectionString = "Data Source=MICROSOF-44BEF0;Initial Catalog=追蹤;user id=sa;password=zzw848686;";
private SqlConnection conn = null;
private SqlCommand cmd = null;
private SqlDataAdapter sda = null;
private DataSet ds=null;
public Form1()
{
InitializeComponent();
conn = new SqlConnection(ConnectionString);
}
private void button1_Click(object sender, EventArgs e)
{
if (conn.State != ConnectionState.Open)
conn.Open();
try
{
string sql = "select * from Tracker";
DataSet ds = new DataSet();
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
double x = 0;
x = Convert.ToDouble(ds.Tables[0].Rows[i]["Latitude"]);