.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Delete Child Record And Later Delete The Parent Record

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :ASP.Net

need help in Sql script

how to Delete Child Record And Later Delete The Parent Record if it has no child

Trigger might be the answer but i don t know how!

if someone has another way tell me

View Complete Post

More Related Resource Links

delete record from excel sheet



           I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."

     below I paste some code snippest.

string strDelete = "Delete  from [" + strSheetName + "$]";

            cmdExcel.Connection = con;
            cmdExcel.CommandType = CommandType.Text;
            cmdExcel.CommandText = strDelete;


Please can anybody this answer.It is urgent

Delete Record From Table A that Is Not In Table B

I have two tables; Table A id, name 101, jones 102, smith 103, williams 104, johnson 105, brown 106, green 107, anderson   Table B id, name, city, state 101, jones, des moine, Idaho 103, williams, Corvallis, Oregon 104, johnson, Grand Forks, North Dakota 105, brown, Phoenix, Arizona 107, anderson, New York, New York   I need to delete records from Table A that are not in Table B.  My front end is writen in .net and I am using Data Access Layer along with a Business Logic Layer for data interaction.   I have tried at least seven variations of joining, right outer join, left outer join resulting in wiping our the entire table or nothing at all; not to mention deleting the record that ought to remain and keeping the record that needs to be deleted!   In my BLL I tried to capture the rowsAffected for the deletion by using-without success. Dim rowsAffected As Integer = Adapter.ID_Deletion(ID) If rowsAffected = 1 Then Exit Function Else Return rowsAffected = 1 End If   Please help.   MsMe.

ExecuteNonQuery using stored procedure will not delete record (SQLDataAdapter)

Hi all I'm using VB.net 2.0 with a SQL server (2005) backend db. I've got a very odd problem. I'm trying to use a stored procedure with a parameter to delete a record from a table. I've tested the stored procedure by running it directly from visual studio and it works fine, but when running it through my application nothing happens. There's no error and it appears to have worked but the record is not deleted. I've checked permissions on the backend db and giving the network ASPNet account the db owner role has no effect either. Here's the code, there are 3 layers - the webform code, then the business logic class, then the dataconnection class. 'firstly the original code that is run from the webform when the user selects to delete the record Partial Public Class NewPerson     Inherits System.Web.UI.Page    Private newConn As New DBConnection    Private currentNewRequest As New NewRequest(newConn)     Protected Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click     Dim requestID As Integer = CInt(Me.lblRecordID.Text)    Me.currentNewRequest.newRequestID = requestID    Me.newConn.openConnection()    Me.currentNewRequest.DeleteRecord()    Me.newConn

Delete one table record if the no more record are associated from another table

Hello All,   In my scenario I have two tables say Table A and Table B. Table A has 3 records   Id Name Value 1 ABC 123 2 XYZ 456 3 PQR 789   Now in another table I have 4 records   Id FName Lname TableAID 101 ABC XYZ 1 102 AAA BBB 1 103 XXX YYY 1 104 PPP QQQ 2   Now I display table B records in gridview when I select 3 records say id 101,102,103 and click on delete button. Table B selected records should be deleted and its working fine.   The problem is that in Table A record 1 ABC 123 is only associated with that many records so when I delete that record from Table B at that time the associated record in Table A should also be deleted as no more association with that record in Table B.   So please give me query or appropriate solution for that.  

Best way to delete a record in SQL aspnet membership system



I'm trying to include a method in my application (for a delete button) that completely deletes a user from all relevant tables in the entire aspnet membership system in SQL. Is there syntax I can use to combine the following Delete statements -- or do I have to include each of these individually on my code behind page, as per below?  Thank you.

DELETE FROM aspnet_Profile WHERE UserID = @UserID
DELETE FROM aspnet_UsersInRoles WHERE UserID = @UserID
DELETE FROM aspnet_PersonalizationPerUser WHERE UserID = @UserID
DELETE FROM aspnet_Membership WHERE UserID = @UserID
DELETE FROM aspnet_Users WHERE UserID = @UserID

Record Count on MERGE Statement on Insert,Update,Delete


HI All,

How can I get the numbers of records affected in the Merge statement, INSERT,UPDATE,DELETE  separately and store it in a variable so I can get it in the application side? 



khrizz tell

Users can delete the parent folder even when they don't have delete permission on subfolders

I'm trying to use a document library to manage project documents. I created a folder for each project, and under the project folder, there are two subfolders with special permissions for confidential documents. I give normal users the Contribute permission of the project folders so they can add/remove new subfolders under the projecct folder. However, with this configuration the normal users can delete the whole project folder in the web interface, even they don't have delete permission for the two subfolders. Is there a way to prevent this? Regards, James Liang

delete node based on child value

Trying to delete a node via linq to xml but don't seem to be creating my query just right. My xml looks like this: <Index><Document>    <FriendlyName>test</FriendlyName>    <ID>f1eb6439-56dc-4f8a-a02a-c97706646643</ID>    <Post>True</Post>    <Department>Clearance</Department>    <Category>Information</Category>    <Audience></Audience>    <Link Type="Page" Target=""><![CDATA[]]></Link>    <Keywords></Keywords>  </Document></Index>   I know the ID that i want and is stored in variable myID Now I need to search my xml & find the entry that matches myID Then delete the entire Document element & all child nodes.   Here's what I've been playing with but it's just not quite there. myxmldoc.Elements("Document").Where(s => s.Element("ID").Value == myID).Remove();    Thanks ahead for the help!

Delete Parent OU from Active directory using Asp.net (C#)


 I am try to delete Parent OU using the following code.but present of child OU its not delete the Parent OU. i get Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) error.

AD OU stucture:       AA -> BB -> CC

I am try to delete AA OU using this code

DirectoryEntry objDE = new DirectoryEntry(LDAPPath, null, null, AuthenticationTypes.Secure);
DirectoryEntries objDentry = objDE.Children;
string OU = "OU=AA";
DirectoryEntry NewOUEntry = objDentry.Find(OU);          

Please help if any one knows



How to create a View to return all multiple child fields in one record?


I have an application where the users can define up to 5 extra fields for a particular table (e.g. tblMaster). The custom data is all held in one table (e.g. tblCustom) so there could be up to 5 records in tblCustom for each tblMaster record. In my application I build a select statement based on the number of custom fields so that I can get a single row of data for each tblMaster record (sample below). I am now adding new features to the application and I want to expose an SQL View to the users for a report writer that will achieve the same result but still cater for the variable number of custom fields. I realise this needs to use probably a RIGHT OUTER JOIN so that NULL is returned if there is no matching field but I can't work it out. If I had five separate files it would be easy as each one would be a RIGHT OUTER JOIN for each. I could build 6 views (e.g. with no custom fields, with one custom field, with two custom fields etc) but that is not very efficient. I don't particulaly want to restructure the database as there would be a lot of work and retesting.
Any help would be very welcome!

SELECT tblProcess.ProcessNumber, tblProcess.Process, tblProcess.Risk, tblProcess.MRR, tblProcess.Version, tblProcess.LastChange, tblProcess.SecurityLevel, 

Problem to delete treeNode along with child nodes.



i have a treeView which display organization chart as hierarchical view. i want when end-user remove a treeNode, all childs of the selected node also being removed and then update database. to do this, i've used this code :

private void btnDeleteReceiver_Click(object sender, EventArgs e)

private void DeleteNode(TreeNode node)
      foreach (TreeNode childNode in node.Nodes)
      TestDataSet.ReceiversRow receiver = node.Tag as TestDataSet.ReceiversRow;

as u see in above code, i have a recursive method which delete all child nodes of the parentNode. but i'm facing a problem to delete all childs of the node. this loop could not iterate all childs node correctly. i don't know

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

GridView Parent Child View with JQuery Effects

I was just checked how to add some more cool effects to the GridView control using JQuery. In this post I will display parent-child data in the GridView control with some help of the wonderful JQuery library.

Let's first populate the GridView control.

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.

Get Top 1 Record from Dataset

Many of them in need of getting the Top 1 or Top 10 records from a Dataset without going to SQL query. It is possible to do from Code Behind. I have given the code below,
The below code is to get single record from a Dataset. Also I have given for getting 8 records at Green Color.

SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete

Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method.

Why is that?

Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are the number of rows affected by that statement.

When checking the documentation we can see that there are some conditions that return -1.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of

rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

Enterprize library 4.1 getting output parameter after adding record in db, plz guide



I need to get output parameter (flag) from db after saving record in database. I am using Microsoft Enterprise Library 4.1 for DB. I am inserting record using I Data reader.

Please guide


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend