DataTable.TableName returns "Table"??

[Antonio Ooi]

Hi,

I get a DataTable based on this simple query:
SELECT * FROM Customers

Later, I want to know just the table name because I do not want to play with
the string within the SELECT statement. I expect DataTable.TableName to give
me an exact name, i.e. "Customers", but it gives me "Table" regardless of
what query from what table. Can someone gives me some clarifications on the
TabeName property? Thanks in advance.

Regards,
Antonio

[Peter Rilling]

I do not think this has anything to do with the query because suppose you
run the query "select * from Table1, Table2", then what would be the name of
the DataTable? You can set the table name if you want.

"Antonio Ooi" <an*******@homail.com> wrote in message
news:ex**************@TK2MSFTNGP10.phx.gbl...

Hi,

I get a DataTable based on this simple query:
SELECT * FROM Customers

Later, I want to know just the table name because I do not want to play
with the string within the SELECT statement. I expect DataTable.TableName
to give me an exact name, i.e. "Customers", but it gives me "Table"
regardless of what query from what table. Can someone gives me some
clarifications on the TabeName property? Thanks in advance.

Regards,
Antonio

[Antonio Ooi]

I see, logical. Thanks a lot!

Antonio

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

I do not think this has anything to do with the query because suppose you
run the query "select * from Table1, Table2", then what would be the name
of the DataTable? You can set the table name if you want.

"Antonio Ooi" <an*******@homail.com> wrote in message
news:ex**************@TK2MSFTNGP10.phx.gbl...

Hi,

I get a DataTable based on this simple query:
SELECT * FROM Customers

Later, I want to know just the table name because I do not want to play
with the string within the SELECT statement. I expect DataTable.TableName
to give me an exact name, i.e. "Customers", but it gives me "Table"
regardless of what query from what table. Can someone gives me some
clarifications on the TabeName property? Thanks in advance.

Regards,
Antonio

[Cowboy (Gregory A. Beamer) - MVP]

MyDataAdapter.TableMappings.Add("Table", "NameIWishToUseForTable");

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"Antonio Ooi" wrote:

Hi,

I get a DataTable based on this simple query:
SELECT * FROM Customers

Later, I want to know just the table name because I do not want to play with
the string within the SELECT statement. I expect DataTable.TableName to give
me an exact name, i.e. "Customers", but it gives me "Table" regardless of
what query from what table. Can someone gives me some clarifications on the
TabeName property? Thanks in advance.

Regards,
Antonio