How to create view using sql select statement in C#

As I understand your problem, you need to get first five(5) rows from the created view.

I think you can use this SQL SELECT Command

SELECT TOP 3 column1, column2
FROM yourViewName

Or else you can create a new view like this

CREATE VIEW yourNewViewName AS
  SELECT TOP 3 column1, column2
  FROM yourOldViewName

SqlConnection conn = null;
conn = new SqlConnection("yourConnectionString");
conn.Open();
string strSQLCommand = "CREATE VIEW vw_YourView AS SELECT YOurColumn FROM YourTable";
SqlCommand command = new SqlCommand(strSQLCommand, conn);
string returnvalue = (string)command.ExecuteScalar();
conn.Close();