Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE DB provider, .NET, and server side updatable rowset
Message
 
 
To
11/08/2003 20:57:11
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
00819225
Message ID:
00819280
Views:
15
Could it be that they refer to the fact that VFP Ole Db does not support .NET object OleDbCommandBuilder?

With SQL Server you can do the following (I am copying from Rick Strahl's white paper of VFP and .NET interop):
OleDbDataAdapter oDSAdapter = new OleDbDataAdapter("select * from customer", this.oConn);

// build update/insert command for data adapter
OleDbCommandBuilder cCmdBuilder = new OleDbCommandBUilder( oDSAdapter);

lnRows = oDSAdapter.Update(this.oDS, "Customer");
The above will not work with VFP OleDB and you have to build UPDATE and INSERT commands manually.

HTH.



>I found this question about the new OLE DB data provider in a .NET newsgroup. Can anyone help me answer it?
>
>"It seems to that the provider doesn't support updateable rowsets at the server side. Why doesn't this provider support updateable rowsets at the server side?"
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform