As Per Ur Requirement the query below is select p.parentid,p.childname,p.childid from tblCategory , tblCategory p where c.childid=p.parentid 1 Category 2 2 1 Category 3 3 2 Category 4 4 3 Category 5 5 4 Category 6 6 and also if u want to execute the query with where clause then select p.parentid,p.childname,p.childid from #temp c , #temp p where c.childid=p.parentid and p.parentid=1 Hope It help u ....:) Regards Tarini Singh Sr. Software Engineer. (IT) tksingh@zenta.com

But why would you be adding a table per user to a single dataset??

If you r writing this code in asp.net, so due to security reason this will not done, u have to use impersonation or check authentication mode. Muhammad Rashid

Yes. Sure. See, I have a 'CartList' user control. Now, this 'CartList' control contais a 'private void BindCart()' methods that binds the current product items to the grid view those are purchased by client. Now, In my 'ProductListing.aspx' I have to refresh this User Control my 'Add to Cart' button click. Now, What i have done is : 1. I have made 'private void BindCart()' methods to 'public void BindCart()'. So, I have made public methods in my UserControl. 2. I have first of all inserted all product to the 'tblCart' those are purchased by client. 3. Then, I called this Methods on 'Add to Cart' button click event. Ex. ProductCart1.BindGrid(); 4. So, Now I've a refreshed product cart on my same page. That's it. Thanks for this conversation. Regards, Abhi

Just check if there are any triggers defined for that table that set the value to be 1

I haven't given any initial value of that field in design type. Foe Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks. Regards, Abhi

http://www.codeproject.com/aspnet/multiuploads.asp[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

check the authorization of ASP.NET and NETWORKSERVICE users. i got this error 6 days ago.

Oh ! Yes. Thanks for you suggestions...