dropdownlist in datagris

D

dada

Hi!
I am having few problems. One is: I have dataset which has 10 tables,
and I want to fill datagrid with data from each table alone. My
methods are on webservice. For expl. my table Institucije has:
IDInstitucije-key, Naziv, and table Departmani has IDDepartmana-key,
Naziv, IDInstitucije-f.k. So, I want to fill my datagrid with data
from table Departmani having last coloumn IDInstitucije as
dropdownlist but with textual values that it gets in table
IDInstitucije. Is it posible to do if my if I have
SELECT [ID departmana], Naziv, [ID institucije] FROM Departmani and
SELECT [ID institucije], Naziv, Adresa FROM Institucije in two
adapters? Or I have to make new adapter
SELECT
Departmani.[ID departmana],
Departmani.Naziv,
Institucije.Naziv AS Institucija
FROM
Departmani INNER
JOIN
Institucije ON
Departmani.[ID institucije] = Institucije.[ID institucije].
Thanks,
Dada
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,055
Latest member
SlimSparkKetoACVReview

Latest Threads

Top