By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,640 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,640 IT Pros & Developers. It's quick & easy.

deleting multiple record same time

P: n/a
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

Apr 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

<JK*******@gmail.com> schreef in bericht
news:11*********************@g10g2000cwb.googlegro ups.com...
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

Apr 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.