Generate DataSet rename tables

  • Thread starter Thread starter ASP.Net programmer
  • Start date Start date
A

ASP.Net programmer

I have a few SQLDataAdapters which select a MAX() value from a few
different tables.

Here is a sample of the SQL statement:
SELECT MAX(startdate) AS startdate
FROM some_table1
WHERE (startdate <= GETDATE())

The problem I have is this: When I select a few of those SQLDataAdapters
to generate a DataSet from them the list of DataAdapters shows:

Table (daSomeTable1)
Table (daSomeTable2)

Other (normally selected) tables show up in the list like this:
AnotherTable (daAnotherTable)

If I add the daSomeTable* DataAdapters I get the following error:
"Cannot generate a dataset that contains multiple tables with the same
name (Table)."

Changing the SQL statement to the following code didn't work:
SELECT MAX(startdate) AS startdate
FROM some_table1 AS some_table1
WHERE (startdate <= GETDATE())

Does someone have the solution to this problem? I prefer to put all
those DataAdapters in one DataSet, if possible.

Thanks in advance
 
I found it. I could change the DataSet table name from the table mappings
collection. :)
 
Back
Top