I'm not sure if this is a problem with Microsoft's Application Data Blocks,
but I am using a query like this:

USE DATABASENAME;SELECT * FROM SOMETABLE

The tablename property of my datasets are not being set - this causes a
problem with CrystalReports.

Is there a way to auto-set the Tablename in a dataset?

Thanks.

--
Lucas Tam ((E-Mail Removed))
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

use FillDataset instead of ExecuteDataset. here's the signature on one of
them. as you can see, the tableNames() array is for this.

Public Overloads Shared Sub FillDataset(connectionString As String,
commandType As CommandType, commandText As String, dataSet As DataSet,
tableNames() As String)



Lucas Tam wrote:
> I'm not sure if this is a problem with Microsoft's Application Data
> Blocks, but I am using a query like this:
>
> USE DATABASENAME;SELECT * FROM SOMETABLE
>
> The tablename property of my datasets are not being set - this causes
> a problem with CrystalReports.
>
> Is there a way to auto-set the Tablename in a dataset?
>
> Thanks.

"Josh Golden" <(E-Mail Removed)> wrote in
news:40ec35c8$0$82988$(E-Mail Removed):

> use FillDataset instead of ExecuteDataset. here's the signature on
> one of them. as you can see, the tableNames() array is for this.
>

Shoot, I was hoping there was some automatic way to pick up the table names
from the database. I'm using System.Reflection to dynamically instantiate
my functions, so any manual work is a bit hard to do.

Anyhow, thanks for your help!

--
Lucas Tam ((E-Mail Removed))
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/