好长的代码,发现一个问题: oCmd = new MySqlCommand("select * from `hy` order by `stationid` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `nalja` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sigan` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `ou` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `oi` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `signal` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `gas` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sim` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sensor1` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sensor2` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sensor3` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `sensor4` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `H2S` desc;", oCnn); oCmd = new MySqlCommand("select * from `hy` order by `NH3` desc;", oCnn);
你想让大家围观吗!!
oCmd = new MySqlCommand("select * from `hy` order by `stationid` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `nalja` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sigan` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `ou` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `oi` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `signal` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `gas` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sim` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sensor1` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sensor2` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sensor3` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `sensor4` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `H2S` desc;", oCnn);
oCmd = new MySqlCommand("select * from `hy` order by `NH3` desc;", oCnn);
oReader = oCmd.ExecuteReader(); 你上面oCmd的Command.Text始终为最下面那个,前面的都没用上
应该用个循环给oCmd的Text属性轮流赋值执行