There is a way, but I don't recommend it. For one thing, you lose out on one of the key reasons for using a stored proc...the pre-compilation by SQL Server. Here's how you do it.... create procedure dbo.usp_Test ( @ids varchar(100) ) as declare @sql as varchar(255) set @sql = 'select * from table where tableid in (' + @ids + ')' exec(@sql) GO then you pass the ids in as a comma delimited string... exec usp_Test '1000, 1001, 1010'

Thanks for that, I had come to the same conclusion, but it's good to hear it from someone else. I wounder if any of this behaviour has changed in V1.1 of the framework? Stephen.

But you are in control of starting the thread. What I want to do is in response to a users click on the listbox, which will be triggered from an incoming windows message (WM_MOUSE_DOWN or what ever) via the forms message loop that is running on the forms main thread, therefor my thread of execution would never make it onto my thread. Make sense? Stephen.

ASP.NET seems to have an option saving session state in a SQL db instead of its memory. Depending on the scalability and usage the choice should be made. My opinion is to use SQL as after the inittial query (asuming it stays the same) the query will be cached and consequent lookups will be very quick (10 ms). :) WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

stephen woolhead wrote: I need to access a password protected Paradox table (not by choice ), and as far as I know there is no way to do that with ODBC. Ick! No idea, but I suspect you're right. stephen woolhead wrote: I have fianlly worked it out ...snip...While there is no direct link between the dataSet and the DataGrid, there are container level objects that you can access that are looking after it for you. I'm impressed. Didn't know such a thing existed, thanks. Glad to be of some help (if only pointing your mind in the right direction) and it seems I've learned something too :) Paul

I can get a normal performance counter to work no problem, what I cant get to work is the InstanceName property. If I try to access one of the existing performance counters that has multible instances that works, but I can not create my own. Bassically I have this system that can load plug-in modules at run time. I have a custom counter called 'Messages Dispatched' now under that I want to create an instance for each plugin i.e. 'E-Mail', 'SMS' etc, just like under PRocessors you can see an instance of each processor. The documentation said to pass the instance name in the constructor to ProcessCount but that does not work for me. The app starts and perfmon shows no instances, just the root performance count. Thanks Stephen.

I think I have found the cause of the problem. I have the Winsock Proxy Client installed on this machine that lets me connect to the Internet via an ISA server. If I disable the client the problem goes away. This only seemes to affect servers written in dotnet. I think I will have a look at the tracking services to see if I can find out more detail on why it is going wrong. Stephen.

Nishant S wrote: Last time I quoted you, you had used a newly invented word - "performant" I don't think he invented the word; its one of those American words that just isn't in the dictionary :) Blasted dictionaries can't always be right ;P James "And we are all men; apart from the females." - Colin Davies

Here are some articles about "Randomness" in SQL, however this article looks the closest to what you're trying to achieve. Andy Gaskell, MCSD MCDBA

I find this normally happens when there is a mixture of managed and unmanaged code compiled into 1 assembly. I could be wrong. MYrc : A .NET IRC client with C# Plugin Capabilities. See http://sourceforge.net/projects/myrc for more info. :-D

Stephen Woolhead wrote: Is there a way to say that this is the start of the namespace do not append to anything, something like ::System in C++ ? No but you can try this code example. It's an almost solution to the problem.using System; using WinSystem=System; namespace Test.System { public class Test { public static void Main(String[] args) { WinSystem.Console.WriteLine("Hello World"); } } } Jared jparsons@jparsons.org www.prism.gatech.edu/~gte477n