CommandBuilder key fields

[Javier Ros]

Hi guys,
I´m working with AS/400 DB2 Database and it don´t have key fields
information (don´t have SYSTABLES, SYSINDEX, ...)

Can I set the key fields in CommandBuilder Object?

thanks in advance.

..Javier Ros Moreno.

 

[David Sceppa]

Javier,

The CommandBuilder relies on the back-end to provide
meta-data about the resultset returned by the DataAdapter's
SelectCommand in order to generate updating logic. If the
provider you're working with does not supply this meta-data, you
won't be able to rely on the CommandBuilder to generate your
updating logic.

If you know the schema for your queries at design-time,
you'd get better performance by supplying your own updating logic
in code. The Visual Studio .NET DataAdapter Configuration Wizard
generates updating logic this way, but it relies on similar
meta-data to generate that logic.

The CD for "Microsoft ADO.NET" from Microsoft Press includes
a fairly simple stand-alone tool to generate updating logic
against various .NET Data Providers in VB.NET and C#. If the
query you supply does not return enough schema information to
generate updating logic, the tool prompts you for that schema
information. This type of tool (and there may be others out
there) may prove helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.