deleting multiple record same time

  • Thread starter Thread starter JK.Jarmen
  • Start date Start date
J

JK.Jarmen

hi everbody...

i am using vb.net 2005 and sql server 2005.
my master-detail table

tableADISYON tableAYRINTI

ID ID
ADISYONNO <---------> ADISYONNO
DATE URUN
.......... .........
.......... .........
.......... .........
.......... .........

i am create relation ADISYONNO field. how i do delete master table row
and detail tabel same time.


ID ADISYONNO DATE ...... ....... ......
1 1 01.01.2006 12:00:00

ID ADISYONNO URUN ...... ....... ......
1 1 PIZZA
2 1 COLA
3 1 TEA
4 1 PIZZA


i am deleting master table ADISYONNO = 1 record , how i can delete same
time detail table ADISYONNO = 1 field


thanks
 
Hi,

Have a look for on MSDN for Cascade.

You know that for this kind of questions which is not directly related to
language.vb code the newsgroup Microsoft.public.dotnet.framework.adonet is
probably a much better place.

I hope this helps,

Cor
 
Back
Top