// ******************************************************************** // ******************************************************************** public void GetRodovias(ref int nRod, C_Rodovia objRod) { string[] aRod = new string[50]; nRod = 0; ConectaBanco(); com1 = mysqlCon1.CreateCommand(); com1.CommandText = "select Rodovia from trodovias"; reader1 = com1.ExecuteReader(); while (reader1.Read()) { nRod++; objRod.Rodovia[nRod] = reader1["Rodovia"].ToString(); //objRod.MunA[nRod] = reader1["munA"].ToString(); //objRod.MunB[nRod] = reader1["munB"].ToString(); } reader1.Close(); DesconectaBanco(); }
private void PopulaComboRodovias(int nRod, C_Rodovia objRod) { cmbRod.Items.Clear(); int ind1 = 0; for (ind1 = 1; ind1 <= nRod; ind1++) { cmbRod.Items.Add(objRod.Rodovia[ind1]); } }
//******************************************************************* public void TrazKmsPontosFE(ref int nRod, string aRod, C_Rodovia objRod) { nRod = 0; ConectaBanco(); com1 = mysqlCon1.CreateCommand(); // "select kmEdital from ponto_fe where Rodovia= " + "'" + cmbRodovia.Text + "'"; com1.CommandText = "select kmEdital from ponto_fe where Rodovia= " + "'" + aRod + "'"; reader1 = com1.ExecuteReader(); while (reader1.Read()) { nRod++; objRod.kms[nRod] = reader1["kmEdital"].ToString(); } reader1.Close(); DesconectaBanco(); }