i want to have view query in C# kindly let me know it
If you mean u want to use query(Like storedProcedure or exactly query) there is some ways:
*use Sql Server and write all your queries there,then bind your DB to your project in C#.
*use Local DataBase or Service-based DataBase(it depends on your need) from Project > Add new Item> Local DataBase/Service-based DataBase
of course in 2 ways u can use View too.(as storedProcedure)
if I understand your question we can follow more steps.
i am asking that i want to restrict my data base. i have developed human resource mangement system in C# .net visual studio 2008. now i want to restrict users to access data from datea-base. for that purpose i want use view in c# but i dont have any idea how to use and how to make query of it