Easy question about DataTable

[TonyJ]

Hello!

Can one DataTable be considered in the same way as a table in the database.

//Tony

 

[Anthony Jones]

Hello!

Can one DataTable be considered in the same way as a table in the database.

Define 'considered'?

 

[TonyJ]

Hello!

I mean interpret.

A database table has columns rows and maybe constraints.
A DataTable has some columns and probably some rows. It might also have some
constraints.

In this sense they are quite similar containing more or less the same kind
of objects(column,rows..)

I'm I right?

//Tony

 

[Guest]

A DataTable, if the SQL used to populate it returns all rows and columns, can
be "considered" an in-memory representation of the database table it's rows
came from. But, I'm not sure what this accomplishes for you.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,


--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.

Hello!

I mean interpret.

A database table has columns rows and maybe constraints.
A DataTable has some columns and probably some rows. It might also have
some
constraints.

In this sense they are quite similar containing more or less the same kind
of objects(column,rows..)

I'm I right?

You are right. As a matter of fact that is the idea in teh first place.
Now note that it's "similar" but not exactly the same.

 

[Mr. Arnold]

A DataTable, if the SQL used to populate it returns all rows and columns,
can
be "considered" an in-memory representation of the database table it's
rows
came from. But, I'm not sure what this accomplishes for you.

You can bind a DataTable to a control that was derived from a
dataset/contains a dataset .You can't bind a SQL Table to a control.