C#和MySQL运行SQL语句并读取行进行处理

            MySqlConnection mysql = new MySqlConnection(ConfigurationSettings.AppSettings["Connection"]);
                mysql.Open();
                MySqlCommand cmd = mysql.CreateCommand();
		cmd.CommandText = "sql语句";
                MySqlDataReader rdr = cmd.ExecuteReader();
		while (rdr.Read()) {
   			//处理数据 rdr["字段名"]
		}

            MySqlConnection mysql = new MySqlConnection(ConfigurationSettings.AppSettings["Connection"]);
                mysql.Open();
                String sql = @"SELECT devID, device_id, devName, deviceName, lng, lat FROM tb_device A, devinfo b WHERE a.`id` = b.`device_id`";
                MySqlDataAdapter msa = new MySqlDataAdapter(sql, mysql);
                DataTable dt = new DataTable();
                msa.Fill(dt);
                foreach (DataRow rdr in dt.Rows)
                {
			//  rdr["字段名"]
		｝