I want to display data from more than one table in one of my custom page template of my ASP.NET Dynamic data web app.
The query would be something like the one given below:
CREATE VIEW [dbo].[EmployeeDetail_V]
SELECT Emp.EmployeeID, Emp.FirstName, Emp.LastName,
Emp.MailID, Dept.Name, Desig.Designation
From Employee Emp
INNER JOIN Department Dept ON Emp.DepartmentID = Dept.DepartmentID
INNER JOIN Designation Desig ON Emp.DesignationID = Desig.DesignationID
I know, I can do this using sql views but I want that user should also be able to edit the records also.
Is there a framework or step to do this using VS 2010?
View Complete Post