How do I query a dataset and return a new table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HB - 28 Oct 2005 20:25 GMT

I have an application that is requiring me to pull 4 tables into a dataset
then perfom the final query to display on the page

Dim objODBCAdapter As New Data.Odbc.OdbcDataAdapter("SELECT
WBS_CMF_NO, WBS_KEY, WBS_DESCRIP FROM CT07WBS;", conn)
objODBCAdapter.Fill(DS, "wbstemp")

How do I excecute the query below against the wbstemp table I just created?

objODBCAdapter.SelectCommand.CommandText = "SELECT
Left([wbs_cmf_no],4) AS Acct, Right([wbs_cmf_no],3) AS Sub, WBS_CMF_NO,
WBS_KEY, WBS_DESCRIP FROM CT07WBS;"
objODBCAdapter.Fill(DS, "wbs")

Due to limitations I cannot use left and right in the original (first)
statement

Thanks for the help

Reply to this Message

John Timney ( MVP ) - 28 Oct 2005 20:39 GMT

have a look if RowFilter can help you at least filter out from each of the
4 tables

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr
fSystemDataDataViewClassRowFilterTopic.asp

Signature

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

>I have an application that is requiring me to pull 4 tables into a dataset
>then perfom the final query to display on the page
[quoted text clipped - 15 lines]
>
> Thanks for the help

Reply to this Message

How do I query a dataset and return a new table

Free Magazines