how to update two tables at the sametime with SqlDataSource and GridView?

I can only update one table with SqlDataSource's UpdateCommand property. So how can I update two tables at the same time?

[130 byte] By [helloone] at [2008-3-3]
# 1
use transactions!
BasselBanbouk at 2007-9-8 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 2
I’m not sure you can do that easily. You might need to extend the existing SQLDataSource Object and override some of its methods to get you the functionality you want.

PS: You might get better answers for SqlDataSource related questions on - http://forums.asp.net

SirajLala at 2007-9-8 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified