title: How to query from table's view in .Net C#?
body: <p>How to query on table's view in .Net C# web application ?</p>
  <p>for example, here [View_App_Academic] is my table view. My code is listed below. under db scheme, I am not able to see the view due to my user privilege.</p>
  <pre><code>string strquery = &quot;select * from [dbo].[View_App_Academic] where recruitment_id=&quot; + 
  RecruitDropDownList.Text + &quot; and ref_no='&quot; + RefDropDownList.Text + &quot;'&quot;;
  
  SqlCommand objCMD = new SqlCommand(strquery, conn);
  </code></pre>