If you really need to use a plain SQL query you MUST add the where cluase and orderby clause directly to the SQL.
2014-11-24 19:15 GMT+01:00 Bryan Valencia <[email protected]>: > The SQL Query is long and complicated, and basically takes a single table > and adds two columns of data from other places, after much ado. > > I only want to READ this data, I never want to update it. All I want to do > is get from CreateSQLQuery to a Gridview, > > Ideally I'd like to gather the data lazy, then apply my WHERE and ORDERBY > clauses before binding, > > > > >>> > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
