Search DaniWeb - parentchild

Need help with a trigger 15 Years Ago by ferretwoman …. Here is my code: [code] CREATE TRIGGER parent_child ON parentchild FOR insert AS DECLARE @parent as nvarchar(20); DECLARE @child… @child as child from INSERTED; INSERT INTO parentchild SET parentchild.child = @childid SET parentchild.parent = @parentid SET parentchild.parentchild = @parent + " / " + @child; END … Re: Need help with a trigger 15 Years Ago by ferretwoman …20) DECLARE @parentid as numeric DECLARE @childid as numeric DECLARE @parentchild as nvarchar(40) BEGIN select @parentid = i.parent, @….parentid = i.parent @parentchild = (@parent + " / " + @child) insert into parentchild(child, parent, parentchild) values(@childid, @parentid, @parentchild) END GO [/code] … Re: Need help with a trigger 15 Years Ago by ferretwoman …20) DECLARE @parentid as numeric DECLARE @childid as numeric DECLARE @parentchild as nvarchar(40) BEGIN select @parentid = i.parent, @…p.parentid = i.parent set @parentchild = (@parent + ' / ' + @child) insert into parentchild(child, parent, parentchild) values(@childid, @parentid, @parentchild) END GO [/code] Thanks!… Re: Need help with a trigger 15 Years Ago by dickersonka you need to correct the insert statement portion [code] insert into parentchild(child, parent, parentchild) values(@child, @parentid, @parent + " / " + @child) [/code] Help me with this nested gridview 14 Years Ago by adil.hafiz652 …quot;Project"]); //DataRelation parentchild = new DataRelation("parentchild", ds.Tables["Project… rowist["ProjectID"]; // DataRow[] drow = rowist.GetChildRows(parentchild); // foreach (DataRow row2nd in drow) // { // //… Need Help asto 2-3 Trees 15 Years Ago by Umar Ali …, data2; Two3Node *lc, *mc, *rc, *par; //leftchild, rightchild, middlechild and parentchild public: Two3Node(); ~Two3Node(); }; class Two3{ private: Two3Node *root; public: Two3… ASP.Net Membership and Roles and Login Controls 13 Years Ago by sumisudhakar …[0].TableName = "Menu"; DataRelation relation = new DataRelation("ParentChild", menuSet.Tables["Menu"].Columns["MenuID"… Asp:Menu giving object reference not set error 12 Years Ago by mysitemanager …;parent") Dim relation As DataRelation relation = New DataRelation("ParentChild", parentColumn, childColumn) relation.Nested = True ds.Relations.Add(relation… Relational Data Useing DataSets 11 Years Ago by sundog1 … between the two tables oDS.Relations.Add(new DataRelation("ParentChild", oDS.Tables["Customers"].Columns["OrderID"… Adding child objects to parent 8 Years Ago by tig2810 … it. many thanks using System; using System.Collections.Generic; namespace ParentChild { class Program { static void Main(string[] args) { var Order = new… Re: Nest Datagrids 19 Years Ago by plope …) Next tbl.Rows.Add(row) Next ds = New DataSet("ParentChild") ds.Tables.Add(tbl) ds.Tables.Add(tblChild) 'don… Re: Display Related tables in DataGridView 11 Years Ago by GilbertB so how can I view related tables in two seperate Data Grid Views ? like this : http://code.msdn.microsoft.com/Windows-Form-ParentChild-9cce4e67 BUT with SQL connection Thanks Re: Need help with a trigger 15 Years Ago by dickersonka try adding the word AND in your where statement Re: Need help with a trigger 15 Years Ago by dickersonka A suggestion would be not to use numeric unless you needed to, i'm assuming parentid and childid could be int also nvarchar is used for multilingual data, if you have that keep it, otherwise use varchar Re: Need Help asto 2-3 Trees 15 Years Ago by Murtan You have a basic misunderstanding related to pointers. Pointers must be made to point to a valid storage location before they can be used to reference anything. [code=c++] class Foo { private: int mX; int my; public: Foo(); int getX(); int getY(); void setX(int x); void setY(int y); };… Re: Asp:Menu giving object reference not set error 12 Years Ago by jfarrugia i assume both front/back end code is on the master page right? Re: Asp:Menu giving object reference not set error 12 Years Ago by mysitemanager Back end code is in a code behind page. Re: Asp:Menu giving object reference not set error 12 Years Ago by mysitemanager Fixed it. There was an error in the data giving a circular reference and the [CODE]ds.GetXML[/CODE] call was outputting the error message rather than the XML code resulting in the error as it tried to bind a non-existant datasource to the menu. Re: Asp:Menu giving object reference not set error 12 Years Ago by dnanetwork check for null ...Error makes a lot sense. Re: Relational Data Useing DataSets 11 Years Ago by nmaillet Are you getting an exception? That would be helpful to have. At a quick glance, try adding the row `oDetailRow` to the table before calling `SetParentRow()`. Re: Adding child objects to parent 8 Years Ago by tinstaafl One way is to use a public method that uses the Add method of the List class: void AddOrderLine(OrderLine newOrderLine) { OrderLines.Add(newOrderLine) } I would suggest keeping the list private instead of public. This way you choose which methods the user can use to interact with the list and eliminates the possibility of… Re: Adding child objects to parent 8 Years Ago by tig2810 Hi, thanks, but i needed syntax to do it by using an Object Initialiser. I managed to work it out as below but i found the issue is that object initialisers do not call the constructor - where i initialised the list : var order = new Order { Id = 1, Description = "My First Order", OrderDate =…