Does CommandBuilder work with self-join query?

  • Thread starter Thread starter al
  • Start date Start date
A

al

Greetings,

Can someone please tell me if CommandBuilder works with self-join query (outer)?

MTIA,
Grawsha
 
Hi,

Normally there is an adapter per table, so I would say nope.

From help files:
"However, you can create a SqlCommandBuilder object to automatically
generate Transact-SQL statements for single-table updates if you set the
SelectCommand property of the SqlDataAdapter"
 
See my article on the CommandBuilder... it should help.
http://www.betav.com/msdn_magazine.htm


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top