 |  |  |  |  |  |  |  |
Deleting Items from a table with relationships
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
Hello,
I have a Categories Table and a Products Table each product has a CategoryID which joins it to the Categories Table.
I have a gridView in which I want to enable adding deleting Catagories, how do I check if a category has Products in it, before attempting to delete it?
I hope that makes some sort of sense.
I have a Categories Table and a Products Table each product has a CategoryID which joins it to the Categories Table.
I have a gridView in which I want to enable adding deleting Catagories, how do I check if a category has Products in it, before attempting to delete it?
I hope that makes some sort of sense.
My current Project www.footystat.com
•
•
Join Date: Aug 2008
Posts: 1,162
Reputation: 
Solved Threads: 137
ASP.NET Syntax (Toggle Plain Text)
the other option is to set an active field, which could be a boolean column and set it to true or false, then select from 'active' columns only if you wanted to do updates rather than physical deletes
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
|
Other Threads in the ASP.NET Forum
- Previous Thread: Image Upload in Ajax
- Next Thread: converting binary data into image in asp.net(vb code)
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 activexcontrol advice ajax alltypeofvideos anathor application asp asp.net bc30451 bottomasp.net box browser button c# checkbox click commonfunctions confirmationcodegeneration css dataaccesslayer database datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dynamically edit expose feedback fileuploader fill flash form formatdecimal forms formview google grid gridview gudi iframe iis javascript list listbox login microsoft mono mouse mssql multistepregistration news numerical objects opera panelmasterpagebuttoncontrols parent project radio redirect registration relationaldatabases reportemail richtextbox rotatepage save schoolproject search security select silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking unauthorized validation vb.net video videos view virtualdirectory vista visualstudio web webapplications webdevelopemnt webprogramming webservice xsl youareanotmemberofthedebuggerusers
