title: How to get SQL Query from a view in VB.NET
body: <p>I have a database in my sql server and I also created one view in it to store a really long, I mean a really long query. And I need to use this query to fill a SqlDataAdapter in VB</p>
  
  <p>Basic example with very straight easy query on how to fill a SqlDataAdapter</p>
  
  <pre><code>adapter.Fill("Select * from products")
  </code></pre>
  
  <p>I only wish my query was this simple and straight forward, instead i have a monster of a query and dont't want / cant't just paste it in my code. Isn't there another way to access it like so:</p>
  
  <pre><code>adapter.Fill(dataSet.ViewWithLongQuery)
  </code></pre>
  
  <p>The Dataset here contains my View </p>
  
  <p>Thanks!</p>