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"]); |