Advertisement
Guest User

Untitled

a guest
May 27th, 2015
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.78 KB | None | 0 0
  1.  public string[,] routelist()
  2.         {
  3.             SqlCommand uno = new SqlCommand("SELECT COUNT(*) from rutas", link);
  4.             SqlCommand dos = new SqlCommand("SELECT Clave,nombre from rutas", link);
  5.             int registros;
  6.             SqlDataReader r1, r2;
  7.             link.Open();
  8.             r1 = uno.ExecuteReader();
  9.             r1.Read();
  10.             registros = Convert.ToInt32(r1.GetValue(0));
  11.             string[,] route = new string[registros, 1];
  12.             link.Close();
  13.             link.Open();
  14.             r2 = dos.ExecuteReader();
  15.             int d1 = 0;
  16.             while (r2.Read())
  17.             {
  18.                 route[d1, 0] = r2.GetValue(0).ToString();
  19.                 d1++;
  20.             }
  21.             link.Close();
  22.             return route;
  23.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement