i have two tables like:
CREATE
TABLE [dbo].[Entry](
[Id] [int]
IDENTITY(1,1) NOT NULL,
[TitleId] [int]
NOT NULL,
[Text] [nvarchar]
(max) NULL
)
CREATE
TABLE [dbo].[Title](
[Id] [int]
IDENTITY(1,1) NOT NULL,
[Lang] [nvarchar]
(50) NULL
)
there tables are connected by Title.Id and Entry.TitleId columns.
i want to show some data in grid like:
Title.Id, Title.Lang, Entry.Id, Entry.Text
how can i achieve this?
thanks for your help.