PC Review


Reply
Thread Tools Rate Thread

about DataAdapter and Update command

 
 
Julia Sats
Guest
Posts: n/a
 
      9th Sep 2003
Hi,
This is code from MSDN help (OracleDataAdapter.UpdateCommand Property)

' Create the UpdateCommand.

cmd = New OracleCommand("UPDATE Dept SET DeptNo = pDeptNo, DName = pDName
" & _
"WHERE DeptNo = poldDeptNo", conn)

cmd.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")
cmd.Parameters.Add("pDName", OracleType.NVarChar, 14, "DName")

parm = cmd.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo")
parm.SourceVersion = DataRowVersion.Original

da.UpdateCommand = cmd


After information inside Dataset would be changed I can call Update method
for updating my DB, like it:

da.Update(myDataset)

but how I can pass parameters ??
and if I do not need to pass parameters why they need ?

I use Janus GridEx control and when I check RowState - information really
changed, but I can not update this information to DB

Thanks


 
Reply With Quote
 
 
 
 
Armin Zingler
Guest
Posts: n/a
 
      9th Sep 2003
"Julia Sats" <(E-Mail Removed)> schrieb
> This is code from MSDN help (OracleDataAdapter.UpdateCommand
> Property)
>
> ' Create the UpdateCommand.
> [...]


This is a VB.NET language group. Would you please (is this polite enough?)
turn to the group microsoft.public.dotnet.framework.adonet because there are
the specialists.


--
Armin

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
error in update command using dataadapter nannu Microsoft C# .NET 2 5th Feb 2007 04:10 AM
.net 1.1 DataAdapter.Update() command Steven Spencer \(Spinalogic\) Microsoft Dot NET Framework 0 17th Jan 2007 11:04 PM
DataAdapter changes insert-command at Update Patrick Microsoft ADO .NET 3 12th Dec 2006 06:42 PM
DataAdapter.Update Command Failed To Update Database Chris Lee Microsoft ADO .NET 10 4th Aug 2004 06:53 PM
DataAdapter and Update command Julia Sats Microsoft ADO .NET 2 11th Sep 2003 09:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:29 AM.