|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
deleting multiple record same timei 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 <JK.Jar***@gmail.com> schreef in bericht Show quoteHide quote news:1144093129.787423.45790@g10g2000cwb.googlegroups.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 > 
Other interesting topics
Suggestions to reduce memory use when splitting a string
How do you use an unbound DataAdapter? Dummy question Easy One: Bind a Text Box to a an Integer Variable Getting DataGrid row X, Y position and Changing Column Width (2003) Can't get rid of references Reflection Question and MDI question Using PLink interactively as a Telnet process with VB.Net 2003 What/How do I access installed Drivers in .NET 2.0 ? Form Focus |
|||||||||||||||||||||||
