using (MySqlConnection connection = new MySqlConnection(mysqlConnectionString))
{
using (MySqlCommand command = new MySqlCommand("p_getGjdata", connection))
{
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new MySqlParameter("?stime", MySqlDbType.VarChar).Value = "2011-11-11");
command.Parameters.Add(new MySqlParameter("?etime", MySqlDbType.VarChar).Value = "2011-11-12");
command.Parameters.Add(new MySqlParameter("?imsi", MySqlDbType.VarChar).Value = "460004134317878");
DataSet ds = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(ds);
{
using (MySqlCommand command = new MySqlCommand("p_getGjdata", connection))
{
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new MySqlParameter("?stime", MySqlDbType.VarChar).Value = "2011-11-11");
command.Parameters.Add(new MySqlParameter("?etime", MySqlDbType.VarChar).Value = "2011-11-12");
command.Parameters.Add(new MySqlParameter("?imsi", MySqlDbType.VarChar).Value = "460004134317878");
DataSet ds = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(ds);
BEGINSELECT A.lat,A.lon, B.time FROM tblaijw as A, tbphonelbsrec as B where B.imsi=imsi and B.time>=stime and B.time <= etime
and A.lac = B.lac and A.cellid = B.cellid ORDER BY B.time;
END; 这是存储过程