Hello.
Because my client's table has two rows getting int values as ids from other table to display the string values.
Table 1 Table 2
Item: 12 12 = 'Cat'
For displaying the values I have created view in DB
create view ClientsView as
select cl.id,cl.Name,cl.Familyname,cl.Position,cl.Email,cl.OfficePhone,cl.Mobile,cl.Website,cl.Comment,cl.[Date],cont.country,cl.Street,cl.City,clgr.[Group]
from Clients as cl INNER JOIN
dbo.Countries as cont on cont.id=cl.Country
Inner Join
dbo.ClientsGroups as clgr on clgr.id=cl.[Group];
go
works fine for reading data. what's about the insertion and using view in GridView or DetailsView?
View won't work for insertion or deleting. Is there any way to make him do it?