How to use UpdateRowSource ?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply

How to use UpdateRowSource ?

Post by nuntio2000 » Fri 19 Nov 2004 18:38

Please could you provide a sample code to insert or update a new row
in a table using UpdateRowSource?

Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: How to use UpdateRowSource ?

Post by Oleg » Thu 25 Nov 2004 10:44

For example, you can set the following query to InsertCommand INSERT INTO DEPT VALUES(:p1,:p2,:p3);SELECT LAST_INSERT_ID() AS DEPTNO and LAST_INSERT_ID value will return in dataset if you use UpdateRowSource.FirstReturnedRecord. UpdateRowSource.OutputParameters makes no sense as output parameters don't work in MySQL now.

Post Reply