Hi i have database with these tables
User { IdUser, Name , Surename, Username, Password }
ProfesorData { IdUser, JMBG }
AdministratorData { IdUser, JMBG }
In form for administering profesors i have made fields required to insert new User and ProfesorData.
Now problem is how to display a list of all Profesors ( Users which id is found in ProfesorData table ).
I have tried deeploading User datasource so i could bound the JMBG field
but there are still users which are not profesors. Heres the code i used ( Korisnik == User , ProfesorPodaci == ProfesorData )
<data:KorisnikDataSource ID="dsSviProfesori" runat="server" SelectMethod="GetAll" EnableDeepLoad="True">
<DeepLoadProperties>
<Types>
<data:KorisnikProperty Name="ProfesorPodaci" />
</Types>
</DeepLoadProperties>
</data:KorisnikDataSource>
<asp:DataList id="DataList1" runat="server" DataSourceID="dsSviProfesori">
<ItemTemplate>
<asp:Label ID="lbListaProfesoraIme" runat="server" Text='<%# Eval( "Ime" ) %>' />
<asp:Label ID="lbListaProfesoraPrezime" runat="server" Text='<%# Eval( "Prezime" ) %>' />
<asp:Label ID="lbListaProfesoraJMBG" runat="server" Text='<%# Eval( "ProfesorPodaci.JMBG" ) %>' />
<asp:Button ID="btnListaProfesoraOdaberi" runat="Server" Text="Odaberi" CommandName="select" />
</ItemTemplate>
</asp:DataList>
Also i have tried various filters in data source but I couldn't find what I need. The reason why am I making this list is to be able to select a profesor here and edit his information in some FormView i will later add below this data list. Is this possible without writing code behind.
Thanks a lot,
Zlax