473,378 Members | 1,387 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Easy question about DataTable

Hello!

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

//Tony
Oct 25 '07 #1
5 963

"TonyJ" <jo*****************@telia.comwrote in message
news:O1**************@TK2MSFTNGP03.phx.gbl...
Hello!

Can one DataTable be considered in the same way as a table in the
database.
>
Define 'considered'?

--
Anthony Jones - MVP ASP/ASP.NET
Oct 25 '07 #2
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
"Anthony Jones" <An*@yadayadayada.comskrev i meddelandet
news:eq**************@TK2MSFTNGP06.phx.gbl...
>
"TonyJ" <jo*****************@telia.comwrote in message
news:O1**************@TK2MSFTNGP03.phx.gbl...
Hello!

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

Define 'considered'?

--
Anthony Jones - MVP ASP/ASP.NET


Oct 25 '07 #3
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

"TonyJ" wrote:
Hello!

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

//Tony
Oct 25 '07 #4
Hi,
--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
"TonyJ" <jo*****************@telia.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
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.
Oct 25 '07 #5

"Peter Bromberg [C# MVP]" <pb*******@yahoo.yohohhoandabottleofrum.comwrote
in message news:72**********************************@microsof t.com...
>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.

Oct 25 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jax | last post by:
Only way I can figure it at present is to do some string manipulation so I can catch the '.' and count the chars and cut after a certain point Does anyone know an easier way to do this? The data is...
5
by: Stefan Turalski \(stic\) | last post by:
Hi, I'm wondering if there is a way to send a method parametrs by ref when DataTabel is a type of this value ? I done some sort of select over DataTable columns, just by removing them froma...
0
by: Jason | last post by:
I am pretty new to C# so bare with me... The design of my website utilizes tables on every page that look almost identical, save the data they are displaying. I have written the code to create...
4
by: angus | last post by:
Dear All, in my asp.net, i have - a textbox to input a text - a "add row" button, after it has been clicked the text in the textbox will add to the table - a submit button, the user can add...
3
by: BY | last post by:
Hi, This is my code and it works fine... Dim Conn As OleDb.OleDbConnection Dim Cmd As OleDb.OleDbCommand Dim Reader As OleDb.OleDbDataReader Dim i As Integer Conn = New...
1
by: Mad Scientist Jr | last post by:
can someone explain how to simply populate a grid in .net ? the way i understand it, there is no more msflexgrid, and instead is this new control that has to be tied to a dataset, and it is a real...
6
by: Danny Ni | last post by:
Hi, If I want to programatically add rows to a DataTable, do I call AcceptChanges per row? Or do I call AcceptChanges after all rows added? TIA
5
by: gregarican | last post by:
I have a simple VC# form that validates its text boxes' contents and I want to insert these text box contents into an SQL Server 2005 Express DB. I have added the DB as a data source but right off...
10
by: xiao | last post by:
Can anyone help me to find out what are the structure of 'DataTable' ? Does loop the 14 layers or the 800*800 array first? (NumX=NumY=800) gridde and WriteHeader are two structures Thank you~~~...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.