Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2003, 07:24 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default update my cuurent row

I dont know is it my problem or what?!
I run the following codes to update(change) my data in a table but it doesnt work!!!

System.Data.DataRow mRow;
mRow = dataSet11.Tables["test"].Rows[BndMTest.Position];
//BndMTest is a object of BindingManagerBase

...update fields...

sqlDataAdapter1.Update(dataSet21, "test");
sqlDataAdapter1.Fill(dataSet21);

But if I want to update next or previous row ITS OK!! (when I set my row as mRow = dataSet11.Tables["test"].Rows[BndMTest.Position+1];)

please help me, how to update my curreny row.

Always:),
Hovik Melkomian.
__________________
Always,
Hovik Melkomian.
 
Old July 19th, 2003, 07:34 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

does ADO lock the current row?!? because when I change the position & update then return to last position. it works!!!! please help to update current row in suitable way...

Always:),
Hovik Melkomian.
 
Old July 19th, 2003, 01:17 PM
Registered User
 
Join Date: Jul 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It seems to me You have to call EndEdit() somewhere before
DataAdapter.Update(.,.);

 
Old July 19th, 2003, 11:13 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

You r great!!! Thanks for ur help indeed;)

Always:),
Hovik Melkomian.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update or delete a row in CSV file parthsar5 Pro VB 6 0 April 7th, 2006 03:30 AM
Add row using dataadapter.update JelfMaria VS.NET 2002/2003 0 June 29th, 2005 09:06 AM
How to Update row to differenct column Jane SQL Language 4 December 12th, 2004 08:55 PM
Adding a row without using Update command wpyoung2600 ADO.NET 1 August 22nd, 2004 08:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.