Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public string[,] routelist()
- {
- SqlCommand uno = new SqlCommand("SELECT COUNT(*) from rutas", link);
- SqlCommand dos = new SqlCommand("SELECT Clave,nombre from rutas", link);
- int registros;
- SqlDataReader r1, r2;
- link.Open();
- r1 = uno.ExecuteReader();
- r1.Read();
- registros = Convert.ToInt32(r1.GetValue(0));
- string[,] route = new string[registros, 1];
- link.Close();
- link.Open();
- r2 = dos.ExecuteReader();
- int d1 = 0;
- while (r2.Read())
- {
- route[d1, 0] = r2.GetValue(0).ToString();
- d1++;
- }
- link.Close();
- return route;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement