Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[0] + " where cod=3";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[1] + " where cod=4";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[2] + " where cod=5";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[3] + " where cod=7";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[4] + " where cod=9";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[5] + " where cod=10";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[6] + " where cod=11";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[7] + " where cod=12";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[8] + " where cod=13";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[9] + " where cod=14";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[10] + " where cod=15";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[11] + " where cod=16";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[12] + " where cod=17";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[13] + " where cod=18";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[14] + " where cod=19";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[15] + " where cod=20";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[16] + " where cod=34";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[17] + " where cod=35";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[18] + " where cod=36";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[19] + " where cod=38";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[20] + " where cod=40";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[21] + " where cod=41";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[22] + " where cod=42";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[23] + " where cod=43";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[29] + " where cod=44";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[30] + " where cod=45";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[31] + " where cod=47";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[32] + " where cod=48";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[33] + " where cod=48";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[34] + " where cod=51";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[35] + " where cod=53";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[36] + " where cod=54";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[37] + " where cod=55";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[38] + " where cod=56";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[40] + " where cod=57";
- myCommand.ExecuteNonQuery();
- myCommand.CommandText = "UPDATE[Aux$] set Valor=" + resultados[41] + " where cod=58";
- myCommand.ExecuteNonQuery();
- MyConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source='D:\Libroexcel.xlsx';Extended Properties='Excel 12.0'");
Add Comment
Please, Sign In to add comment