This is working with DevExpress and I am implementing the data update through DataBindings and TableAdapters.
The problem is that the queries I require consist a lot of the Joins and it is not a viable option to use SubQuery's inside the query.
I want to know if there is any way to send a query with inner / left join and perform the update / insert / delete using the tableadapters.
This is the Select I'm using:
SELECT Codigo, Valor$, DescEsp, ipTipo, DescTipo, P.Tipo, ipUM, uMedida, ipArancel, Fraccion, TT.Tasa, CantidadAImportar, Valor$, CantidadPermitida, ValorAImportar FROM COMPPERMISO as C inner join PERMISOS P on P.idPermiso = ipPermiso inner join CODIGOS CD on C.ipCodigo = CD.idCodigo inner join Medidas M on idMedidas =ipUM inner join ARANCELES A on idArancel = ipArancel inner join TIPOS T on idTipos = ipTipo inner join TiposTasa TT on idTipoTasa = TipoTasa where idPermiso=195