SQL Server :: How To Delete From Parent And Child Table Using Sql Datasource
Dec 2, 2010
i am trying to delete using Gridview from child first and check if there is no child to delete in parent table i am using sql datasource in the delete tab in sql datasource i put DELETE FROM table1 WHERE (IDtable = @IDtable) IF (SELECT count(*) FROM table1 WHERE parent_dtl_id = 66) =0
BEGIN delete from parent_dtl where order_dtl_id= 66 END
i deleted all items,deleting from 2 tables child and parent was successfully on the last row from gridview but i have this error on my page on the last delete Specified argument was out of the range of valid values. Parameter name: value
View 2 Replies
Similar Messages:
Jan 16, 2010
I have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems
Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END
View 5 Replies
Jun 4, 2010
I have a table that have LibraryID and LibraryParentID.
LibraryID int Unchecked
Name varchar(50) Checked
Description varchar(200) Checked
LibraryLevel int Checked
LibraryParentID int Checked
LibraryTypeID int Unchecked
I want to write a sql to delete the currrent select parent and well as all child record, how can I do that?
View 4 Replies
Feb 26, 2010
I have a table that needs sorting by its hierarchial structure of parent-child.
An example of my table is below
ID
Name
Parent ID
Sort Order
1
iPhone Dev
0
1
2
iPhone Lounge
0
2
3
Web Development
0
3
17
Javascript
3
1
24
CSS
3
2
25
prototypes
17
1
As you can see above, my table structure follows this pattern
[Code]....
My overall aim is to have the sql order the table for me, and by using this new "depth" column, I will be able to indent by categories in the menu on the front end, you have probably seen this before, but all the tutorials I have read dont really explain it very well, or assume you are sql savvy.
View 2 Replies
Dec 3, 2010
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!
View 1 Replies
Jan 11, 2011
i have a table as child_id,parent_id,child_name,level i want to select all child(leaf nodes) with no further child for a particular parent in table.
[Code]....
View 1 Replies
Jul 13, 2010
I'm trying to update the data in the parent table that is referenced in the child table from the child's view in Asp.net.
I mapped the tables using Fluent Nhibernate.
In the child table, the mapping looks like this:
[code]....
View 1 Replies
Jan 15, 2010
Here is my table and data of these tables
Table name: Code
CID Code
1 abc
2 def
3 xyz
Table Name : Details
ID Name CID
1 a 1
2 b 2
Resultant Table:
ID Code Name
1 abc a
2 abc Null
3 def b
4 def Null
5 xyz Null
6 xyz Null
I nned to get all record from the code table and against each code I have to get all the rows from the details table, if some code have value their need value and if not then Null
View 1 Replies
Aug 26, 2010
Simple and blunt: my cascading dropdownlists clear when a postback occurs. Does anyone know a quick way around that?For more information, read on...
I have 5 dropdown lists that define a training class location and line of business: Site, Parent Client, Client, Program, Project I'm trying to build cascading dropdownlists that can work from any direction (i.e. select a site and all other lists are filtered by site...select a project and all other dropdown lists are filtered by project). I've built the SQL Select statement behind the lists that filters (accurately).
View 3 Replies
Feb 4, 2010
I am just getting started with entity framework with asp.net 3.5 using VS 2008
There are two tables, Categories & Subcategories:
Category table: CID, CategoryName Sub Category table: SID, CID, SubCategoryName I would like to get SID, CID, CategoryName, SubCategoryName in the gridview. Just as we write a select statement i.eSelect a.sid, b.cid, b.categoryname, b.subcategoryname from subcategories a inner join categories b on a.cid=b.cid & put the same in a gridview.
I was trying for the whole day & couldnt get atleast one url that would teach how to do it.
View 3 Replies
Sep 3, 2010
Is there a way to create a contact form that takes the name. address and other info for the master record; Then, somehow, on the same page, allow the user to enter multiple contact info as chid records (i.e. phone, email, etc.)
All this using the Objec DataSource or SQL DataSource (which ever is easy) and doesn't require writing too much code.
View 1 Replies
Nov 2, 2010
I'm a having a problem in passing the value of a variable from child package to the parent package in SSIS. either using configurations or using scripting (c# or vb.net)..
View 2 Replies
Dec 4, 2010
how to delete child records in the first step
check if there is no more child using count row number if = 0 delete the key in parent table
parent table must have always child records in my case by Using sql data source Delete tab
View 3 Replies
Feb 17, 2010
On DBML I have two entities as Parent, Child. I am trying to assign Child class properites in a Parent.
[code]....
I am getting the following Error:
Cannot access a disposed object.
Object name: 'DataContext accessed after Dispose.'.
View 2 Replies
Sep 14, 2010
I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
View 4 Replies
Jan 24, 2010
In my website I have two forms: parent form and child form(dialog box). Their expected behaviour is like this: if clicked on 'show' button on parent form, a dialog form opens that displays a gridview. In dialog form, if clicked on 'select' button it closes
itself and returns value in selected row back to parent form.
To achieve this I write following code (.cs) : in parent form:
void ShowBtn_Click(object sender, EventArgs e)
{
StringBuilder jScript = new StringBuilder(); [code]....
Now problem is: the code in parent .cs works fine, it opens the dialog properly. But when clicked on 'select', instead of returning back to parent, it opens the same dialog again in new window. This newly open window says "Done but error on page" at left bottom.
View 6 Replies
Jan 13, 2010
I have a parent page with two data controls. I want to be able to open a child window, do something on it, and when it closes I want to rebind only one of the two data controls on the parent page. I have the control I want to update within an UpdatePanel so would like to call rebind it and call UpdatePanel.Update().
View 2 Replies
Jan 5, 2011
I am deploying the solution on the server i want no user can deleted the table by using the sql injection, i want to put restriction on the table that no one can delete the table. in short drop table should not execute.
View 5 Replies
Dec 6, 2010
I have 2 tables Order and Order_Detailrder_dtl_id is the primary key Order_id is the foreign key that referrence Order_Id in Order Table
View 4 Replies
Mar 18, 2010
I have three tables:
Colour(Colour ID, Colour)
DogColours(ColourID, Dog ID)
Dog(Dog ID, Breed)
Colour ID and Dog are primary keys.
I have three web forms, one for each table. Dog colours consists of data that is already in the system from the other two tables. It basically joins a breed to a colour. My problem is this:
When i try delete a dog which is being used in dog colours the program crashes. How can i prevent this crash?
The second problem, the data source in the dog colours web form has the insert, update and delete tick boxes greyed out in the 'configure the select statement' so i am unable to delete a colour and dog joined together. how can i delete something in the dog colours?
View 13 Replies
Sep 1, 2010
a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2 Thus representing a simple "1 to many" or "parent/child" relationship in the database!
SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there).
SqlDataSource2 has parameters that filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.
HOWEVER - THE PROBLEM ARISES...
The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.
I've tried setting the SqlDataSource2 parameters to:
<SelectParameters>
<asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataKey(2)" />
</SelectParameters>
but it doesn't seem to like that approach. I'm expecting the answer is something similar .
View 1 Replies
May 14, 2010
i am new to this linq concept,
i have used the following code to delete multiple records in my table,
but when i hit the button insteading deleting multiple records only one record is getting deleted
below is the code
protected void Button1_Click(object sender, EventArgs e)
View 10 Replies
Feb 12, 2010
My code is not updating the sql database. I am definately passing the correct information in to this function, and it runs without errors. If I exec the procedure with the passed in data, it works great. Can someone tell me what is missing?
public DataTable UpdateEmailList(int listId, string connectionString, DataTable EmailList)
{
//DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(null, conn);
SqlCommand cmd = null;
//add
cmd = new SqlCommand("dbo.fp_ServiceAwards_AddEmailToList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.InsertCommand = cmd;
//delete
cmd = new SqlCommand("dbo.fp_ServiceAwards_DeleteEmailFromList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.DeleteCommand = cmd;
try
{
da.Update(EmailList);
}
catch (Exception ex)
{
string msg = ex.Message;
}
conn.Close();
conn.Dispose();
return EmailList;
}
View 3 Replies
Mar 4, 2010
How do I remove duplicate rows from a data table based upon a two column values;I want to pass in a Data Table and a column names and get the data table back with data rows where that columns value are unique.
I have a Data Table with Duplicate Rows i want to delete the duplicates rows based upon two column values if both columns values are there then Delete the row.
View 8 Replies
May 1, 2010
I've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
View 6 Replies
