Running a SQL statement on a DataSet or DataTable
- From: "fgravel" <fgravel@xxxxxxxxxxxxx>
- Date: Fri, 9 Sep 2005 08:58:42 -0600
I would like to know if it is possible to run a SQL Select statement against
a disconnected Dataset or Datatable directly. I know that I can use a
rowfilter in a Dataview, but as an example I want to run the following:
SELECT MAX({ fn LENGTH(ColumnName) }) AS Expr1
FROM DatabaseTableName
Which returns the length of the longest string within the column within the
specified database table, but I would like to run it on the disconnected
table or dataset instead of directly on the database
fgravel@xxxxxxxxxxxxx
.
- Prev by Date: XSLT intellisense in VS2005 b2
- Next by Date: Disappearing runat="server"
- Previous by thread: XSLT intellisense in VS2005 b2
- Next by thread: Disappearing runat="server"
- Index(es):
