I am rather certain that your given table structure requires looping. You can use either actual loops or procs (recursive) for this but the result is the same. Doing it in the database would probably be better than C# (per your other post.) If you can modify the table then there are probably other solutions. See the following link and drill down on the sublinks on it as there are other solutions. http://www.sqlteam.com/article/more-trees-hierarchies-in-sql[^] You might also try googling with the following: sql hierarchy query -cte

I am working with "SQL Server 2000 SP3 2000.80.760.0" and as I understand it does not support CTE. Are there any examples for recursive query for "SQL Server 2000" ?

Found two links: http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/dd9ccc00-7158-4235-b3e6-671711bba0a2[^] http://www.wpftutorial.net/ListBoxSelectionBackground.html[^]

I will go with "lightweight controls". I guess, I was just lazy and was looking for shortcuts. :-D

Or: e.Cancel = e.CloseReason != CloseReason.MdiFormClosing; I do never use an if for just setting a bool value.

So if I understand correctly, it is better to use one background worker (or split between just a few workers).

Thanks! :-D Cheers! Ankur ..Go Green..

It is polite to up vote a helpful answer. Never underestimate the power of human stupidity RAH

Hi, There basically are two schemes you have to choose from. 1. if the timer is a Windows.Forms.Timer and your Tick handler is short (less than 10 msec), then everything should be OK. That requires there are no blocking I/O methods called. So when your peripheral needs 200 msec to perform a data acquisition, it would only work smoothly if that gets handled asynchronously, i.e. in one timer tick you issue a "start acquisition" command without waiting for the results; and in a different handler (or a later tick of the timer) you issue a "now deliver the available data" command. 2. If the above is not possible, the alternative is to have a second thread that takes care of communicating with your peripheral and preparing the new data; it should then use the Control.InvokeRequired/Invoke pattern to update the GUI. See this little article[^]. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read formatted code with indentation, so please use PRE tags for code snippets. I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page). modified on Monday, June 7, 2010 8:39 AM

Here is my code: Class for drawing different shapes (selected by iSelectShape): public class ShapeDrawing { private int iSelectShape = 1; public int SelectShape { get { return iSelectShape; } set { iSelectShape = value; } } public void DrawShape(Graphics g) { Rectangle r = new Rectangle(new Point(0, 0), new Size(100, 100)); switch (iSelectShape) { case 1: g.DrawEllipse(Pens.Black , r); break; case 2: g.DrawRectangle(Pens.Black, r); break; } } } Custom panel class: public class MyCustomPanel : Panel { public ShapeDrawing Drawing { get; set; } protected override void OnPaint(PaintEventArgs e) { // Draw the image here using e.Graphics if (Drawing != null) Drawing.DrawShape(e.Graphics); } } And main form with one panel: public partial class Form1 : Form { public Form1() { InitializeComponent(); ShapeDrawing shape1 = new ShapeDrawing(); myPanel.Drawing = shape1; shape1.SelectShape = 2; } private void myPanel\_Paint(object sender, PaintEventArgs e) { } } and InitializeComponent private void InitializeComponent() { this.myPanel = new Dynamic_controls_panel.MyCustomPanel(); this.SuspendLayout(); // // myPanel // this.myPanel.BackColor = System.Drawing.Color.White; this.myPanel.Drawing = null; this.myPanel.Location = new System.Drawing.Point(0, 0); this.myPanel.Name = "myPanel"; this.myPanel.Size = new System.Drawing.Size(301, 331); this.myPanel.TabIndex = 0; this.myPanel.Paint += new System.Windows.Forms.PaintEventHandler(this.myPanel_Paint); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(416, 459); this.Controls.Add(this.myPanel); this.Name = "Form1";

I found the problem. It was my mistake in creating objects. I was creating object MyGraphGridClass inside one of the method of MyDivisionClass and as such it was destroyed as soon as it left that method and its properties could not be accessed. I rearranged a code and put the declaration (creation) of my object as one of the properties of my MyDivisionClass, so I can access its properties. class MyGraphGridClass { private int myProperty; public int Property { get { return myProperty; } set { myProperty = value; } } . . . } class MyDivisionClass { private MyGraphGridClass objMyGraphGrid = new MyGraphGridClass(); internal MyGraphGridClass MyGraphGrid { get { return objMyGraphGrid; } set { objMyGraphGrid = value; } } . . . } // In chid form class MyDivisionClass Graph\_01 = new MyDivisionClass(); MyDivisionClass Graph\_02 = new MyDivisionClass(); Graph\_01.MyGraphGrid.Property = 5; Graph\_02.MyGraphGrid.Property = 3; // and then use as suggested SetupForm sf = new SetupForm(Graph\_01.MyGraphGrid); Pata