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

hi,

SQL View is nothing but a virtual table whose contents are defined by sql query.

Example:

CREATE VIEW myEMPView
AS
SELECT e.EmpCode,u.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.