How to get SQL Query from a view in VB.NET
<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>