DataSet dataSet = new DataSet();
con.Open();
SqlCommand com = new SqlCommand("pages", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@view", SqlDbType.Int, 10);
com.Parameters.Add("@page", SqlDbType.Int, 3);
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = com;
dataadapter.Fill(dataSet);