how to use sqlserver views in asp.net C#?

Question

HI How to create SqlServer Views in ASP.Net C#please forward few example programs.

Jignesh Trivedi · Answer

hi SQL View is nothing but a virtual table whose contents are defined by sql query. Example: CREATE VIEW myEMPView AS SELECT e.EmpCodeu.userName FROM dbo.Users u join employees e on e.empId = u.empId you can use View in C# just as normal table. DataTable t = new DataTable(); using (SqlConnection c = new SqlConnection(connectionstring)) { c.Open(); using (SqlDataAdapter a = new SqlDataAdapter(SELECT * FROM myEMPView c)) { a.Fill(t); } } hope this will help you.