Groups | Blog | Home
all groups > dotnet datatools > july 2006 >

dotnet datatools : Update a DataTable using an SQL Statement


pigeonrandle
7/24/2006 6:56:46 AM
Hi,
I just posted this in dotnet.c# by mistake...apologies to those whom i
have offended :O)

Is it possible to run an Update/Insert SQL statement against a
DataTable. I've seen info on Select, but not Insert/Update.

Thankyou in advance,
James Randle
pigeonrandle
7/24/2006 12:04:41 PM
Mary,
Thanks for your info :o).

I was refering to the people who get offended when you post something
'in the wrong group'. They know who they are!

James.

[quoted text, click to view]
Mary Chipman [MSFT]
7/24/2006 12:16:07 PM
Hmmm, I can't imagine who might be offended by your question -- it
seems perfectly reasonable to me. You should never have to feel like
you need to apologize for asking an honest question. Sometimes people
will redirect you to a more appropriate venue, but that's all. No, the
DataTable does not support SQL syntax. The help topic "Manipulating
Data in a DataTable" describes how to work with data in a DataTable --
http://msdn2.microsoft.com/en-us/library/tzwewss0.aspx.

--Mary

On 24 Jul 2006 06:56:46 -0700, "pigeonrandle"
[quoted text, click to view]
Mary Chipman [MSFT]
7/25/2006 9:12:51 PM
Some people just have too much time on their hands :-)

On 24 Jul 2006 12:04:41 -0700, "pigeonrandle"
[quoted text, click to view]
AddThis Social Bookmark Button