Hi Shaz I have done the SQL for the opening-balance and stock-added results: SELECT SD.productId, SUM(CASE WHEN SD.deltaDate < @StartDate THEN SD.Delta ELSE 0 END) AS OpeningStock, SUM(CASE WHEN SD.deltaDate >= @StartDate AND SD.isStockAdded = 1 THEN SD.Delta ELSE 0 END) AS StockAdded FROM StockDelta SD WHERE deltaDate < @EndDate GROUP BY productId ORDER BY productId I'll let you figure out how to do the remaining columns. The @StartDate and @EndDate bits refer to the parameters that you need to supply. The above should work for SQL-Server and Oracle. If you are using MS-Access then you will need to use the IIF function. An alternative approach would be to use sub-queries. Regards Andy

For example: YourNode.BackColor = Color.Green; YourNode.ForeColor = Color.White; SkyWalker

Ever get this to work? "The clue train passed his station without stopping." - John Simmons / outlaw programmer

Hi I can't exactly tell you what is the problem but it seems that there's a problem in finidng the directory of images.If that's the problem ,you can use Application.ExecutablePath property to get the path then combine it with the file name (for example Path.Combine(Application.ExecutablePath,"image1.pic") Regards

I see three problems with the code: 1. You clear the list outside the monitoring. 2. You enter and leave the monitoring for each item you add, leaving the list in different state every the time. 3. You never leave the monitoring when you read from the list. --- b { font-weight: normal; }

If you draw a rectangle and then update the label, the time difference should not be noticable. Most of the time they would both be drawn within the same page refresh, so there would be no delay at all. What is is that you do that is taking time? --- b { font-weight: normal; }

samtam wrote: "Server has encountered an internal error". It's an internal error, it could be anything:rolleyes:. Add a config file and set custome errors off like it says to get more information:sigh: only two letters away from being an asset

You will have to drop the return value in a place that is accessable by another thread. You will have to protect the storage with a mutex, also add a condition to signal the other thread that processing is done. This is needed because processes can't return things to eachother, instead they storage data that has to be exchanged in a central place that is accessable by others. These two steps start the threads and let the first thread wait for a signal of the other thread. Thread 1 -> Thread2.Start(); Thread 1 -> Condition.Wait(); These steps are performed by the second thread in such a way that the storage can only be accessed by one party at a time. After the second thread is done, it will signal the first thread that it's done. Thread 2 -> Mutex.Lock(); Thread 2 -> Set some value Thread 2 -> Mutex.Unlock(); Thread 2 -> Condition.Signal(); These last steps are performed after the first thread gets a signal that the second thread is done. Thread 1 -> Mutex.Lock(); Thread 1 -> Get value Thread 1 -> Mutex.Unlock(); I'm not sure to what extend Microsoft implemented threading and concurrency tools, but if you don't have the Mutex or the Condition, you can do it with a Semaphore. The same trick, except for these changes: Thread 1 -> Semaphore.P(); Thread 2 -> Set value in storage Thread 2 -> Semaphore.V(); Thread 1 -> Get value from storage This classic is also called the producer/consumer scenario. WM. What about weapons of mass-construction?

Um, if I managed to read that correctly then yes you have extracted the correct information. I think, you might want to explain a bit clearer with a few short examples in future. Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed

Hello, If you have the instance of form1 in your other class. You have to set the Members to public. public otherclass() { this.myform1instance.member1.myproperty.value = ???; } If not, let us know more about your application. All the best, Martin

You need to add a reference to that assembly.** xacc.ide-0.2.0 preview - Now in 100% C# goodness **

Well, .csproj is an MSBuild file. MSBuild is an XML format for build files, used from VS 2005 onwards. I guess you'll be better off writing your own parser using System.XML to parse out the Stuff you need from the MSBuild file[.csproj]. More Information is available here. Yuvi Panda T 15 Year old Microsoft Student Partner Blogs at : http://yuvipanda.blogspot.com

hi samtam i was also interested in this by seeing some command line arguments of csc u can little understand since there are arguments for adding things like resourses files amd modules even i didnt go for that since it involes lot of issues but sure go for that and tell me latter ok shan