public DataTable cargarNacionalidades() { SqlCommand oCommand = new SqlCommand(); oCommand.CommandText = "prc_selectNacionalidades"; oCommand.CommandType = CommandType.StoredProcedure; Conexion conn = new Conexion(); DataTable table = new DataTable(); table = conn.EjecutarConsultaDataTable(oCommand); return(table); }
public DataTable buscarEstudianteCed(string cedula) { SqlCommand oCommand = new SqlCommand(); oCommand.CommandText = "prc_buscarEstudianteCed"; oCommand.CommandType = CommandType.StoredProcedure; oCommand.Parameters.AddWithValue("@cedula", cedula); Conexion conn = new Conexion(); DataTable table = new DataTable(); table = conn.EjecutarConsultaDataTable(oCommand); return(table); }