public static DataTable select()
{
ConexionSQL conn = new ConexionSQL();
return conn.cargarTablaSQL("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra");
//conn.ejecutarComandoSQL("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra");
/* ConexionSQL conection = new ConexionSQL("Data source=.\\SQLSERVER2012; Initial Catalog=GD2C2015;User Id=gd; Password=gd2015");
SqlConnection conect = conection.getMiConexionSQL();
SqlCommand coman2 = new SqlCommand(string.Format("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra"), conect);
DataTable tab= conection.cargarTabla(coman2);
return tab;
int retorno=0;
using (SqlConnection conn = BDComun.obtenerConexion())
{ SqlCommand comando = new SqlCommand(string.Format("select * FROM gd_esquema.Maestra"),conn);
retorno = comando.ExecuteNonQuery();
}
return tab;*/
}
public static DataTable select()
{
ConexionSQL conn = new ConexionSQL();
return(conn.cargarTablaSQL("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra"));
//conn.ejecutarComandoSQL("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra");
/* ConexionSQL conection = new ConexionSQL("Data source=.\\SQLSERVER2012; Initial Catalog=GD2C2015;User Id=gd; Password=gd2015");
* SqlConnection conect = conection.getMiConexionSQL();
* SqlCommand coman2 = new SqlCommand(string.Format("select distinct Aeronave_Fabricante, Tipo_Servicio FROM gd_esquema.Maestra"), conect);
* DataTable tab= conection.cargarTabla(coman2);
* return tab;
* int retorno=0;
* using (SqlConnection conn = BDComun.obtenerConexion())
* { SqlCommand comando = new SqlCommand(string.Format("select * FROM gd_esquema.Maestra"),conn);
* retorno = comando.ExecuteNonQuery();
* }
* return tab;*/
}