If you look at dataadapter it has three commands:InsertCommand,
UpdateCommand and DeleteCommand.
Each is executed for specific action (based on DataRow.RowState property).
These are all instances of DbCommand descendent classes.
You should look at its CommandText property where SQL command text is
stored.
By default all values are (more or less all) fetched from DataRow.
You should change this SQL text to your wishes (substitue a parameter with
sysdate - so value isn't fetched from datarow but rather it is done by using
sysdate on the server)
HTH
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development
www.rthand.com
Blog:
http://cs.rthand.com/blogs/blog_with_righthand/
"Phil Hunt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I know how to do it in a straight SQL statement. But not with thess fancy
>object. Can you be more specific ???
>
> "Miha Markic" <miha at rthand com> wrote in message
> news:(E-Mail Removed)...
>> You have to properly compose (proper SQL syntax) InsertCommand or
>> UpdateCommand.
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Phil Hunt" <(E-Mail Removed)> wrote in message
>> news:OTin6$(E-Mail Removed)...
>>>I am using OLEDataAdaptor, DataTable and DataRow to insert a row like
>>>
>>> dr["CREATEDDATE"] = ......
>>>
>>> My question is how do I set that column to "Oracle sysdate"
>>>
>>> TIA.
>>>
>>
>
>
Similar Threads
